Suppose I have two tables:
Note: EmpID is not an identity field
How to move all the data from Employee1 table to Employee2 table with values of EmpID as 1, 2, 3, ....so on.
Can anyone have any idea?
INSERT INTO [Employee2] (EmpID, EmpName, EmpAddress)
SELECT ROW_NUMBER() OVER (ORDER BY EmpName), EmpName, EmpAddress from Employee1
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?