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 |
|
rtutus
Aged Yak Warrior
522 Posts |
 Posted - 2006-09-01 : 12:07:41
|
| when we get something like this in QA:Server: Msg 170, Level 15, State 1, Line 3Line 3: Incorrect syntax near ','.I only have 3 lines inclusing only one insert. How do I know what value or keyword is wrong from the error message above.Thanks |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-09-01 : 12:16:32
|
Check BOL for proper syntax  Generally, as and when you get more experience with such errors, your understanding of where the error is located - increases. Just a careful scrutiny should help you to locate the error.Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-09-01 : 12:18:59
|
| Not too much you can do but if you break the statement down into more lines (put new lines after ever major part of the statement, like select, from , where, and group by all on different lines, and even put each column in the select on a new line) it sometimes makes it easier. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-09-01 : 12:21:35
|
| Post the query you usedMadhivananFailing to plan is Planning to fail |
|
|
|
rtutus
Aged Yak Warrior
522 Posts |
Posted - 2006-09-01 : 13:16:08
|
| Thank you guys 4 your help, I got the idea. |
|
|
|
|
|
|
how do we locate exactly the line number of the er