(last updated: 2021-07-05 @ 14:00 EST / 2021-07-05 @ 18:00 UTC ) The sysname data type (in SQL Server) is a system-provided, though not built-in, alias for NVARCHAR(128). This alias is used for nearly all identifiers (i.e. names of tables, columns, indexes, databases, logins, etc.), starting in SQL Server 7.0 (for a full list of… Continue reading Is the [sysname] SQL Server System Data Type Alias Name Case-Insensitive?
Tag: Identifiers
Uppercase All String Columns (and in a Single Query!)
Have you ever wanted to uppercase all string columns in a database? Probably not. But, this was still an interesting exercise 🙃
Changing the Collation of the SQL Server Instance, the Databases, and All Columns in All User Databases: What Could Possibly Go Wrong?
Need to change the collation at ALL levels? Prefer to avoid reloading all objects and data? Learn what the "sqlservr -q" option does, and doesn't, do.
The Uni-Code: The Search for the True List of Valid Characters for T-SQL Identifiers, Part 3 of 2 (Delimited Identifiers)
The investigation into valid T-SQL identifier characters continues. Apparently I was not done.
What’s in a Name?: Inside the Wacky World of T-SQL Identifiers
Come see the complete set of rules governing how you name things in SQL Server
The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 2
A captivating journey of twists and turns, searching for the mythical list of valid T-SQL identifier characters.
The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 1
A captivating journey of twists and turns, searching for the mythical list of valid T-SQL identifier characters.