SQL:拷贝原有数据生成新纪录并修改其中一些字段的值

INSERT INTO TaskItemConfig
     SELECT Name, Principal, Auditor, ServiceId, ProductId, ProductName, SubFlowId,
     CheckPointId, DeptID, NeedAttachment, TaskItemType, SortId, AttachmentMemo,
     memo,'模板1' as TemplateName
     FROM TaskItemConfig
     WHERE Id IN ({0})

将所有新生成的纪录中的模板名称字段设为模板1