diff options
Diffstat (limited to 'tests/unit/Data/SqlMap/scripts/mssql/account-procedure.sql')
| -rw-r--r-- | tests/unit/Data/SqlMap/scripts/mssql/account-procedure.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/tests/unit/Data/SqlMap/scripts/mssql/account-procedure.sql b/tests/unit/Data/SqlMap/scripts/mssql/account-procedure.sql new file mode 100644 index 00000000..fdb5c3d9 --- /dev/null +++ b/tests/unit/Data/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) |