Creating SQL Stored Procedures via SQL Server is easier than you might have originally thought, so let us explain what to do. Simply follow the steps here: Click on New Query ...

You can use full, inline SQL statements in the prepared statement function or send the database a stored procedure function. A stored procedure is a program that is stored on the database server.

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.

Scalar functions let you encapsulate a calculation into a stored procedure-like snippet of SQL. It’s common practice to return the results of a scalar function as a column in a SELECT query.

Tony Patton discusses the merits of stored procedures versus placing SQL directly in the code. Find out which one is best for your particular situation.

We've got a strange problem here and I'm hoping someone has some kind of idea as to what could be causing it.<BR><BR>We've got a stored procedure in Sql Server 2005.