SQL Server
code_long
这个作者很懒,什么都没留下…
展开
-
删除数据库中所有的表
--删除表之前,先删除所有的字段约束 DECLARE c1 cursor for select 'alter table ['+ object_name(parent_obj) + '] drop constraint ['+name+']; ' from sysobjects where xtype = 'F' open c1 declare @c1 varchar(80原创 2013-08-13 16:31:22 · 577 阅读 · 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 · 987 阅读 · 0 评论 -
SQL SERVER游标遍历对象
DECLARE @TabName VARCHAR(100) DECLARE test_Cursor CURSOR LOCAL FOR SELECT Name FROM SysObjects Where XType='U' ORDER BY Name OPEN test_Cursor FETCH NEXT FROM test_Cursor INTO @TabName WHILE @@FETCH原创 2017-08-03 11:26:22 · 309 阅读 · 0 评论