Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ganeshkumar08
Posting Yak Master
187 Posts |
 Posted - 2008-09-11 : 07:17:55
|
| Hi All,Can i know the equivalent datatype like varchar(max) available in sql2005, which i need in sql2000, because i need to create one dynamic query which has maximum number of characters. What to do, please give me an idea...GaneshSolutions are easy. Understanding the problem, now, that's the hard part |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-11 : 07:29:28
|
| In sql 2000 you dont have max, maximum length is 8000. Unless you look at text data type, Which isnt as reliable. |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-11 : 07:29:55
|
| Dont post twice http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=110463 |
|
|
|
ganeshkumar08
Posting Yak Master
187 Posts |
Posted - 2008-09-11 : 07:51:26
|
| ok, but you didnt give me answer for my question..Solutions are easy. Understanding the problem, now, that's the hard part |
|
|
|
Ron Kunce
Starting Member
1 Post |
Posted - 2008-09-12 : 13:34:16
|
| He gave you the solution if you read it correctly. In 2000 varchar(8000) is the maximum size. However, you will find it comes with certain limitations. Since the maximum record size in 2000 is around 8060 bytes, you can define a varchar(8000), but you can't store 8,000 characters in the field if it makes the total record size go over 8,060 bytes. SQL Server will issue a warning about this on creating a table with more than 8060 total record bytes in the definition. So you probably should limit your varchar size to something less. This is the primary reason for having created the max parameter in 2005! |
|
|
|
|
|
|
|
|
Help me in varchar data type in sql2000