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 - 2001-09-24 : 01:10:24
|
| Oisin writes "My Table Schema:Create Table dbo.a8shop_data ( xml text Null xml Default (''), datecreated datetime Null Default (getdate()), tag varchar(128) Not Null, datemodified datetime Null Default (getdate()), flags int Null Default (0), guid uniqueidentifier Not Null Default (newid()), category uniqueidentifier Null)My Simple SQL statement: update a8shop_data set xml = '<xml/>', set tag = 'Test', set category = '{A630C8B0-8483-4118-9E79-1A2DC559A7A5}' where guid = '{BB875865-FD6F-4A93-9BE2-5618B4788CEB}'This _fails_ with the error "Incorrect Syntax near the keyword SET". I have no idea why, but I've isolated it down to the attempt to set the category because without this line, it works ok.I am completely lost. If you can help, I'd be very grateful.Thanks,- Oisin" |
|
|
|
|
|
inserting GUID into UNIQUEIDENTIFIER field without NEWID()