-
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...
-
i have just come across a potential "bug" in the T-SQL Parser(if such a thing exists) of both Oracle and SQL server. here it is create a simple table Normal 0 false false false MicrosoftInternetExplorer4 create table table1 ( table1_field1 varchar ( 255 ), table1_field2 varchar ( 255 )) create...