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 |
|
daniel.newman@bis-web.net
Yak Posting Veteran
71 Posts |
 Posted - 2001-07-10 : 06:35:46
|
| I want to write a multiple insert statement, which I can do in mySQL, but it doesn't work in MSsql (I thought they used the same language!). The following code is similar to what I want to write.insert into CurrentRecordCount(TodaysDate,MaxCount,TableName)values (getdate(),0,'PressReleases'),(getdate(),0,'FinancialResults')Is there a SQL version for doing this, as apposed to writing many seperate insert statements?Thank you,Daniel Newman. |
|
|
|
|
|
Multiple insert statement