Resultat fra dynamisk sql

Jeg glemte lige:
SET @Srv = 'SERVER1'

fra http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20439561.html

//akj

CREATE PROCEDURE sp_UpdateData
@acct varchar(10),
@txtBx varchar(20),
@value varchar(10)
AS
DECLARE @strSQL varchar(8000)
DECLARE @tbl varchar(20)
DECLARE @fld varchar(20)
DECLARE @Key INT
SET @strSQL= N'SELECT @tbl = tblName, @fld = tblField FROM tblFieldMap WHERE txtField=''' + CAST(@txtBx AS NVARCHAR(20)) + N''''
EXEC sp_executesql @strSQL, N'@tbl VARCHAR(20) OUTPUT, @fld VARCHAR(20) OUTPUT', @tbl OUTPUT, @fld OUTPUT
PRINT @tbl, @fld  --just to verify values returned

Tak dk_akj, det s.. noget langhåret ud! Den skal jeg lige have tygget igennem.