------------------------更新
ALTER proc [dbo].[usp_Part_Name_UpdateByNeed]
(
@ACL_Part_Name varchar(50),
@FieldName varchar(50),
@FieldValue varchar(50)
)
as
DECLARE @strUpdate nvarchar(1000)
SET @strUpdate='update Part_Name set '+@FieldName+' = '+@FieldValue+' where ACL_Part_Name = '+@ACL_Part_Name
EXEC sp_executesql @strUpdate
ALTER proc [dbo].[usp_Part_Name_UpdateByNeed]
(
@ACL_Part_Name varchar(50),
@FieldName varchar(50),
@FieldValue varchar(50)
)
as
DECLARE @strUpdate nvarchar(1000)
SET @strUpdate='update Part_Name set '+@FieldName+' = '+@FieldValue+' where ACL_Part_Name = '+@ACL_Part_Name
EXEC sp_executesql @strUpdate
(
@ACL_Part_Name varchar(50),
@FieldName varchar(50),
@FieldValue varchar(50)
)
as
DECLARE @strUpdate nvarchar(1000)
SET @strUpdate='update Part_Name set '+@FieldName+' = '''+@FieldValue+''' where ACL_Part_Name = '''+@ACL_Part_Name+''''
EXEC sp_executesql @strUpdate难道是这样。
ALTER proc [dbo].[usp_Part_Name_UpdateByNeed]
(
@ACL_Part_Name varchar(50),
@FieldName varchar(50),
@FieldValue varchar(50)
)
as
DECLARE @strUpdate nvarchar(1000)
SET @strUpdate='update Part_Name set '+@FieldName+' = '+@FieldValue+' where ACL_Part_Name = '+@ACL_Part_Nameprint strUpdate 看看打印的语句是否符合语法。