Hi @Sarvesh Pandey ,
In sql server, the row number needs to be created by yourself, and the leftmost serial number of the data you mentioned is not the row number. Also, your problem description seems unclear. Do you want to add a column number to each column? This seems not easy to achieve. Could you share with us the specific problems you are facing?
And you may not need the column number, because the data storage or search in sql server is based on the row number, not the column number.
If you have any question, please feel free to let me know.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues November--What can I do if my transaction log is full?
Hot issues November--How to convert Profiler trace into a SQL Server table
Duplicate post on stackoverflow