summaryrefslogtreecommitdiff
path: root/tests/simple_unit/SqlMap/scripts/mssql/account-procedure.sql
diff options
context:
space:
mode:
Diffstat (limited to 'tests/simple_unit/SqlMap/scripts/mssql/account-procedure.sql')
-rw-r--r--tests/simple_unit/SqlMap/scripts/mssql/account-procedure.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/tests/simple_unit/SqlMap/scripts/mssql/account-procedure.sql b/tests/simple_unit/SqlMap/scripts/mssql/account-procedure.sql
new file mode 100644
index 00000000..a18e1522
--- /dev/null
+++ b/tests/simple_unit/SqlMap/scripts/mssql/account-procedure.sql
@@ -0,0 +1,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)