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 - 2003-10-07 : 07:52:31
|
| Kartik Goyal writes "I have a three Tables in a database and I want to Create a text/batch File storing the syntex to insert valuse in the tables like: Insert Into TableName Values('Value1','Value2'............) Insert Into TableName Values('Value1','Value2'............) Insert Into TableName Values('Value1','Value2'............) Insert Into TableName Values('Value1','Value2'............) Insert Into TableName Values('Value1','Value2'............)Is it possible..? If yes then please let me know how can i do this?thx" |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-10-07 : 11:23:34
|
| I'm assuming the "VALUES" clause is going to get he data from somewhere?Yes?If so where?If you just want to save INSERTS in to a table, I would ask why?Brett8-)SELECT @@POST FROM Brain ORDER BY NewId()That's correct! It's an AlphaNumeric! |
 |
|
|
|
|
|
Create A Batch File To Insert Values in the Database / Table