Loading

how to add a prefix in every column of table by coding?

Arshi Khan

11y1.5kC#

I want to add some prefix in each column of my table manually. I have a table named ProductMaster.

I want to add a column Product_Id and want to add it like P-1, P-2, P-3... so on.

Here I'm using C# window application and sql server 2008 R2.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Khargesh Rajput11y ago
in your query set
select 'P-'+Product_Id as Product_Id from tablename