SQL SERVER BLOGS
- General (7)
- Tables and columns (11)
- Selecting data (6)
- WHERE criteria (5)
- Calculations (6)
- Joins (3)
- Grouping (2)
- Views (2)
- Stored procedures (4)
- SQL programming (5)
- Programming tables (2)
- CTEs, subqueries (6)
- Errors, debugging (2)
- Functions (3)
- Dynamic SQL (3)
- Transactions (3)
- Cursors (1)
- Triggers (1)
BLOGS BY AUTHOR
BLOGS BY YEAR
Blogs from Wise Owl on SQL programming in SQL
Showing blogs 1-5 (out of 5)
Posted by Andrew Gould on 18 February 2013
Many programming languages feature a variety of types of loop which allow your programs to repeat a set of instructions multiple times. In SQL there is only one type of loop, and this blog explains how it works!
Posted by Andy Brown on 29 January 2013
You can use the IF statement to test conditions in SQL - this blog explains how, and also explains why you might prefer to use CASE WHEN instead.
Posted by Andy Brown on 28 January 2013
SQL comes complete with a few useful global variables, giving you information such as the row number of the record just inserted, or the number of rows affected by a query. Here's how to use them!
Posted by Andy Brown on 03 January 2013
Variables in SQL always begin with @, and allow you to program more efficiently. Learn the tips and tricks in this short series of blogs!
Posted by Andrew Gould on 16 February 2012
If you've spent time in the SQL Server Management Studio application you'll probably have noticed that it's not the most user-friendly environment for writing SQL queries. This blog explains how to change a few settings to make your query writing just a little easier.