What's wrong with this statement? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

What's wrong with this statement?

Message

From

21/03/2005 16:47:53

Jon Rosenbaum
Millennium Systems International
Parsippany, New Jersey, United States

To

21/03/2005 16:34:53

Paul Acton
Tri-Technical Systems, Inc.
Dubuque, Iowa, United States

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Re: What's wrong with this statement?

Miscellaneous

Thread ID:

00997959

Message ID:

00997961

Views:

19

>update product set Name = 'RocheThomas RT14 Valve Oil', set ProductTypeID = 8 where SKU = 'AE1001'

Paul,

I'm pretty sure the issue is that you don't need the second "set" in your statement (just before ProductTypeID).

Laterness,
Jon

Jon Rosenbaum
Devcon Drummer

Click here to load this message in the networking platform