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


Read More ....

Deleting Data from Table in Sql Server 2005-2008


--Data Manipulation Commands

--- how to select values from the table

SELECT *

FROM   xpertzoneblogspot



--Deleting  values in our table always perform in your database with one unique coloumn

DELETE FROM xpertzoneblogspot

WHERE  id = 1



--- selecting our table again

SELECT *

FROM   xpertzoneblogspot 





3M 17003-VP-3PK Command Adhesive Large Hooks Value Pack 
3M Command 17023P Large Mounting Replacement Strips

Read More ....

Inserting Data in Sql Table




--Data Manipulation Commands

--Inserting values in our table

INSERT INTO xpertzoneblogspot

VALUES     (1,

            'xpert',

            Getdate(),

            1000)



INSERT INTO xpertzoneblogspot

VALUES     (2,

            'Blog',

            Getdate(),

            2000)



INSERT INTO xpertzoneblogspot

VALUES     (3,

            'Spot',

            '2010-09-11',

            4000)



--- how to select values from the table

SELECT *

FROM   xpertzoneblogspot 



Microsoft SQL Server 2008 R2 Unleashed

Read More ....

Creating Tables in SQL SERVER 2005-2008


Learning SQL

Read More ....

Related Posts with Thumbnails

Xpert-Zone Blog Overview