SQL脚本生成客户原创
7人赞赏了该文章
243次浏览
编辑于2020年08月01日 18:38:06
/*生成客户
*/
INSERT INTO t_Item(FItemClassID, FParentID, FLevel, FName, FNumber, FShortNumber, FFullNumber,FFullName, FDetail, FDeleted)
VALUES(1, 0, 1, '张三经济', '张三经济', '张三经济', '张三经济','张三经济', 1, 0);
INSERT INTO dbo.t_Organization(FShortNumber,FNumber,FName,FParentID,FItemID,FProvinceID,FCityID,FStatus,FSaleID,FValueAddRate,FminForeReceiveRate,
FminReserverate,FCyID,FSetID,FRegionID,FTrade,FRegion,FPayCondition)
SELECT FShortNumber,FNumber,FName,FParentID,FItemID,0,0,1072,0,17,1,1,0,0,0,0,0,0 FROM dbo.t_Item WHERE FItemClassID=1 AND FNumber='张三经济'
推荐阅读