22,209
社区成员
发帖
与我相关
我的任务
分享
if not exists(select * from SYSOBJECTS where name=@fieldvalue)
begin
set @TempSql='create table '+@fieldvalue+'(DataTime datetime not null,PointCode varchar(20) not null,FactorID int not null,DataType int not null,dataValue decimal(18,8) null,ConvertValue decimal(18,8) null,StateValue varchar(1) null,WriteTime datetime null,DevCode varchar(10) null,constraint PK_'+@fieldvalue+' primary key (DataTime,FactorID))'
exec(@TempSql)
end
CREATE TRIGGER safety
ON DATABASE
FOR DROP_TABLE, ALTER_TABLE
AS
PRINT 'You must disable Trigger "safety" to drop or alter tables!'
ROLLBACK ;