Insert Data « Transact SQL « SQL Server / T-SQL

1.Insert data to a table in the procedure
2.Checks for existing Product record: update or insert
3.Insert command and variables
4.Insert all statements in a batch or to roll back the entire statement group if an error occurs
5.Stored procedure: accepts a ID, name and city and inserts them as new row
6.Managing Inserts Using Stored Procedures