11,849
社区成员
发帖
与我相关
我的任务
分享
、
还没明白?
那这样
alter proc kasa
as
begin
EXEC('SELECT * INTO # FROM tb;
select * from #')
if exists(SELECT * FROM #)
print 'OK'
end
alter proc kasa
as
begin
SELECT * INTO # FROM tb
if exists(SELECT * FROM #)
print 'OK'
end
exec kasa
select * into #T from tb1 where 1<>1
select * from #T
select object_id('tempdb.dno.#T')