Want to build the ChatGPT based Apps? Start here
Become a member
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
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forum guidelines
Prasad Bhagat
1.6k
516
212.7k
how to return some values from insert procedure?
Mar 21 2016 7:40 AM
Dear all ,
i have a proc like bellow ,
create proc insertdata(@fname varchar( 100),@lname varchar(100),@mobile varchar(100)
as
begin
insert into emp (fname,lname,mobile)values (@fname,@lname,@mobile)
end
as of now perfect ,
now i want to return if the proc is executed succesfully then i want to retun two varables like
StatusInd=1 and StatusMsg="Inserted"
else
StatusInd=-1 and StatusMsg="NoInserted"
so please help me how can i create proc using sql server
Reply
Answers (
2
)
i need the ans for the these qus??
Query