summaryrefslogtreecommitdiff
path: root/tests/unit/SQLMap/scripts/mssql/account-procedure.sql
blob: a18e15227c0221e3dd9c065cc7a5b9731c131df5 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
CREATE PROCEDURE dbo.[ps_InsertAccount]
@Account_ID  [int], 
@Account_FirstName [nvarchar] (40),
@Account_LastName [varchar] (32),
@Account_Email [varchar] (128),
@Account_Banner_Option  [varchar] (255),
@Account_Cart_Option [int]
AS
insert into Accounts  
			(Account_ID, Account_FirstName, Account_LastName, Account_Email, Account_Banner_Option, Account_Cart_Option) 
values 
			(@Account_ID, @Account_FirstName, @Account_LastName, @Account_Email, @Account_Banner_Option, @Account_Cart_Option)