Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #693

Re: Dynamic SQL madness on SQL 2008

Show all headers | View raw

Hi JAW,

The error message tells you what the problem is. The parameter for
sp_executesql that holds the statement should be of type
ntext/nchar/nvarchar. You have declared it as varchar. Change that to
nvarchar (and ditto for the parameter that holds the parameter list)
and it will work.
-- 
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

Dynamic SQL madness on SQL 2008 JAW <willjamu@gmail.com> - 2011-09-30 11:59 -0700
  Re: Dynamic SQL madness on SQL 2008 Hugo Kornelis <hugo@perFact.REMOVETHIS.info.INVALID> - 2011-09-30 21:33 +0200

csiph-web