Query Tag Archives - Essential SQL

Learn the Three Crucial Steps to Writing Better SQL

You can learn to write SQL. It isn’t hard. Yes, there are many details to mind, but none of it is impossible. In this series of articles I’ll show you the three steps I go through to write complex queries. All the examples for this lesson are based on Microsoft SQL Server Management Studio and […]

Learn about Stored Procedures

What is a Stored Procedure? A stored procedure is a group of one or more database statements stored in the database’s data dictionary and called from either a remote program, another stored procedure, or the command line. Stored procedure are commonly called SPROCS, or SP’s. Stored procedure features and command syntax are specific to the […]