RE: Error Handling / Return Values
Thanks for that point Allan but how come my Execute Statement Fails to Set @ErrorsExist When errors do exist ? Thanks Andy
2003-05-27
Car Update
RE: Error Handling / Return Values
quote: DECLARE @ErrorsExist Int Select @ErrorsExist = @@Error @@ERROR Returns the error number for the last Transact-SQL statement executed. In your procedure, you assign @@error without executing any SQL statement. Edited by - Allen_Cui on 05/27/2003 08:31:32 AM
2003-05-27
RE: DTS Error when copying Tables & SPROC
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-05-23
RE: Nesting Stored Procedures
johncyriac: Nice. I added a line to see to what level nesting it did: create proc nest_sp_dec @kount int as begin select @kount select @kount=@kount-1 SELECT @@NESTLEVEL AS NESTLEVEL if @kount >0 exec nest_sp_dec @kount end and executed it with: nest_sp_dec 10 It showed a nest level of 10 and then with nest_sp_dec 33 which […]
2003-05-22
1 reads
RE: help with trivial sql query ... tried all
This is called a pivot table. If you know the number of items you are going to pivot then it is as simple as SELECT ItemNum, SUM(CASE Store WHEN 1 Then Traited ELSE 0 END) Traited1, SUM(CASE Store WHEN 1 Then Valid ELSE 0 END) Valid1, SUM(CASE Store WHEN 2 Then Traited ELSE 0 END) […]
2003-05-21
RE: SQL Server and JDBC
We have some apps that access SQL Server using JDBC. Use 3rd party drivers, Merant I think, not the MS driver. Works ok, only supports Standard Auth (by JDBC spec). Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-05-20
RE: How to pronounce SQL
Self-Contained Underwater Breathing Apparatus I bet you knew that and just wanted to test me. And as for how to pronounce. Afraid not since he is right either way and if you prefer the opposite oh well (unless you have a dictator complex).
2003-05-20
1 reads
RE: Connection can not be established
The SQL Server Agent will not start - Error 2140 Internal Windows NT error occured.
2003-05-16
RE: Identity problem!!!
This behavior is by design. SQL Server will start the identity seed so that the next value to get inserted into the table will be after the records inserted with IDENTITY_INSERT turned on. The reasoning is so that you don't come back around and get a conflict later on. Even if you were to reseed […]
2003-05-16
RE: Connection can not be established
Hi, is SQL Server Agent running? under account with appropriate rights? Cheers, Frank
2003-05-16
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers