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.

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply