if object_id(N'tempdb..#K_User',N'U') is not null
begin
--删除临时表
DROP Table #K_User
end
--重新创建临时表
select * into #K_User from (select * from Users where UserID=27) as a
--临时表的使用
select #K_User.SerialNumber from #K_User
if object_id(N'tempdb..#K_User',N'U') is not null
begin
--删除临时表
DROP Table #K_User
end
--重新创建临时表
select * into #K_User from (select * from Users where UserID=27) as a
--临时表的使用
select #K_User.SerialNumber from #K_User