stored procedure

Creating an ASP.NET MVC 4 RESTful API for a SQL Stored Procedure

by
ASP.NET MVC Web API logo

In order to use the information from the SQL stored proc I implemented that would create a JSON Object from a SQL table, I needed to build an RESTful API web service that would retrieve the JSON for use elsewhere. Finding information on building an ASP.NET-based API that used a stored proc to pull the … Read more

Get the Names of Stored Procedures that Reference a Given Table in SQL Server

by
SQL Server logo

One of my colleagues sent me a very handy bit of code this morning that I thought would be helpful to post. Below are two options which, when run against the database, should return the names of all stored procedures that reference the named table. I am told that the functionality of the first option … Read more