March 13, 2008 at 4:50 am
Hi,
I am using an out parameter in my stored procedure after that it return that. then i want to know that what is the datatype of return value in storedProcedure. tell me abt this.
Regards
Sarvesh Kumar gupta 🙂
March 13, 2008 at 5:24 am
- Can you post a create proc ddl for this ?
- what data type do you declare the output parameter ?
- Best is to know in front what data type you expect.
- isnumber or isdate may help out.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
March 13, 2008 at 6:50 am
You have to declare the data type when you create the procedure, so you should know what data type you're returning.
Or are you asking how to know what data types are expected in a stored procedure that you simply want to consume? You can use sp_help 'procname' to see that information.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 13, 2008 at 7:25 am
Wouldn't OUTPUT return the same data type as whatever column or variable appeared in the stored procedure?
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply