插入外键值 [英] Inserting values of foreign key

问题描述

考虑这3个表

Consider these 3 tables

table1-tbCompanyData
CompanyID CompanyName 
1 ABB 
2 DELL 

table2-tbQuestion 
Code QnDescription 
1 How you rate our services 
2 How is our products 
3 How do you think about us 

tbale 3-tbQnRating
CompanyID QnCode Rating 
1 1 3 
2 1 2 
2 2 3 
3 1 1

我的存储过程

My Stored Procedure

create proc [dbo].[sp_InsertAllValues] 
@CompanyName varchar(100), 
@Rating int 
as 
declare @topId int 
set @topId=(select MAX(ID+1) from tbCompanyData) 
declare @QnCode int 
set @QnCode=(select code from tbQnMst where Code=1)(NOTE:I'm inserting the QnCode values statically here so in my table according to the QnCOde 1 companyName,QnCode and rating are getting inserted so please tell me how do i insert QnCode dynamically) 
begin 
begin try 
begin transaction 
insert into tbCompanyData values(@CompanyName) 
insert into tbQnRating values(@topId,@QnCode,@Rating) 
commit transaction 
end try 
begin catch 
rollback transaction 
end CATCH 
end 

请尽情享受...
预先感谢

Pls do the enedful...
Thanx in advance

推荐答案

您共享了3个表和1个存储过程；但没有解释您的期望.我们需要明确的问题吗?

You shared 3 tables and 1 stored procedure; but didn''t explain your expectation. We need the clear question?

这篇关于插入外键值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！