-
When specifying varchar or nvarchar parameters in stored procedures or functions, get into the habit if specifying the size. If you don't you will find yourself in a situation with difficult to find bugs, because if you don't specify a size, SQL Server assumes a default of 1. For instance, running...
-
The UNION Operator is used to connect the result set of two or more SELECT statements. The SELECT statements should have the same number of columns and the columns should have similar data types in the same order. There is a difference between UNION and UNION ALL. While UNION ALL returns all the rows...