/*生成职员
*/
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'

【emoji】