tsql scripts 
Author Message
 tsql scripts
Is there any way to run another sql script file from within a script file,

thanks!


Mon, 09 Aug 2004 01:10:45 GMT
 tsql scripts

Try this FAQ entry at my site:
http://vyaskn.tripod.com/programming_faq.htm#q6
--
HTH,
Vyas, MVP (SQL Server)

http://vyaskn.tripod.com/


Quote:
> Is there any way to run another sql script file from within a script file,

> thanks!



Mon, 09 Aug 2004 01:14:24 GMT
 tsql scripts
ionut,

Use the osql command line utility wth the :r option. For example, you can have
this line in your script file:

:r C:\Scripts\MyScript.sql

to execute the code in that script file. This is a feature of osql and is not
supported in Query Analyzer.

Linda


Quote:
> Is there any way to run another sql script file from within a script file,

> thanks!



Mon, 09 Aug 2004 04:32:48 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. How can I script db from tsql script?

2. Running TSQL scripts in MSDE

3. TSQL Scripting of Create Table

4. Batch TSQL Script with SQLDMO

5. Long TSQL Script

6. Job with TSQL script does not work

7. Resuming after error in TSQL script

8. Job with TSQL script does nrt work

9. TSQL Script to generate SQL scripts of data in a table?

10. Is there any way to exit a TSQL script completely?

11. How-To pass variable to TSQL Script with "Create Database"

12. Scripting DB Objects using TSQL


 
Powered by phpBB® Forum Software