Developement Helper (C#.NET,ASP.NET,MSSQL)
This is the place to clarify your needs and queries.
Tuesday, June 10, 2014
MSSQL - Optional parameter for procedure
ALTER
PROCEDURE
[dbo]
.
[MyProcName]
@Parameter1
INT
=
1
,
@Parameter2
VARCHAR
(
100
)
=
'StringValue'
,
@Parameter3
VARCHAR
(
100
)
=
NULL
AS
begin
select
@Parameter1
,
@Parameter2
,
@Parameter3
end
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment