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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-12 : 07:41:19
|
| ade writes "i have a column in sql server that i need to write a batch file to be updating it regulary which i need to schedule to run automatically.how do i write the batch file to ensure that the required table are the only one referenced and that the right column are updated and then that it runs at the schedule time." |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-12 : 07:59:16
|
| Hi ade, Welcome to SQL Team!When you say "batch" file does it need to do some external (DOS like) tasks, or just SQL stuff?You can schedule a "task" in SQL Server that can contain SQL commands, and run at set time intervals. (You can also schedule DOS based tasks etc. in a similar way, but if you need to do that it would be better to give a more detailed explanation of the problem you are trying to solve as there are a number of different ways to deal with those types of issues)Kristen |
 |
|
|
|
|
|
updating fields with a batch file