If you are planning to create several functions, it's important to build a good structure for your projects, so it is easy to read and more robust to avoid bugs and problems. We would recommend that you use multiple Stored Procedures, and that you use the main procedure to create a router of some kind.
Security
Since everything is handled by the same Stored Procedure, you have the power to create reliable security mechanism to protect your data. See more information on the security section.
Routing
Use the URL to create your routing mecanism. For example /api for all AJAX-requests, and /api/user for all related communication of the current user. See more information in the URL-section.
Last updated: 15 oct 2015
Give us feedback
AngularJS <-> Microsoft SQL
Exchange data between your AngularJS application and your Microsoft SQL Server