Hi,
Iam creating stored procedure for insert statement but it is giving error that
must declare scalar varialbe empno (i am not understanding) please help me onthis
create procedure proc
(
@empno varchar(50) not null,
@leaveappdate varchar(50) not null,
@leavetype varchar(50) not null,
@balance varchar(50) not null,
@fromdate varchar(50) not null,
@todate varchar(50) not null,
@fromduration varchar(50) not null,
@toduration varchar(50) not null,
@noofdays varchar(50) not null,
@sanctionauthority varchar(50) not null
)
as
insert into CasualRestrictedLeaves values(@empno ,@leaveappdate ,@leavetype varchar(50),@balance ,@fromdate ,@todate ,@fromduration ,@toduration ,@noofdays ,@sanctionauthority );
Loading
BangaruBabu PuretiPosted Mar 21, 2010, 12:08 AM
Go with This Insert Query.. it will Work
insert into CasualRestrictedLeaves values(@empno ,@leaveappdate ,@leavetype,@balance ,@fromdate ,@todate ,@fromduration ,@toduration ,@noofdays ,@sanctionauthority );
LakshmiPosted Mar 18, 2010, 10:43 AM
insert into CasualRestrictedLeaves values(@empno ,@leaveappdate ,@leavetype varchar(50),@balance ,@fromdate ,@todate ,@fromduration ,@toduration ,@noofdays ,@sanctionauthority );
y have you given 'leavetype varchar(50)' in the insert into statement again???? is it needed there?? i don't think so.. did u solve the error???