diff options
author | ctrlaltca <> | 2013-01-02 14:42:24 +0000 |
---|---|---|
committer | ctrlaltca <> | 2013-01-02 14:42:24 +0000 |
commit | edf2251aca60a970e822079d23933e5b70b26571 (patch) | |
tree | 366b6688efbb03f20f47268bea57859cea673c70 /tests/unit/SQLMap/scripts/mssql/swap-procedure.sql | |
parent | 8e5f2510bd577e15095e46afc7d0ba6808549bf8 (diff) |
backported all related changes up to 3229 to branch/3.2
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
|