DECLARE @OldPK AS VARCHAR(50) DECLARE @PK AS VARCHAR(50) DECLARE @S AS NVARCHAR(MAX) DECLARE @P AS NVARCHAR(MAX) SET @PK = 'ModeName' SET @S = N'SELECT @pOldPK = @pPK FROM Modes ' SET @P = N'@pPK VARCHAR(50), @pOldPK VARCHAR(50) OUTPUT' EXECUTE dbo.sp_executesql @S, @P, @pPK = @PK, @pOldPK = @OldPK OUTPUT SELECT @OldPK When I try to debug and after the line EXECUTE dbo.sp_executesql @S, @P, @pPK = @PK, @pOldPK = @OldPK OUTPUT
"Object reerence not set to an instance of an object"
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)