Script to check SQL Case Sensitivity

Written by

Jugal Shah

in

You can execute below script to check whether SQL Server is case sensitive or not

SELECT
case when 'a' <> 'A' 
then 'Case-Sensitive' 
else 'case-insensitive' end  AS 'Case Sensitivity'

Comments

One response to “Script to check SQL Case Sensitivity”

  1. Moosa Avatar
    Moosa

    Easy way hah!! I like it..

    Reply

Thanks for the comment, will get back to you soon… Jugal Shah

More posts