SQL脚本生成职员

SQL脚本生成职员原创

zg_d1v

6人赞赏了该文章 227次浏览编辑于2020年08月01日 18:37:34

/*生成职员
*/
INSERT INTO t_Item(FItemClassID, FParentID, FLevel, FName, FNumber, FShortNumber, FFullNumber,FFullName, FDetail, FDeleted)
VALUES(3, 0, 1, 'wzg2', 'wzg2', 'wzg2', 'wzg2','wzg2', 1, 0);

INSERT INTO t_Emp(FShortNumber, FNumber, FName, FParentID, FItemID,FProvinceID,FCityID)
SELECT FShortNumber,FNumber,FName,FParentID,FItemID,0,0 FROM dbo.t_Item WHERE FItemClassID=3 AND FNumber='wzg2'

赞 6

赞 6 评论 1 收藏 1

SQL脚本生成职员

恭喜您！