如何在插入后更新SqlServer表 [英] How do I update an SqlServer Table after Insertion
问题描述
嗨朋友
我有2张桌子如下图所示
tblDetails:
genericName value
a 0 >
a 0
b 0
b 0
c 0
d 0
tblMaster:
性别名称价值
a 1
b 0
c 1
d 1
插入值后,我会得到如上所示的tblDetails。
但我想根据tblMaster表更新value列。
我想得到最终结果
tblDetails:
genericName value
a 1
a 1
b 0
b 0
c 1
d 1
请帮帮我...
谢谢你... :)
检查这个...
update tblDetails
set
tblDetails.value = tblMaster.Value
来自
tblMaster
其中
tblDetails.genericName = tblMaster.genericName
现在你可以检查......
< span class =code-keyword>从 tblDetails中选择 *
希望这会对你有所帮助。
干杯
请检查一次:
创建 过程 sp_savDetails
(
@gname varchar ( 20 )
)
as
begin
insert 进入 tblDetails 选择 @ gname ,值来自 tblMaster 其中 genericName = @ gname
端跨度>
Hi friends
I have 2 tables as shown below
tblDetails:
genericName value
a 0
a 0
b 0
b 0
c 0
d 0
tblMaster:
GendericName Value
a 1
b 0
c 1
d 1
After Inserting values I will get tblDetails as shown above.
But I would like to update the value column according to the tblMaster table.
I would Like to get the final result as
tblDetails:
genericName value
a 1
a 1
b 0
b 0
c 1
d 1
Please help me...
Thank Youu... :)
Hi,
Check this...
update tblDetails set tblDetails.value=tblMaster.Value from tblMaster where tblDetails.genericName=tblMaster.genericName
Now You can check...
Select * from tblDetails
Hope this will help you.
Cheers
Please check once this :
create procedure sp_savDetails ( @gname varchar(20) ) as begin insert into tblDetails select @gname ,value from tblMaster where genericName=@gname end
这篇关于如何在插入后更新SqlServer表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!