34,576
社区成员
发帖
与我相关
我的任务
分享
Create proc [dbo].[Test]
@Flag nvarchar(1)=''
As
Begin
Set NoCount On
If @Flag=0
Begin
Update a set a.座位号=b.座位号,a.户籍=b.户籍 from Student_A a Join Student_B b on a.学号=b.学号
and a.姓名=b.姓名 and a.年龄=b.年龄 where b.学号 is not null
Insert Student_A(学号,姓名,年龄,座位号,户籍)
Select a.学号,a.姓名,a.年龄,a.座位号,a.户籍 from Student_B a left outer join Student_A b on a.学号=b.学号
and a.姓名=b.姓名 and a.年龄=b.年龄 where b.学号 is null
End
If @Flag=1
Begin
Delete a from Student_A a left outer Join Student_B on a.学号=b.学号 and a.姓名=b.姓名 and a.年龄=b.年龄 where b.学号 is null
End
End
Create proc [dbo].[Test]
@Flag nvarchar(1)=''
As
Begin
Set NoCount On
If @Flag=0
Begin
Update a set a.座位号=b.座位号,a.户籍=b.户籍 from Student_A a Join Student_B b on a.学号=b.学号
Insert Student_A(学号,姓名,年龄,座位号,户籍)
Select a.学号,a.姓名,a.年龄,a.座位号,a.户籍 from Student_B a where a.学号 NOT IN (SELECT 学号 FROM Student_A)
End
If @Flag=1
Begin
Delete a from Student_A a where a.学号 NOT IN (SELECT 学号 FROM Student_B)
End
End
Create proc [dbo].[Test]
@Flag nvarchar(1)=''
As
Begin
Set NoCount On
If @Flag=0
Begin
Update a set a.座位号=b.座位号,a.户籍=b.户籍 from Student_A a Join Student_B on a.学号=b.学号
and a.姓名=b.姓名 and a.年龄=b.年龄 where b.学号 is not null
Insert Student_A(学号,姓名,年龄,座位号,户籍)
Select a.学号,a.姓名,a.年龄,a.座位号,a.户籍 from Student_B a left outer join Student_A b on a.学号=b.学号
and a.姓名=b.姓名 and a.年龄=b.年龄 where b.学号 is null
End
If @Flag=1
Begin
Delete a from Student_A a Join Student_B on a.学号=b.学号 and a.姓名=b.姓名 and a.年龄=b.年龄 where a.学号 is null
End
End