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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Multiple sets in an update

Author  Topic 

John T.
Posting Yak Master

112 Posts

Posted - 2003-04-23 : 11:57:06
Update DailyTable
SET Vs = @Var1
SET Hs = @Var2
SET sp = @Var3
Are multiple sets allowed?
Thanks.

X002548
Not Just a Number

15586 Posts

Posted - 2003-04-23 : 11:59:19
Update DailyTable
SET Vs = @Var1
, Hs = @Var2
, sp = @Var3

But with out a predicate (WHERE Clause) you'll update ALL rows.




Brett

8-)
Go to Top of Page

John T.
Posting Yak Master

112 Posts

Posted - 2003-04-23 : 12:20:27
Thank you sir.

Go to Top of Page
   

- Advertisement -