34,576
社区成员
发帖
与我相关
我的任务
分享
USE Application_db_S
GO
IF OBJECT_ID(N'#tempTable',N'U') IS NOT NULL
drop table #tempTable;
go
USE Application_db_S
go
SET NOCOUNT ON
SELECT * INTO #tempTable from dbo.MDTEN;
declare @w_Val int
select @w_Val = count(*) from #tempTable;
print @w_Val
go
IF OBJECT_ID(N'#tempTable',N'U') IS NOT NULL
drop table #tempTable;
go
--改为:
IF OBJECT_ID(N'tempdb.dbo.#tempTable') IS NOT NULL
drop table #tempTable;
go
go