Structured error handling explained with a road detour: instead of giving up at a level 16 error, your code can take another route with TRY and CATCH.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – SQL Server Error Messages – Day 27 of 35
How SQL Server error messages work: SQL Server catches most problems before your code runs, and raises an error when a statement cannot run.
SQL SERVER – Table Valued Functions – Day 26 of 35
Let us learn about table valued functions. Every day one winner from the United States will get Joes 2 Pros Volume 4.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Table-Valued Store Procedure Parameters – Day 25 of 35
SQL Server 2008 table-valued parameters let you pass a whole table into one stored procedure parameter instead of calling it 1000 times.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Easy Introduction to CHECK Options – Day 24 of 35
An easy introduction to CHECK Options on views: why an update through a view can make rows drop out of it, and how CHECK OPTION stops that.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Introduction to Views – Day 23 of 35
An introduction to views from Joes 2 Pros: the rules a query must follow before it can become a view, like giving every expression column a name.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – All about SQL Constraints – Day 22 of 35
All about SQL constraints, starting with check constraints: how to keep a column to sensible values, like no negative height on a medical form.