Original SQL SELECT col1, col2 FROM myTable Using cast SELECT CAST(col1 AS VARCHAR(10)), CAST (col2 AS VARCHAR(10)) FROM myTable Transaction Isolation, Concurrency, and Deadlock Create and DropThe following error may be seen when creating or dropping a database object, such as a table or stored procedure.