TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Pramod Kumar Nandagiri
NA
484
0
sql stored procedure for insert
Mar 13 2010 7:33 AM
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
);
Reply
Answers (
2
)
EAV(Entiry, Attribute and Value) Structure in SQL Server
acess cube by using .net