INSERT INTO SELECT 用法

INSERT  INTO DB_Division.RoleFunction
        ( RoleName ,
          RoleDesc ,
          FunctionIdList ,
          ParentRoleId ,
          IsEnable ,
          OperateIDList
        )
        SELECT  RoleName ,
                RoleDesc ,
                FunctionIdList ,
                ParentRoleId ,
                IsEnable ,
                OperateIDList
        FROM    DB_Division.RoleFunction
        WHERE   RoleId = 0

 

posted @ 2017-09-06 14:43  花生打代码会头痛  阅读(146)  评论(0)    收藏  举报