Hi,
I have a confusing in stored procedure in sql, whether stored procedure returns a value or not . If it returns, then what types of value we can returned by the stored procedure?
Plz reply..
Loading
Hi,
I have a confusing in stored procedure in sql, whether stored procedure returns a value or not . If it returns, then what types of value we can returned by the stored procedure?
Plz reply..
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Anil KumarPosted May 27, 2012, 1:28 AM
You can return result-sets (from select statements) or single value (you specify your data types) from your stored procedure.
There are different ways to get return values from stored procedure. In some technique you are limited with return data type like when you use RETURN.
Please go through the SQL Stored Procedures to know different techniques for getting return values.
SenthilkumarPosted May 25, 2012, 1:54 AM
Stored procedure returns a value in the form of table.
SELECT GETDATE()
SELECT * FROM Employees
And also you can return a value using the RETURN statement.