asked on stored proc gui
ms sql management studio how to query select stored proc by passign inputs graphically without writing query.
one of my colleague passed inputs in one cool graphical option in ms sql management studio
not exactly sure how he was able to do it
please advise
one of my colleague passed inputs in one cool graphical option in ms sql management studio
not exactly sure how he was able to do it
please advise
Microsoft SQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008SQL
Last Comment
gudii9
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
On second thoughts, I would have asked him directly. Or just could have googled the question text itself.
ASKER
Just traverse the tree view (Object Explorer) typically found in left pane, keep expanding nodes, and identify the stored procedure you wish to execute, select it, right click and from the context sensitive menu, click on 'Execute Stored Procedure' option.
above option i am familiar.
Is there is a way i can give like inputs in graphical way more at run time to the program?
I don't quite understand your question clearly. If you could give me an example, please. What do you mean by 'at run time to the program'?
ASKER
Just traverse the tree view (Object Explorer) typically found in left pane, keep expanding nodes, and identify the stored procedure you wish to execute, select it, right click and from the context sensitive menu, click on 'Execute Stored Procedure' optioit showed in next screen after i do this step