From a3388622287e218beddfa14a47ed677d4307b36b Mon Sep 17 00:00:00 2001 From: Fabio Bas Date: Fri, 25 Mar 2016 17:55:51 +0100 Subject: Removed simpletest and moved all tests in the unit tree Tests are executed now, but a lot of them need fixing. --- .../SqlMap/scripts/mssql/swap-procedure.sql | 34 ---------------------- 1 file changed, 34 deletions(-) delete mode 100644 tests/simple_unit/SqlMap/scripts/mssql/swap-procedure.sql (limited to 'tests/simple_unit/SqlMap/scripts/mssql/swap-procedure.sql') diff --git a/tests/simple_unit/SqlMap/scripts/mssql/swap-procedure.sql b/tests/simple_unit/SqlMap/scripts/mssql/swap-procedure.sql deleted file mode 100644 index 203ab60d..00000000 --- a/tests/simple_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