Mega Code Archive
Pass value into a procedure and insert it to a table
<![CDATA[
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
]]>