C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Reviews   Communities   Interview   Jobs   Projects   Training   Your Ad Here    
Silverlight Games | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing | Lobby | Gift Shop |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...




Forums » .NET » SQL Server »

Retrive Parameters in Stored Procedure


Posted Date: 04 Nov 2009      Posted By: atulpatel      Member Level: Gold     Points: 1   Responses: 2



I want to get name of parameters which are used by given/selected Stored procedure.
e.g.

Create Procedure [dbo].spTest
(
@ID int
)

result:ID

Please help me.



Responses
Author: Mohan    04 Nov 2009Member Level: DiamondRating: 2 out of 52 out of 5     Points: 2

try this

sp_help spTest

Regards

Mohan Kumar.D


Author: Anil Kumar Pandey    04 Nov 2009Member Level: DiamondRating: 2 out of 52 out of 5     Points: 2

please explain in details...

what is your exact requirement..

Thanks & Regards
Anil Kumar Pandey



Post Reply
You must Sign In to post a response.
Next : Difference between view and table?
Previous : View
Return to Discussion Forum
Post New Message
Category: SQL Server

Related Messages


dotNet Slackers

About Us    Contact Us    Privacy Policy    Terms Of Use