Scribd
Upload
2 views1 page

SQL Server DDL and DML Code Examples

Uploaded by

Abdo Magdy
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views1 page

SQL Server DDL and DML Code Examples

Uploaded by

Abdo Magdy
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

SQL Server DDL & DML Examples

1. CREATE TABLE
CREATE TABLE Employee ( emp_id INT PRIMARY KEY, name NVARCHAR(20), age INT );

2. RENAME EXISTING COLUMN


EXEC sp_rename '[Link]', 'NewAge', 'COLUMN';

3. ADD NEW COLUMN


ALTER TABLE Employee ADD City NVARCHAR(10) NOT NULL DEFAULT 'Unknown';

4. CHANGE DATA TYPE OF EXISTING COLUMN


ALTER TABLE Employee ALTER COLUMN NewAge NVARCHAR(50);

5. DROP EXISTING COLUMN


ALTER TABLE Employee DROP COLUMN City;

6. INSERT DATA
INSERT INTO Employee (emp_id, name, NewAge) VALUES (5, 'Ahmed', 25), (6,
'Zoz', 30);

7. UPDATE DATA
UPDATE Employee SET name = 'Islam', City = '5anka' WHERE emp_id = 6;

8. DELETE SPECIFIC ROW


DELETE FROM Employee WHERE emp_id = 6;

9. DELETE TOP N ROWS (any 50 rows)


DELETE TOP (50) FROM Employee;

10. DELETE SPECIFIC 50 ROWS (oldest by HireDate)


DELETE FROM Employee WHERE emp_id IN ( SELECT TOP (50) emp_id FROM Employee
ORDER BY HireDate ASC );

You might also like