• Q - what's the difference between char() and varchar()

    My answer, nothing, they'll both give you the same syntax error.  They also can both store just one character:

    --DECLARE @cr char(),@vcr varchar()

    --Line 1: Incorrect syntax near ')'.

    DECLARE @cr char,@vcr varchar

    set @cr='Ftest'

    set @vcr='Vtest'

    select @vcr variable,@cr fixed

    I'd probably shoot the DBA that would declare a field or variable varchar(1) or char(1000).  Oh, wait, I've got to shoot myself because of that example.