tests/unit/Data/SqlMap/scripts/mssql/ps_SelectAccount.sql


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