Adding a SQL Statement Operation Manually

You can manually enter a SQL statement when creating a new database service.

Select the Service Interface page in the database service editor.
Specify a database as an endpoint for the operations of the interface for this service. From the Enterprise Explorer, drag the database connection profile for your database onto the interface box in the service diagram.
This creates the endpoint for the operation.
Note
If you insert a SQL statement operation without specifying a database, you must modify any generated parameters or result sets, and/or provide parameters or result sets by entering them manually in the parameters dialog at deploy time.
Right-click the interface box and select Add SQL Statement Operation|Add Request-Response Operation from the menu.
This adds a default operation to the interface.
Expand Properties and select the Source tab.
Select the Allow manual editing checkbox and enter the SQL statement in the Source tab.
Note
Press Ctrl+space to invoke the autocomplete list in the edit box.
Expand the Parameters section and select the Parameters to verify associated parameters.
To view and edit parameter properties, select the parameter in the list and expand the Properties panel to view the Properties tab.
Click Add on the Parameters tab to add a new parameter to the operation.
Select the parameter and edit properties in the Properties panel.