Describe the use of Into and From clause with examples

Describe the use of Into and From clause with examples.

INTO: The INTO keyword inserts data from one table into another. It is commonly used in SELECT statement. It is useful in creating back ups.

SELECT * INTO new_table FROM old_table

Example: Copy all columns from table customer into customer_backup
SELECT * INTO Customer_backup FROM customer

FROM: the FROM clause selects rows from the table specified.

SELECT * FROM table_name

Example: Select all columns from a table customer
SELECT * FROM Customer
Where, group by and having clause
WHERE: Where clause in a SELECT query is used to retrieve specific records that meet the specified criteria.......
What is SQL Server Identifier?
Everything in a SQL server can have an identifier. Be it server, view, trigger, column etc. any database object name is an identifier. Identifiers may or may not be required for all objects.........
What are classes of identifier?
There are two classes of identifier. These identifiers must contain 1 to 128 characters......
Post your comment