Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Executing a SQL script inside another sql script

Author  Topic 

sudha12345
Starting Member

47 Posts

Posted - 2009-06-08 : 06:17:49
wih me i has 4 sql scripts. i dont want to execute the sql scripts individually as the requirement doesnt want like that.Instead they want all the sql scripts inside a sql query by placing 4 files one by one. is it possible to do like that( it povides to comment the script what they dont want to execute) .

How can we do that

Sudhakar

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-06-08 : 07:00:57
For example:
You can have 4 Stored Procedures each for one of your 4 scripts.
You can have fifth Stored Procedure to call that procedures according to given parameter(s).


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -