<div>
I confirm the above. it's not only a technical limitation, but also a matter of normalization of database tables
</div>


I confirm the above. it's not only a technical limitation, but also a matter of normalization of database tables

<div>
<div class="content wysiwyg-content">
I want to add a column to my table that takes the value of the identity column and prefixes it with 'A'. I don't know the syntax for specifying the varchar datatype within this statement:<br />
<br />

<pre><code id="code-10-28345913-1">ALTER TABLE T_MyTable 
ADD ID2 AS 'A' + ID</code></pre>
</div>
</div>


I want to add a column to my table that takes the value of the identity column and prefixes it with 'A'. I don't know the syntax for specifying the varchar datatype within this statement:

(CODE)

Add alphanumeric identity column

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.