Multiple choice technology databases

t-sql variables case sensitive?

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

T-SQL (Microsoft SQL Server) variables are case-insensitive. @MyVar and @myvar refer to the same variable. This is consistent with SQL Server's default case-insensitive collation behavior. The only case-sensitive elements in T-SQL are string comparisons (if using a case-sensitive collation) and object names in case-sensitive databases.

Keep practicing — related questions