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 2005 Forums
 Transact-SQL (2005)
 SQL Server UPDATE

Author  Topic 

sfjtraps
Yak Posting Veteran

65 Posts

Posted - 2009-03-19 : 12:16:17
In SQL Server I want to update the Name column below to FLR1 WHERE the ID column equals 5.

Name ID
FLR2 5
FLR5 5
FLR6 5

Can anyone help with this?

sakets_2000
Master Smack Fu Yak Hacker

1472 Posts

Posted - 2009-03-19 : 12:37:58
have you given it a try ?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-03-19 : 13:14:28
have a look at UPDATE t-sql statement in books online
Go to Top of Page

bklr
Master Smack Fu Yak Hacker

1693 Posts

Posted - 2009-03-20 : 00:21:00

update tablename
set name = 'FLR1'
where id = 5
Go to Top of Page
   

- Advertisement -