Pass value into a procedure and insert it to a table : Insert Statement « Transact SQL « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Transact SQL
3. Insert Statement

5> create table Billings (
6>     BankerID           INTEGER,
7>     BillingNumber      INTEGER,
8>     BillingDate        datetime,
9>     BillingTotal       INTEGER,
10>     TermsID            INTEGER,
11>      BillingDueDate     datetime ,
12>      PaymentTotal       INTEGER,
13>      CreditTotal        INTEGER
14>
15>  );
16>  GO
1>
2>
3>
4> CREATE PROC usp_AddBillings
5> @ClassIDval int
6> AS
7> INSERT Billings (BankerID)VALUES (@ClassIDval)
8> GO
1>
2> EXEC usp_AddBillings 2
3> GO

(1 rows affected)
1>
2>
3> drop PROC usp_AddBillings;
4> GO
1> drop table Billings;
2> GO