SQL Interview: 40 Replacing text data type with varchar
This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around SQL Server and Azure SQL Database.
Section: Development Level: Advanced
Question:
You have a table in your database that contains six columns that are defined with the text data type.
When you run checks on your database, these columns are often flagged with deprecation warnings, and so you change each column as follows:
2025-04-25