InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 07:23:27 GMT20http://www.sqlservercentral.com/Forums/Topic505092-338-1.aspx..with possibilities of truncation?Sun, 13 Nov 2011 02:54:01 GMTJohn Esraelo-498130http://www.sqlservercentral.com/Forums/Topic505092-338-1.aspxYou can also use nvarchar(max) which replaces ntext.DrewThu, 10 Nov 2011 07:44:37 GMTdrew.allenhttp://www.sqlservercentral.com/Forums/Topic505092-338-1.aspxthis explains it why mine did not work also.. I had bigint and table data types.. Wed, 09 Nov 2011 17:14:26 GMTJohn Esraelo-498130http://www.sqlservercentral.com/Forums/Topic505092-338-1.aspx[quote][b]mayank.and.friends (6/10/2009)[/b][hr]Sql string should be always either ntext/nvarchar/nchar.[/quote]Only necessary when using sp_executesql (which takes nvarchar parameters). Not important when using EXEC. Also, you cannot define a variable of type ntext.Wed, 10 Jun 2009 08:06:11 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic505092-338-1.aspxSql string should be always either ntext/nvarchar/nchar.So ,please check type of sql query variable as nvarchar():w00t:Wed, 10 Jun 2009 05:03:15 GMTmayank.and.friendshttp://www.sqlservercentral.com/Forums/Topic505092-338-1.aspxyou can use exec, since you're not passing parameters in or out of the dynamic SQL[code]CREATE procedure Search(@SearchKeyword Varchar(2000),@Productid varchar(2000),@Type varchar(200),@SQLPerms varchar(5000))asDeclare @SQL varchar(7000)set @SQL=' This Statement length goes more than 4000.'exec (@SQL)GO[/code]Make sure you're checking for SQL injection attempts.Thu, 22 May 2008 05:50:27 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic505092-338-1.aspxHi, I am using dynamic query in stored procedure. while i am trying to execute the SQL Query in the Procedure, i am getting the error 'Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'.Because i have passed the parameter as Varchar in sp_executesql. The parms must be nVarchar. But my issues is, [b]the length of Dynamic SQL Query is more than 4000. nVarchar maximum lenght is 4000[/b]. Please let me know the solution.my Stored Procedure as,CREATE procedure Search(@SearchKeyword Varchar(2000),@Productid varchar(2000),@Type varchar(200),@SQLPerms varchar(5000))asDeclare @SQL varchar(7000)[b]set @SQL=' This Statement length goes more than 4000.'[/b]exec sp_executesql @SQLGOAppriciate your response asap.Regards,VijayThu, 22 May 2008 05:42:23 GMTantonyvijayan