11 2012 档案
摘要：保存一些标准的SQL句，持续更新...1 列修改增加列IF NOT EXISTS (SELECT * FROM SYSCOLUMNS WHERE ID=OBJECT_ID('QueryDataSource') and name = 'IsCrossTable') BEGIN ALTER TABLE QueryDataSource ADD IsCrossTable bit default(0) --插入字段 END删除列ALTER TABLE AC_TYPE DROP COLUMN ACCATEGORY_ID,ACCATEGORY_GUID;修改列 alter t
阅读全文
