34,838
社区成员




IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'#A') AND type in (N'U'))
DROP TABLE #A
[/quote]这种通常在调试阶段才需要,一般调用SP的时候不需要,但是创建前判断也不是不可以
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'#A') AND type in (N'U'))
DROP TABLE #A