Tuesday, December 04, 2007 - Posts

Column length and Data length
04 December 07 07:13 AM | Madhivanan | 2 Comments   
When you use character datatypes(char,varchar,nchar,etc), always make sure that column has enough length to have data. Otherwise sometimes you would get errors and sometimes you wont. Consider the following example Declare @t table ( i int , test_col Read More...