SQL Server Collation Overview and Examples
In this tip we look at what Collation means for SQL Server and how to use this when querying data or creating database objects or databases.
Aubrey Love is a self-taught DBA with more than six years of experience designing, creating, and monitoring SQL Server databases as a DBA/Business Intelligence Specialist. Certificates include MCSA, A+, Linux+, and Google Map Tools with 40+ years in the computer industry. Aubrey first started working on PC’s when they were introduced to the public in the late 70's.
- MSSQLTips Awards: Author of the Year - 2022 | Trendsetter (25+ tips) - 2023
Split Delimited String into Columns in SQL Server
In this tip we look at how to parse or split SQL Server data from one column into multiple columns using the parsename and other T-SQL functions.