--stored procedure with local variable
create Procedure sampleprocedure
(
@Number int
)
as
select 'Entered number is' +' '+@Number
--executing sp
sampleprocedure 10
result :Entered number is 10
create Procedure sampleprocedure
(
@Number int
)
as
select 'Entered number is' +' '+@Number
--executing sp
sampleprocedure 10
result :Entered number is 10
No comments:
Post a Comment