Mssql
sbtawfn
这个作者很懒,什么都没留下…
展开
-
Mssql存储过程实例
CREATE PROCEDURE FYZ_ImportData AS declare @index1 int set @index1 = 1 while(@index1 begin insert into a values(1,2,3); set @index1 = @index1 + 1 end原创 2012-08-01 11:26:56 · 223 阅读 · 0 评论 -
Mssql查看、修改表字段默认值
1。select b.name from syscolumns a,sysobjects b where a.id=object_id('表名') and b.id=a.cdefault and a.name='data_name' and b.name like 'DF%' 2。alter table 表名 drop constraint DF_SYS_ENTITY_DATA_ENTITY_N原创 2012-08-01 12:01:24 · 418 阅读 · 0 评论