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

Re: Dynamic SQL madness on SQL 2008

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!news.musoftware.de!wum.musoftware.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From	Hugo Kornelis <hugo@perFact.REMOVETHIS.info.INVALID>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Dynamic SQL madness on SQL 2008
Date	Fri, 30 Sep 2011 21:33:41 +0200
Lines	10
Message-ID	<a96c879q6lkpet3fk276bo2ap0cc2vbces@4ax.com> (permalink)
References	<67a6ef76-3dbb-4225-9372-b93efcfa36ed@m5g2000vbe.googlegroups.com>
Mime-Version	1.0
Content-Type	text/plain; charset=us-ascii
Content-Transfer-Encoding	7bit
X-Trace	individual.net dNRR0oAwFuzKr6c0ZTjipg9MUEYz83uKUl3IqykGLxpnB+51Ah
Cancel-Lock	sha1:SHKGxhO0dGlcvAN1Ry+PkYabdSc=
X-Newsreader	Forte Agent 6.00/32.1186
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:693

Show key headers only | 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