InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 26 May 2013 02:29:10 GMT20http://www.sqlservercentral.com/Forums/Topic710944-338-1.aspx[quote][b]pushpa.kumari (5/6/2009)[/b][hr]Hi,text datatype can have maximum length of 8000.I think you should break your dynamic query into 2-3 parts. [/quote]Text doesn't actually have a limit that low. Large Objects, LOB or BLOB for the binary large objects, are stored on disk, seperate from the table. However, use of the BLOB types are discouraged in 2005/2008.The OP found the right answer, using VARCHAR(MAX) is the way to go. If you were working with a binary it would be VARBINARY (MAX).Wed, 06 May 2009 07:11:27 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic710944-338-1.aspxnvarchar(max) solved my purpose , thanks a lot !Wed, 06 May 2009 06:34:47 GMTsolutionsdxbhttp://www.sqlservercentral.com/Forums/Topic710944-338-1.aspxYou cannot specify a column width on data type text.Wed, 06 May 2009 06:15:14 GMTMadhivanan-208264http://www.sqlservercentral.com/Forums/Topic710944-338-1.aspxHi,text datatype can have maximum length of 8000.I think you should break your dynamic query into 2-3 parts. Wed, 06 May 2009 05:37:32 GMTpushpa.kumarihttp://www.sqlservercentral.com/Forums/Topic710944-338-1.aspxHi , I am using a store procedure where i am creating a query dynamic , but query size is increasing the limit of varchar(8000) size , how i can use the data type text in the store procedure to store the created query and then run using the command Exec(@query)I tried declaring it using the method below :DECLARE @Query text(16000)but giving me the error below : Msg 131, Level 15, State 3, Procedure csplitsubtable_loop, Line 11The size (16000) given to the type 'text' exceeds the maximum allowed for any data type (8000).Wed, 06 May 2009 05:25:34 GMTsolutionsdxb