title: inserting some rows from one table to another by changing value of one column
body: <p>I have a table like this:</p>
  
  <pre><code>CREATE TABLE [dbo].[Question] (
      [QuesID]    INT            IDENTITY (1, 1) NOT NULL,
      [Body]      NVARCHAR (MAX) NULL,
      [O1]        NVARCHAR (MAX) NULL,
      [O2]        NVARCHAR (MAX) NULL,
      [O3]        NVARCHAR (MAX) NULL,
      [O4]        NVARCHAR (MAX) NULL,
      [UserID]    NVARCHAR (50)  NULL,
      [QuesDate]  DATETIME       NULL,
      PRIMARY KEY CLUSTERED ([QuesID] ASC)
  );
  </code></pre>
  
  <p>And I want to </p>
  
  <pre><code>select * from Question where UserID=N'admin'
  </code></pre>
  
  <p>then insert what I selected, to this table but change the UserID from admin to another value. Notice that I don't need to select QuesID because its PRIMARY KEY.</p>