From edf2251aca60a970e822079d23933e5b70b26571 Mon Sep 17 00:00:00 2001
From: ctrlaltca <>
Date: Wed, 2 Jan 2013 14:42:24 +0000
Subject: backported all related changes up to 3229 to branch/3.2

---
 tests/unit/SQLMap/scripts/mssql/swap-procedure.sql | 34 ----------------------
 1 file changed, 34 deletions(-)
 delete mode 100644 tests/unit/SQLMap/scripts/mssql/swap-procedure.sql

(limited to 'tests/unit/SQLMap/scripts/mssql/swap-procedure.sql')

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
-- 
cgit v1.2.3