• For datatype , this doubt clarification i've posted one answered already.

    varchar accepts both number and character and without single quote number also like (1,'b') or ('1','b')

    both possible in sqlserver2005