CODEWITHSUNDEEP
sqlsql-server-2005t-sqldynamic-sql
OMG Ponies
OMG Ponies

Reputation: 332541

Incorrect syntax near 'sp_executesql'

I don't understand why the following is giving me the error. I thought it was related to the commented out section, but @SQL is nvarchar(4000).

BEGIN
  sp_executesql N'SELECT ''td'''
  --sp_executesql @SQL, N'@StartDate DateTime, @EndDate DateTime, @End2 DateTime, @Program varchar(4)', @StartDate, @EndDate, @End2, @Program
END

Upvotes: 8

Views: 6893

Answers (3)

Manjot
Manjot

Reputation: 11516

On some occasions I had to use master as well:

exec master..sp_executesql

Upvotes: 0

ahsteele
ahsteele

Reputation: 26504

Why do you have this enclosed in a BEGIN ... END? Running the sp_executesql external the block will work.

Optionally you can put an exec before sp_executesql.

Upvotes: 3

Sam Saffron
Sam Saffron

Reputation: 131112

This is why:

-- This works just fine:
BEGIN
  -- You must have an exec before your sp_executesql or it will not work in a block
  exec sp_executesql N'SELECT ''td'''
END

You can't just call a stored proc without an exec when you are in a block.

Upvotes: 16

Related Questions