具有关系的更新表 [英] Update Table with Relationships

问题描述

我想更新我的主表:mIngenicoDetail

列如下所示

TerminalID(PK)
PropertyID(FK)-链接到查找表
SimNr
位置
SerialNr
DepartmentID(FK)-链接到查找表
FunctionID(FK)-链接到查找表
NetworkID(FK)-链接到查找表
版本
DateInserted
有效(BIT)

我写了一个简短的过程.我正在从应该更新表的文本框中输入新值.我的代码正在运行，但是我的表数据不想更新.我的Sql代码一定有问题.

这是我写的.

I want to update my main table: mIngenicoDetail

The columns looks as follows

TerminalID(PK)
PropertyID(FK)-Linked to a lookup table
SimNr
Location
SerialNr
DepartmentID(FK)-Linked to a lookup table
FunctionID(FK)-Linked to a lookup table
NetworkID(FK)-Linked to a lookup table
Version
DateInserted
Active(BIT)

I have written a short proc. I am inputting the new values from textboxes that should update the table. My code is working, but my tables data do not want to update. There must be something wrong with my Sql code.

This is what i have written.

ALTER PROCEDURE [dbo].[PUPD_IngenicoDetials] 

@Simnr VARCHAR(50),
@Location VARCHAR(50),
@Serialnr VARCHAR(50),
@Department VARCHAR(50),
@Functions VARCHAR(50),
@Network VARCHAR(50),
@Version VARCHAR(50),
@Date VARCHAR(50),
@RadicalRef VARCHAR(50)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
	UPDATE dbo.mIngenicoDetail 
	SET Simnr = @Simnr,Location = @Location, 
	Serialnr = @Serialnr, DepartmentID = @Department, FunctionID = @Functions,
	NetworkID = @Network, Version=@Version, DateInserted=@Date
    FROM mIngenicodetail
	
	
END
GO

SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO

你能帮忙吗?

谢谢

Can you please assist.

Thank you

推荐答案

我建​​议:

I would suggest:

ALTER PROCEDURE [dbo].[PUPD_IngenicoDetials] 
@TerminalID [set the correct datatype],
@Simnr VARCHAR(50),
@Location VARCHAR(50),
@Serialnr VARCHAR(50),
@Department VARCHAR(50),
@Functions VARCHAR(50),
@Network VARCHAR(50),
@Version VARCHAR(50),
@Date VARCHAR(50),
@RadicalRef VARCHAR(50)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
	UPDATE dbo.mIngenicoDetail 
	SET Simnr = @Simnr,Location = @Location, 
	Serialnr = @Serialnr, DepartmentID = @Department, FunctionID = @Functions,
	NetworkID = @Network, Version=@Version, DateInserted=@Date
    Where TerminalID = @TerminalID	
	
END
GO
 
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO

这篇关于具有关系的更新表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！