Tuesday, December 28, 2004

I'm still assimilating little tidbits of information about the Nov-Dec CTP build. Put this one in your pubs database in the CTP:

create procedure deletejob (@id int)
as
begin try
 delete jobs where job_id = @id
end try
begin catch
 -- you knew about these
 print error_number()
 print error_message()
 print error_severity()
 print error_state()
 -- these are undoc'd but work in the CTP
 print error_line()           -- line number
 print error_procedure()  -- procedure name
end catch
go

execute deletejob 2
go

Tuesday, December 28, 2004 11:27:46 PM (Pacific Standard Time, UTC-08:00)  #    Comments [0]  |  Tracked by:
"play roulette" (play roulette) [Trackback]
"Tramadol." (Tramadol.) [Trackback]
"Phentermine no prescription." (Best site for phentermine prescription.) [Trackback]

Theme design by Jelle Druyts

Pick a theme: