SQL Server Simple Query

Insert multiple rows of data:
1.insert into ... Select to extract data from one table into another existing table
2.select into extracting data from a table into a new table
3.insert into ()
Union
List of Select constants

second, simple query
1. Querying all rows and columns SELECT * from table name
2. Query section column SELECT column list from table name
3. Query partial row SELECT column list from table name WHERE column operator value
4. Column alias: SELECT column [as] alias, alias = column from table name WHERE condition
5. Constant Columns
6. Query data is Null:is null/is NOT null
7. Check the first few records: Top N[percent]
8. Query for non-repeating data: SELECT DISTINCT column from table name
9. Sort:
SELECT column list from table name
Order BY column 1 [asc| DESC], column 2 [asc| DESC]

SQL Server Simple Query