select查询的结果作为另外一个表的update字段

一般这个问题就是拼写sql

 

CREATE PROCEDURE  [dbo].[pro_UpdateByfilevaleAndLsationid] ( @id varchar(50), @comid varchar(50) ) AS begin declare @str varchar(200); declare @sql varchar(200); declare @getdate varchar(200);

SET @getdate=CONVERT(varchar(100), GETDATE(), 20); SELECT @str=Flag FROM dbo.PB_Config WHERE  ConfigKey='文件类型' AND TopComID=1 AND Notes LIKE '102|%' AND ConfigValue=@comid; exec(@sql) SET @sql='update dbo.SF_JinDu set '+@str+'='''+@getdate+''' where LStationID='''+@id+''''; exec(@sql) end

GO