Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
2
Answers
how to return some values from insert procedure?
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
Prasad Bhagat
8y
348
1
Reply
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
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
i need the ans for the these qus??
Query