sql2005导向2000

参考http://www.wangchao.net.cn/bbsdetail_1786752.html

sys.objects替换成sysobjects

 

WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]去掉

 

object_id 替换成 id，注意是小写的object_id,有个同名的函数是大写的