10 2023 档案
摘要:--为字段添加注释 --Eg. execute sp_addextendedproperty 'MS_Description','字段备注信息','user','dbo','table','字段所属的表名','column','添加注释的字段名'; execute sp_addextendedpro
阅读全文
摘要:execute sp_addextendedproperty 'MS_Description','零售客户类型对应的限时特惠价格','user','dbo','table','Fac_BuyerTypeOfferPrice',null,null;
阅读全文
摘要:SELECT DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0) AS StartOfMonth SELECT DATEFROMPARTS(YEAR(GETDATE()),MONTH(GETDATE()),1) SELECT DATEADD(DAY,1,
阅读全文