Home
SQL Server / T-SQL
Aggregate Functions
Analytical Functions
Constraints
Cursor
Data Set
Data Type
Database
Date Timezone
Index
Insert Delete Update
Math Functions
Select Query
Sequence
Store Procedure Function
String Functions
Subquery
System
Table
Table Joins
Transact SQL
Transaction
Trigger
View
XML
Insert Data « Transact SQL « SQL Server / T-SQL
SQL Server / T-SQL
Transact SQL
Insert Data
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