创建临时表

if exists (select * from tempdb.dbo.sysobjects where id = object_id(N'[#T_Column5_O]'))
Begin
drop table #T_Column5_O;
End
CREATE TABLE #T_Column5_O (
id int identity(1,1) not null,
T_NUM1 VARCHAR(20) NULL,
T_NUM2 VARCHAR(20) NULL,
T_NUM3 VARCHAR(20) NULL,
T_NUM4 VARCHAR(20) NULL,
T_XS REAL,
T_S REAL,
T_M REAL,
T_L REAL)

posted @ 2022-01-27 09:39  淡淡的思绪  阅读(32)  评论(0)    收藏  举报