CREATE PROCEDURE dbo.reverseChange
@recID As
int,
@column As
varchar(25),
@oldValue As
varchar(40),
@newValue As
varchar(40)
As
BEGIN
DECLARE @sql varchar(2000)
SET @sql
= 'update webrecruit Set ['
+ @column
+ '] = '''+ @oldValue
+
''' where recID = ' +
CONVERT(varchar(10), @recID
) +
' And [' + @column
+ '] = '''+ @newValue
EXEC (@sql)
END