Francisco H Tapia
my.lists at verizon.net
Fri Aug 29 14:44:25 CDT 2003
I have the following similar statement in a tsql procedure that errors
out telling me that there already is a #tmp object in the database... if
I read the TSQL correctly, the #TMP does not acctually get created on
the ELSE statement if the 1=1 statement is true. So why the error?
Thanks in advance....
IF 1= 1 BEGIN
IF EXISTS (SELECT * FROM tempdb.dbo.sysobjects WHERE ID =
OBJECT_ID(N'tempdb..#tmp')) BEGIN
DROP TABLE #tmp
END
CREATE TABLE #tmp(tID INT IDENTITY (1,1) NOT NULL,Hcode VARCHAR(50))
END
ELSE BEGIN
IF EXISTS (SELECT * FROM tempdb.dbo.sysobjects WHERE ID =
OBJECT_ID(N'tempdb..#tmp')) BEGIN
DROP TABLE #tmp
END
CREATE TABLE #tmp(tID INT IDENTITY (1,1) NOT NULL,Hcode VARCHAR(50))
END
--
-Francisco