SQL Server Learning

To clear the data sheet:

Delete from TableName clears all data from the table, preserving the structure of the table

TRUNCATE TABLE TableName clears all rows in the table, preserving the tables structure (reset ID)

Delete a table

drop table TableName Delete all data and table structure

Create a table

CREATE TABLE Student
(
ID int identity (primary key)--Auto Grow (start value, increment) set as primary key
Stuname nvarchar (Max),
Stuage DateTime,
Stusex nvarchar (10)

)

Merging two result sets

SELECT column_name (s) from Table_name1unionselect column_name (s) from table_name2

Note : By default, the UNION operator chooses a different value. If duplicate values are allowed, use UNION all.

SQL Server Learning