Experts Exchange connects you with the people and services you need so you can get back to work.
Create Procedure usp_My_Procedure (@param int)
declare @I int
declare @J int
declare @K int
declare @C char(1)
declare @D datetime
set @I = @param
set @J = @I * 100
set @I = (select max(number) from master..spt_values where type = 'P')
select @K = max(number), @C = max(type) from master..spt_values where type = 'P'
set @D = getdate() + @param
select @param as [param], @I as [i], @J as [j], @K as [k], @C as [C], @D as [date]
-- then to test it simply use the exec function and pass the parameter (in this case the value 4)
exec usp_My_Procedure 4
Open in new window
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.