Add Transact-SQL Stored Procedure

This Transact-SQL stored procedure inserts a single record in the table.

Parameter Name	Type	Description
p_c1 p_c2 etc.	Depends on the field	The column values for the record. One column value is provided for each field in the database table.
p_id	INTEGER Output	Primary key value for the newly created record generated by a database sequence.

Parameter Name

Type

Description

p_c1
p_c2
etc.

Depends on the field

The column values for the record. One column value is provided for each field in the database table.

p_id

INTEGER

Output

Primary key value for the newly created record generated by a database sequence.