DML-Data Manipulation Language

24/05/2011 12:47

SELECT    *
FROM    dbo.TblEmpDetails(nolock)

SELECT    *
FROM    dbo.TblEmpDetails(nolock)
WHERE    EMPID='EMP100'

SELECT    EmpId,EmpName,Address,Age
FROM    dbo.TblEmpDetails(nolock)

SELECT    EmpId
FROM    dbo.TblEmpDetails(nolock)

SELECT    top 3 *
FROM    dbo.TblEmpDetails(nolock)

-------------------------------------------------------------------------
--DML :- Data Manipulatin Language:-
----------------------------------

INSERT/DELETE/UPDATE/TRUNCATE/SELECT :-

--INSERT is used to insert the valus into Tables :-

INSERT    INTO dbo.TblEmpDetails
(
        EmpId,EmpName,Address,City,Country,pincode,
        DOB,DOJ,salary,Gender,Age,Height,BranchCode
)
VALUES
(        
        'EMP100','Shakar','Namakkal','Salem','India',937015,
        '10/09/1983','10/10/2004',50000.00,0,27,5.1,'CH09'

)


INSERT    INTO dbo.TblEmpDetails    VALUES
(        
        'EMP105','Saravanan','Namakkal','Salem','India',937015,
        '10/09/1983','10/10/2004',50000.00,0,27,5.1,'CH09'

)

INSERT    INTO dbo.TblEmpDetails    
(
        EmpId,EmpName,Address
)
VALUES
(        
        'EMP102','Raja','Namakkal'
)

INSERT    INTO dbo.TblEmpDetails    
(
        EmpId,EmpName,Address
)
SELECT
        'EMP103','Maha','Namakkal'

--COPY the Existng Table values into New Table:-

SELECT *
INTO    dbo.TblEmpDetailsNew
FROM    dbo.TblEmpDetails

SELECT    *
FROM    dbo.TblEmpDetailsNew WITH (NOLOCK)


--COPY the Existng Table values into New Table without creating new table:-

INSERT INTO    dbo.TblEmpDetailsNew
SELECT    *    
FROM    dbo.TblEmpDetails
WHERE    EMPID='EMP105'

---------------------------------------------------------------------------------------------------------------

--UPDATE Values into Table :-

UPDATE    dbo.TblEmpDetails
SET        EmpName='Shankar.K',
        Address='Chennai',
        BranchCode='CHE999'
WHERE    EmpID='EMP100'
--------------------------------------------------------------------------------------------------

--DELETE :-

--Delete is used to delete the values from the Existing Tables:-

DELETE
FROM    dbo.TblEmpDetails -- It will delete all the records from the table.

DELETE
FROM    dbo.TblEmpDetails
WHERE    EmpID='EMP103'    -- It will delete the particular record from the table.

------------------------------------------------------------------------------------------------
--TRUNCATE    :- Errase whole data from the Table:

TRUNCATE TABLE    dbo.TblEmpDetailsNew

--Diff : We can't filter the Data while deleting,means we cant use where condition here
--It wont insert the details into Transaction Log but while using DELETE it will insert.

-------------------------------------------------------------------------------------------------

 

Back