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
selva kumar
NA
557
189k
How to solve this error?
May 20 2014 1:04 AM
Hi i have created stored procedure for user login but it throws error..can any one help me out..
Create Table Tbl_Login(T_Id Int Identity(1,1),Mode Varchar(50),UserName Varchar(50),[PassWord] Varchar(50));
Select * From Tbl_Login;
Truncate Table Tbl_Login;
Drop Table Tbl_Login;
/*Stored procedure for User_Login*/
Create Proc SP_Login(@Mode Varchar(50),@Name Varchar(50),@PassWord Varchar(50,@Res INTEGER Output)
as
if exists(Select Mode,UserName,[PassWord] From Tbl_Login Where Mode=@Mode and UserName=@Name and [PassWord]=@PassWord)
set @Res=1
else
set @Res=0
go
Exec Proc SP_Login
Error:
Msg 102, Level 15, State 1, Procedure SP_Login, Line 1
Incorrect syntax near '@Res'.
Msg 137, Level 15, State 2, Procedure SP_Login, Line 3
Must declare the scalar variable "@PassWord".
Msg 137, Level 15, State 1, Procedure SP_Login, Line 4
Must declare the scalar variable "@Res".
Msg 137, Level 15, State 1, Procedure SP_Login, Line 6
Must declare the scalar variable "@Res".
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'Proc'.
Reply
Answers (
3
)
Allow multiple users to update same record
stored procedure