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
 General SQL Server Forums
 New to SQL Server Programming
 update a db

Author  Topic 

rjhe22
Constraint Violating Yak Guru

283 Posts

Posted - 2009-03-25 : 05:29:53
waht do i have to do with this sql so i can update both rows at same time
update dbo.tblClients
set CLConsultantID = 1675 and set admin = 1523
where CLID =470

matty
Posting Yak Master

161 Posts

Posted - 2009-03-25 : 05:36:49
update dbo.tblClients
set CLConsultantID = 1675 ,admin = 1523
where CLID =470
Go to Top of Page

rjhe22
Constraint Violating Yak Guru

283 Posts

Posted - 2009-03-25 : 05:53:28
how stupid do i feel. thanks
Go to Top of Page
   

- Advertisement -