27,579
社区成员
发帖
与我相关
我的任务
分享
IF NOT exists(select * from syscolumns where name='CanExportData' and id=object_id('User'))
BEGIN
Alter Table [User] Add [CanExportData] [Bit] Default 0 NULL;
UPDATE [User] SET [CanExportData] = 0;
UPDATE [User] SET [CanExportData] = 1 WHERE [Purview] = 2
END
IF NOT exists(select * from syscolumns where name='CanExportData' and id=object_id('User'))
Alter Table [User] Add [CanExportData] [Bit] Default 0 NULL
go
UPDATE [User] SET [CanExportData] = 0
go
UPDATE [User] SET [CanExportData] = 1 WHERE [Purview] = 2
go
IF NOT exists(select * from syscolumns where name='CanExportData' and id=object_id('User'))
BEGIN
Alter Table [User] Add [CanExportData] [Bit] Default 0 NULL;
exec('UPDATE [User] SET [CanExportData] = 0;
UPDATE [User] SET [CanExportData] = 1 WHERE [Purview] = 2')
END