SQL Tutorials

A Basic Guide to SQL Server Stored Procedures
A stored procedure is a prepared SQL code that you can save, so the code can be reused over and over again.

SQL Server Stored Procedure Parameters
When you call this stored procedure, it just simply runs the query and returns a result set.
In this tutorial, we will extend the stored procedure which allows you to pass one or more values to it. The result of the stored procedure will change based on the values of the parameters.

SQL Alias – AS Keyword
Alias is used to give an alias name to a table or a column, which can be a resultset table too. This is quite useful in case of large or complex queries.

PHP PDO object & prepared statements.
This is a short PHP tutorial on how to use the wildcard character when using prepared statements with the PDO object. In this guide, I will show you how to bind the wildcard and the string you are attempting to match to a given parameter.