I want to access the stored procedure script using C#.
I used EXEC sp_HelpText STOREDPROCNAME
. This is working fine.
Is there any way to retrieve stored procedure query and the stored procedure parameter separately??
ex: I need:
delete from [dbo].[tblTransactions] where [ID] = @ID
and
@ID numeric(18,0)
separately.
How to do this?
See Question&Answers more detail:os