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)
 batch file in sql

Author  Topic 

shaggy
Posting Yak Master

248 Posts

Posted - 2006-09-04 : 02:23:01
iam new to this field. can anyone plz explain me why we are using batch file in sql

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2006-09-04 : 02:29:56
Please explain.

What is this batch file doing?

Go to Top of Page

shaggy
Posting Yak Master

248 Posts

Posted - 2006-09-04 : 02:50:32
hi timmy
Please explain.
What will the batch file do?
plzzzzzzzzz
Go to Top of Page

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2006-09-04 : 03:25:25
If I'm understanding you correctly, a batch file could be used to execute a series of commands on the database. This batch file would contain one or more calls to isql (sql command line utility) and would be executed from a DOS prompt or an NT schedule task.

A similar thing can be achieved using SQL Server jobs, but I haven't heard of anyone referring to these as 'batch files' as yet.

Can you post some details of what you're trying to do. It might clarify things a bit.
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-09-05 : 02:10:37
quote:
Originally posted by timmy

Can you post some details of what you're trying to do. It might clarify things a bit.



shaggy, maybe if you could answer timmy's question, then we will understand more of what are you trying to achieve.


KH

Go to Top of Page
   

- Advertisement -