Reading Time: 2 minutes Sometimes, you want to execute certain SQL code only if you know that a specific column exists within a table. There is an extremely simple way to check if a column exists within a table in SQL Server: Use the COL_LENGTH system function! The syntax of the COL_LENGTH system function Continue Reading
Don’t make this mistake when calling your SQL Stored Procedures!
Reading Time: 3 minutes Stored Procedures are complicated beasts in Microsoft SQL Server. There are many quirks you should be aware of when creating and calling them. In this very brief tutorial, we’ll talk about one of those wacky rules. Take a look at the following Customers and ContactInfo tables: We have a stored Continue Reading