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
 Updating

Author  Topic 

Adam West
Constraint Violating Yak Guru

261 Posts

Posted - 2009-07-20 : 14:34:03
I am having trouble updating a table in my testserver using the Management studio.

Can someone post the correct syntax ? I want to post some data into some records on a particular field.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-07-20 : 14:37:00
UPDATE Table1
SET Col1 = {New value here}
WHERE SomeCol = {Some value here}


N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

rohitkumar
Constraint Violating Yak Guru

472 Posts

Posted - 2009-07-20 : 14:37:07
http://www.lmgtfy.com/?q=sql+update+syntax
Go to Top of Page
   

- Advertisement -