如何使用 INSERT INTO + SELECT FROM 插入自定义值? [英] How to insert custom values with INSERT INTO + SELECT FROM?

问题描述

我想在执行 INSERT INTO ...SELECT FROM ... WHERE 子句时插入自定义值和表列

i would like to insert custom values along with table columns when i perform INSERT INTO ...SELECT FROM ... WHERE clause

INSERT INTO RoleMappingEmployee_Delete_History (
    RoleMappingEmployeeKey,
    SrKey,
    RoleKey,
    SubmittedDate,
    SubmittedBy,
    IsActive,
    DeletedBy,
    DeletedDateTime)
SELECT 
    RoleMappingEmployeeKey,
    SrKey,
    RoleKey,
    SubmittedDate,
    SubmittedBy,
    IsActive,
    DeletedBy,
    DeletedDateTime
FROM
    RoleMappingEmployee
WHERE
    RoleMappingEmployeeKey IN (25902,38188,25887)

我想插入带有自定义值的 DeletedBy,DeletedDateTime 值

i would like to insert values for DeletedBy,DeletedDateTime with custom values

推荐答案

INSERT INTO RoleMappingEmployee_Delete_History (
    RoleMappingEmployeeKey,
    SrKey,
    RoleKey,
    SubmittedDate,
    SubmittedBy,
    IsActive,
    DeletedBy,
    DeletedDateTime)
SELECT 
    RoleMappingEmployeeKey,
    SrKey,
    RoleKey,
    SubmittedDate,
    SubmittedBy,
    IsActive,
    'peter',
    getdate()
FROM
    RoleMappingEmployee
WHERE
    RoleMappingEmployeeKey IN (25902,38188,25887)

这篇关于如何使用 INSERT INTO + SELECT FROM 插入自定义值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！