By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,609 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

Error occured in execution of Procedure

P: 34
Hi All,

The code is:


Execute xyz @age=12,@name='suman'

alter procedure xyz
(
@age int,
@name VarChar(15)
)
as
Begin

create table #xyz(
age int,name varchar(15))
insert into #xyz values(@age,@name)
select * from #xyz
end


When i execute the procedure i am getting this error::-
Server: Msg 111, Level 15, State 1, Line 4
'ALTER PROCEDURE' must be the first statement in a query batch.
Server: Msg 137, Level 15, State 1, Line 14
Must declare the variable '@age'.


Please help me for the needful.

Thanks in advance.

Rgds,
Sumanta Panda
Feb 26 '09 #1
Share this Question
Share on Google+
1 Reply


P: 34
Dear All,
I have resolved the problem.Its working perfectly.

Thanks!!

Rgrds,
Sumanta Panda
Feb 26 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.