ifexists(select*fromsysobjectswheretype=Pandname=NP_DeleteAllData)
dropprocedureP_DeleteAllData
go
CREATEPROCEDUREP_DeleteAllData
as
EXECsp_MSForEachTableALTERTABLE?NOCHECKCONSTRAINTALL--禁用束缚
EXECsp_MSForEachTableALTERTABLE?DISABLETRIGGERALL--禁用触发器
EXECsp_MSForEachTableDELETEFROM?--删除一切表中的数据
EXECsp_MSForEachTableALTERTABLE?CHECKCONSTRAINTALL--启用束缚
EXECsp_MSForEachTableALTERTABLE?ENABLETRIGGERALL--启用触发器
go