SQL Server
code_long
这个作者很懒,什么都没留下…
展开
-
删除数据库中所有的表
--删除表之前,先删除所有的字段约束DECLARE c1 cursor for select 'alter table ['+ object_name(parent_obj) + '] drop constraint ['+name+']; ' from sysobjects where xtype = 'F'open c1declare @c1 varchar(80原创 2013-08-13 16:31:22 · 609 阅读 · 0 评论 -
SQL Server 禁用外键约束和启用外键约束及删除表数据
--禁止约束DECLARE DEL_CONSTRAINT CURSOR FOR SELECT 'ALTER TABLE '+OBJECT_NAME(PARENT_OBJ)+' NOCHECK CONSTRAINT '+NAME+';' FROM SYSOBJECTS A LEFT OUTER JOIN SYSCOMMENTS B ON A.ID = B.ID WHERE A.XTYPE =原创 2013-09-06 12:05:10 · 1015 阅读 · 0 评论 -
SQL SERVER游标遍历对象
DECLARE @TabName VARCHAR(100)DECLARE test_Cursor CURSOR LOCAL FOR SELECT Name FROM SysObjects Where XType='U' ORDER BY NameOPEN test_Cursor FETCH NEXT FROM test_Cursor INTO @TabName WHILE @@FETCH原创 2017-08-03 11:26:22 · 318 阅读 · 0 评论