January 10, 2010 at 1:28 am
hi,
can i add help to a stored procedure like if someone write exec myproc 'help' he il get all the info that i will put in the help?
i can't add the help/info into the stored procedure in marks because the stored procedure will be encrypted.
THX
January 10, 2010 at 11:17 am
Yes, you could do something like that. Add an optional parameter and then you could have the procedure executed as:
EXECUTE dbo.MyProcedure @help = 'something';
Inside the procedure - check for the existance of a value in that parameter and display the information if the parameter is defined.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 11, 2010 at 1:10 am
can you give me an example of simple proc that have help in it?
THX
January 11, 2010 at 1:36 am
What info do you want to display.
"Keep Trying"
January 11, 2010 at 3:01 am
THX i've managed with this proc.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply