[IWE] requesting help with T-SQL on Sysobjects table
golf_lover44
iwe@warhead.org.uk
Tue, 9 Jan 2007 15:12:23 -0800 (PST)
Here is the T-SQL code that I want to perform:
declare @B int
if exists (select @B = uid
from sysobjects
where name = 'temprbsa33' and
type = 'U')
begin
case
when @B = 10 then drop table sabreguest.temprbsa33
when @B = 1 then drop table temprbsa33
end
end
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com