General information
Forum:
Microsoft SQL Server
Hello:
This your code:
update product set Name = 'RocheThomas RT14 Valve Oil', set ProductTypeID = 8 where SKU = 'AE1001'
This me code:
update product
set Name = 'RocheThomas RT14 Valve Oil',
ProductTypeID = 8
where SKU = 'AE1001'
you don't have to use SET's several.
Bye.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only