Current Headline

Listen to Your Daily Tune's

Saturday, September 11, 2010

Updating Table in Sql Server 2005-2008


--Data Manipulation Commands

--Updating Values in Table

UPDATE xpertzoneblogspot

SET    name1 = 'XpertBlog',

       xdate = '2010-09-11',

       salary = 20000

WHERE  id = 2



--- selecting our table again

SELECT * FROM   xpertzoneblogspot


No comments:

Post a Comment

Related Posts with Thumbnails

Xpert-Zone Blog Overview