blob: 203ab60d5edfa70f343edb9f44e636ff74e2d5de (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
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
|
