I have a table with two columns: CREATE TABLE MyTable( Id int IDENTITY(1,1) NOT NULL, Name nvarchar(100) NOT NULL); I want to duplicate the data using SELECT INSERT statement: INSERT INTO MyT...