firefly的专栏

Alter table TSK_REPORT   drop column DATA_ATT_ID --删除某一列Alter table TSK_REPORT   add  DATA_ATT_ID nvarchar(50)--添加某一列给此列加注释EXECUTE sp_addextendedproperty N'MS_Description', '外协任务的上传文件的附件id

select Dateadd(wk,datediff(wk,0,getdate()),0) --周一                             select Dateadd(wk,datediff(wk,0,getdate()),6) --周日select Dateadd(mm,datediff(mm,0,getdate()),0) --月初select Datead