How to Properly Increment Auto-Incrementing Primary Keys Stored in VARCHAR Columns Using SQL

SQL Server Filtering on "as" Label Aliases: Best Practices and Techniques