Thursday, March 8, 2012

a simple question about SQL Update statement

hi, everyone,

When I update a row that does not exist in a table using VBscript and SQL 2003 server, the row is automatically added to the table. Why does this happen?

Can somebody help me? Thanks in advance!

Hmmm, I disagree with your observation. An UPDATE statement will not perform an INSERT. You must have some other code happening behind the scenes which is performing the INSERT.|||What's the VBS code that you used for UPDATE table? BTW, there is no SQL2003 serverSmile Should be SQL2005?

No comments:

Post a Comment