Creating SQL Stored Procedures via SQL Server is easier than you might have originally thought, so let us explain what to do.

Likewise, processor-intensive calculations that should take place in the server should use compiled .NET code, until T-SQL stored procedures can be compiled to machine code.

Likewise, processor-intensive calculations that should take place in the server should use compiled .NET code, until T-SQL stored procedures can be compiled to machine code.

PHP and SQL Server can be made to get along, too, if you want to go that route, and the mssql_* functions have supported stored procedures for a long time. I generally use embedded with PHP+MySQL.

Stored procedure XML This screenshot lists the source of a SQL Server 2014 stored procedure hitting the AdventureWorks2012 database, selecting data from the Customer and SalesOrderHeader tables.