从Sql Server中的两个表更新并选择单个查询但我无法获得正确的结果 [英] Update And Select In A Single Query From Two Tables In Sql Server But I Can't Get Correct Result

问题描述

更新matrimony_Personaldetails mp1 inner join matrimony_register as mr set Profilecreatedby ='self'，Name ='rajeesh'，Height ='5 ft-4in-165'from matrimony_Personaldetails mp1，matrimony_register mr select mp1.Profilecreatedby，mp1.Name，mr 。来自dbo.matrimony_Personaldetails的高度为mp1左外连接dbo.matrimony_register为先生mr.Reg_id = mp1.Reg_id其中mp1.Reg_id ='34'

解决方案

< pre lang =sql> 开始
开始 TRANSACTION

update matrimony_Personaldetails set Profilecreatedby = ' self'，Name = ' manu' FROM matrimony_Personaldetails mp1 inner join matrimony_register mr on mr.Reg_id = mp1.Reg_id where mp1.Reg_id=@regId

update matrimony_register set 高度= ' 5 ft-4in' 来自 matrimony_register mr < span class =code-keyword> INNER JOIN matrimony_Personaldetails mp1 ON MR.Reg_id = mp1.Reg_id 其中 mp1.Reg_id=@regId
commit
选择 mp1.Profilecreatedby，mp1.Name，mr.Height 来自 dbo.matrimony_Personaldetails as mp1 left outer join dbo.matrimony_register mr on mr.Reg_id = mp1。 Reg_id 其中 mp1.Reg_id=@regId

update matrimony_Personaldetails mp1 inner join matrimony_register as mr set Profilecreatedby='self',Name='rajeesh',Height='5 ft-4in-165' from matrimony_Personaldetails mp1,matrimony_register mr select mp1.Profilecreatedby,mp1.Name,mr.Height from dbo.matrimony_Personaldetails as mp1 left outer join dbo.matrimony_register as mr on mr.Reg_id=mp1.Reg_id where mp1.Reg_id='34'

解决方案

begin
begin TRANSACTION

   update matrimony_Personaldetails set Profilecreatedby='self',Name='manu'FROM matrimony_Personaldetails mp1 inner join matrimony_register mr on mr.Reg_id=mp1.Reg_id where mp1.Reg_id=@regId

   update matrimony_register set Height='5 ft- 4in' from matrimony_register mr INNER JOIN matrimony_Personaldetails mp1 ON MR.Reg_id=mp1.Reg_id where mp1.Reg_id=@regId
       commit
        select mp1.Profilecreatedby,mp1.Name,mr.Height from dbo.matrimony_Personaldetails as mp1 left outer join dbo.matrimony_register as mr on mr.Reg_id=mp1.Reg_id where mp1.Reg_id=@regId

这篇关于从Sql Server中的两个表更新并选择单个查询但我无法获得正确的结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！