I have TWO Sql Server stored procedures that takes 3 to 5 INPUT parameters and returns about 5 to 7 OUTPUT fields using a SELECT Statement back to calling program.
I would like to put a Web Services Wrapper around these Stored Procedures so they could be called by an application external to my server.
My server is a Windows machine and database is Sql Server. I prefer .NET but PHP is okay as long as I could run and maintain the code on a windows machine.
Should be a 1 or 2 day job. Very straight forward! See sample Stored Procedure below for wrapping into Web Service below.
CREATE PROCEDURE [dbo].[ABC] (@ID Nvarchar(10), @field2 Varchar(16),
@field3 Nvarchar(10), @field4 Varchar(16), @field5 Varchar(3), @field6 Varchar(5) )
'3105551212' as A,
'benzpromo123' as B,
'[url removed, login to view]' as C,
'' as D,
'[url removed, login to view]' as E,
'' as F,
'' as G