SQL 的插入数据的问题
无语中V5 2013-09-06 10:05:22 INSERT INTO [T_CS_ChildPointInfo]
([PointCode],[ChildPointCode],[ChildPointName],[ChildPointFullName],[CorrespondPointCode]
,[ChildPointAddress],[BeginDT],[EndDT],[LinkMan],[LinkTel],[Status],[ApplyMan],[ApplyDT]
,[AuditMan],[AuditDT],[AuditResult],[AuditOpinion],[OrganizeCardID])
SELECT PointCode,ChildPointCode,ChildPointName,ChildPointFullName,CorrespondPointCode
,ChildPointAddress,ISNULL(BeginDT,GETDATE()),ISNULL(EndDT,GETDATE()),Contact AS LinkMan,Tel AS LinkTel,2 AS Status,'管理员' AS ApplyMan,ISNULL(BeginDT,GETDATE()) AS ApplyDT
,NULL AS AuditMan,NULL AS AuditDT,NULL AS AuditResult,NULL AS AuditOpinion,NULL AS OrganizeCardID
FROM T_ChildPointPricePolicy
WHERE PointCode = '31R0'
查询出来的数据有14条。执行这个语句,很慢。