Monday, February 13, 2012

Beginner Stored Procedure Help

If create a stored procedure like this:
create procedure dbo.usp_trxn_enum
(
@.a_trxn_type_cd char(2) = null
, @.a_allowed_mainframe_file_cd char(7) = null
)
<snip other code>
Is it executed like this:
exec dbo.usp_trxn_enum 'XX', 'XXXXXXX'
Thanks,
--
JerryYes.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Jerry" <jerryalan@.gmail.com> wrote in message
news:1156878844.414057.127090@.74g2000cwt.googlegroups.com...
If create a stored procedure like this:
create procedure dbo.usp_trxn_enum
(
@.a_trxn_type_cd char(2) = null
, @.a_allowed_mainframe_file_cd char(7) = null
)
<snip other code>
Is it executed like this:
exec dbo.usp_trxn_enum 'XX', 'XXXXXXX'
Thanks,
--
Jerry|||Jerry wrote:
> If create a stored procedure like this:
> create procedure dbo.usp_trxn_enum
> (
> @.a_trxn_type_cd char(2) = null
> , @.a_allowed_mainframe_file_cd char(7) = null
> )
> <snip other code>
> Is it executed like this:
> exec dbo.usp_trxn_enum 'XX', 'XXXXXXX'
> Thanks,
>
Yes, or
EXEC dbo.usp_trxn_enum
@.a_trxn_type_cd = 'XX',
@.a_allowed_mainframe_file_cd = 'XXXXXXX'
Tracy McKibben
MCDBA
http://www.realsqlguy.com

No comments:

Post a Comment