diff options
Diffstat (limited to 'tests/unit/SQLMap/scripts/mssql/swap-procedure.sql')
-rw-r--r-- | tests/unit/SQLMap/scripts/mssql/swap-procedure.sql | 34 |
1 files changed, 0 insertions, 34 deletions
diff --git a/tests/unit/SQLMap/scripts/mssql/swap-procedure.sql b/tests/unit/SQLMap/scripts/mssql/swap-procedure.sql deleted file mode 100644 index 203ab60d..00000000 --- a/tests/unit/SQLMap/scripts/mssql/swap-procedure.sql +++ /dev/null @@ -1,34 +0,0 @@ -CREATE PROCEDURE dbo.[ps_swap_email_address]
-@First_Email [nvarchar] (64) output,
-@Second_Email [nvarchar] (64) output
-AS
-
-Declare @ID1 int
-Declare @ID2 int
-
-Declare @Email1 [nvarchar] (64)
-Declare @Email2 [nvarchar] (64)
-
- SELECT @ID1 = Account_ID, @Email1 = Account_Email
- from Accounts
- where Account_Email = @First_Email
-
- SELECT @ID2 = Account_ID, @Email2 = Account_Email
- from Accounts
- where Account_Email = @Second_Email
-
- UPDATE Accounts
- set Account_Email = @Email2
- where Account_ID = @ID1
-
- UPDATE Accounts
- set Account_Email = @Email1
- where Account_ID = @ID2
-
- SELECT @First_Email = Account_Email
- from Accounts
- where Account_ID = @ID1
-
- SELECT @Second_Email = Account_Email
- from Accounts
- where Account_ID = @ID2
|