-
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...