MS SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me

The Shed is going Social! Join us on FaceBook and Twitter and chime in on the conversation.

Go Back   Dev Shed ForumsDatabasesMS SQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old January 11th, 2013, 02:47 AM
narrokk narrokk is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Oct 2012
Posts: 31 narrokk User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 h 42 sec
Reputation Power: 1
Nvarchar to have more than 4000 size

I'm working with SQL Server 2000 and i got this problem about dynamic sql query. i have successfully produced a query that i need, the problem is when storing it in the variable. In SQL Server 2000, nvarchar has a max value of 4000 bit? or length, not so sure.. but as i have read in Google, and as far as i know, SQL server 2005 has the nvarchar(max) which could hold on up to 2GB memory. I have to use nvarchar because i pass the variable to the sp_executesql stored procedure, and as i have read in this article, <a> http://www.mssqltips.com/sqlservertip/1160/execute-dynamic-sql-commands-in-sql-server/ </a> it seems that EXEC has a problem regarding long queries so it was a preferred approach to use sp_executesql. Is there any other way to pass a lenghty, large size of a query

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesMS SQL Development > Nvarchar to have more than 4000 size

Developer Shed Advertisers and Affiliates



Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.

© 2003-2013 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap