[thelist] Stored Procedure Problem (EXEC)
Scott
pippen at bigpond.net.au
Wed Dec 4 22:53:01 CST 2002
: CREATE PROCEDURE sp_CMSFormsSegments
: @Category int,
: @Language varchar(100)
:
: AS
: DECLARE @ExecCode varchar(8000)
:
: SELECT @ExecCode = 'SELECT tblCMSFormsSegments_ID AS SegID, ' + @Language + '
AS TheText FROM tblCMSFormsSegments Segs INNER JOIN tblCMSTranslations Trans ON
Segs.tblCMSTranslations_ID = Trans.tblCMSTranslations_ID WHERE Category = ' +
CAST (@Category AS VARCHAR)
: -- EXEC @ExecCode
: PRINT @ExecCode
:
: ---------------------------------------------------------------------------
Shaun
You have to use EXEC (@ExecCode)
not EXEC @ExecCode
Always the little things....
cheers
More information about the thelist
mailing list