Thanks to all responded ...


Shibu


-----Original Message-----
From: Hervén Stefan [mailto:stefan.[Email Address Removed] Tuesday, December 10, 2002 2:05 PM
To: Shibu MB; LazyDBA.com Discussion
Subject: RE: Creating sql using sql


Try


--
-- NO CHECK FK
--

DECLARE @FKTable varchar(200)
DECLARE @PKTable varchar(200)
DECLARE @FKName varchar(200)

DECLARE t_cursor CURSOR FOR
SELECT b.name "FKTable", c.name "PKTable", d.name "FKName"
FROM sysforeignkeys a, sysobjects b, sysobjects c, sysobjects d
WHERE a.fkeyid = b.id
AND a.rkeyid = c.id
AND a.constid = d.id
AND b.type = 'U'


--
-- DISABLING FK
--
OPEN t_cursor
FETCH NEXT FROM t_cursor INTO @FKTable, @PKTable, @FKName
WHILE @@FETCH_STATUS = 0
BEGIN

EXEC ('ALTER TABLE ' + @FKTable + ' NOCHECK CONSTRAINT ' + @FKName)

FETCH NEXT FROM t_cursor INTO @FKTable, @PKTable, @FKName
END
CLOSE t_cursor

GO


-----Original Message-----
From: Shibu MB [mailto:[Email Address Removed] den 10 december 2002 09:24
To: LazyDBA.com Discussion
Subject: Creating sql using sql


Hi all

In oracle i used to create sql statements using sql
For example :

sql> spool aa.txt
sql> select ' alter table ' || table_Name || ' disable constraint ' ||
constraint_Name ||';' from user_constraints;


sql> spool off
sql> @aa.txt


How can i do the same in sqlserver ?? Can anyone give me an example of
this ..........


Thanks
Shibu

MS Sql Server LazyDBA home page