SQL操作组织与评分对应关系
本文详细介绍了如何使用SQL语句操作组织信息，并与评分系统进行对应，涉及数据库操作和数据映射。
Declare @orgName varchar(40)
Select @orgName=Name From Organization Where ID=161
insert into ScoreOrgCorrespond(OrgID,OrgName,ScoreOrgID,ScoreOrgName,ScoreTypeID,ScoreOrgType,IsDeleted)
select T1.ID As OrgID,T1.Name As OrgName,161 As ScoreOrgID,@orgName As ScoreOrgName,2 As ScoreTypeID,2 As ScoreOrgType,0 As IsDeleted from (select ID,Name from dbo.Organization where DisplayParentID in(300,301,335) and IsDeleted=0 and Name not in('安徽代表处',
'江苏代表处',
'四川代表处'
)) As T1
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
