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 |
|
bubberz
Constraint Violating Yak Guru
289 Posts |
 Posted - 2007-10-04 : 10:51:22
|
| We're using SQL Server 2000 and Query Analyzer to do about 8 insert statements all separated by a semi-colon. We've checked the data, and the inserts are working correctly.In the middle of the results coming back via the results pane, we see "0 rows affected".What does this mean?Thanks! |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-10-04 : 10:57:26
|
| It means no records inserted for a particular insert statement execution.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
bubberz
Constraint Violating Yak Guru
289 Posts |
Posted - 2007-10-04 : 13:24:19
|
| For each of the 8 inserts, the new records were in fact inserted.The insert statements used a select statement to grab the data.Even though there were 8 inserts, the execution window showed almost triple that. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-04 : 13:51:35
|
| Post the code and the output.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-10-09 : 05:53:40
|
| I noticed you said "in the middele of" , what does it say at the end?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com/SQL |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-09 : 06:19:41
|
Do you get 8 responses too?Do you have a trigger on the table?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-09 : 06:52:47
|
| Does Merge replication still do that multiple-result-thingie? |
|
|
|
|
|
|
Query Analyzer shows 0 rows affected during insert