绑定默认值脚本
--update pay_group_item set Statistic=0 where statistic is null
--alter table pay_group_item add constraint DF_pay_group_item_Statistic default (0) for Statistic
--alter table pay_group_item add constraint DF_pay_group_item_Statistic default (getdate()) for Statistic
-----///判断表纯在并删除表
if exists(select * from sysobjects where id = object_id('person_doc'))
begin
drop table person_doc
end
---带字符查询
SELECT * FROM dbo.Sys_BaseDt WHERE BdtBseNo LIKE 'PMC\_%' ESCAPE '\'
