数据库 新增列...........................

----允许系统标更新------------------------------
exec sp_configure 'allow updates','1'
go
reconfigure with override
go
-------------------------------------------------


Alter table TbAbc add DescName nvarchar(40)---品名

---更新 Prodid 之后列 顺序
update syscolumns set ColId = colId + 1 where colId >=7  and id = object_id('TbAbc')
update syscolumns set colid=7 where name='DescName' and id=object_id('TbAbc')



----禁用系统标更新----------------------------------------
exec sp_configure 'allow updates','0'
go
reconfigure with override
go
----------------------------------------------------------