Stored Proc UI?
-
Hi, I'm working on some clean up scripts, simple stored procedures that delete records or update column values based on input parameters.
I was wondering if there was a good way maybe with ssrs to create a UI that would make it a little easier for people who aren't that used so sql server to input the parameter values and run the stored procedure.
Any tips are greatly appreciated.
-
Access works well for this if it's a limited number of people.
If not, you could do something like this: http://www.sqlservergeeks.com/sql-server-using-sql-server-reporting-services-to-manage-data/
-
There are many ways to skin this cat, for example:
If you use Management Studio and right-click - execute stored procedure it will op up a window to input parameter values.
You can use a SSRS report to offer drop-down parameter selection.
You can write a simple c# form to offer stored proc execution.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply