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 2000 Forums
 Transact-SQL (2000)
 How to execute tsql script in batch?

Author  Topic 

aex
Yak Posting Veteran

60 Posts

Posted - 2006-09-20 : 22:53:20
Hi, i have a problem this recently where I have to execute my .sql file one by one and it is a tedious task for me. Is there any way to ease my pain here such like to run the script as a batch in one time only?

aex

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-09-20 : 23:55:06
use osql


KH

Go to Top of Page

nosepicker
Constraint Violating Yak Guru

366 Posts

Posted - 2006-09-21 : 00:33:15
osql -Uuser -Ppassword -Sserver < c:\YourSqlFile.sql
Go to Top of Page
   

- Advertisement -