This section describes some programming considerations that you will need to keep in mind when writing an Open Data Services server application that uses the PROCSRV sample application as a model.
With standard stored procedures, an administrator can define a set of user-specified parameters that will be validated by SQL Server. When creating procedures using the Open Data Services API, the application must validate any user-specified parameters.
Each function in your application should follow these recommendations for accepting and responding to user input: