summaryrefslogtreecommitdiff
path: root/tests/unit/SQLMap/scripts/mssql/ps_SelectAccount.sql
blob: 668913cec1785f796a60bfefe98c772387694259 (plain)
1
2
3
4
5
6
7
8
9
10
CREATE PROCEDURE dbo.[ps_SelectAccount]
@Account_ID  [int]
AS
select
	Account_ID as Id,
	Account_FirstName as FirstName,
	Account_LastName as LastName,
	Account_Email as EmailAddress
from Accounts
where Account_ID = @Account_ID