Click here to Skip to main content
15,912,977 members
Home / Discussions / Database
   

Database

 
GeneralRe: Data exceeds length of varchar datatype Pin
Colin Angus Mackay6-Mar-06 1:24
Colin Angus Mackay6-Mar-06 1:24 
Dinuj Nath wrote:
Colin Angus Mackay wrote:
Of course, SQL Server has been told to expect a maximum of 7000 characters.

I think it is 8000


No. The original posted said explicitly he'd set it to a varchar(7000) - Therefore the maximum SQL Server will expect is 7000 characters. The maximum that SQL Server 2000 can be told to expect is varchar(8000) but that was not what was specified at part of the original problem.

ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?

GeneralRe: Data exceeds length of varchar datatype Pin
Dinuj Nath6-Mar-06 1:29
Dinuj Nath6-Mar-06 1:29 
GeneralRe: Data exceeds length of varchar datatype Pin
smadan6-Mar-06 1:21
smadan6-Mar-06 1:21 
AnswerRe: Data exceeds length of varchar datatype Pin
HimaBindu Vejella8-Mar-06 0:19
HimaBindu Vejella8-Mar-06 0:19 
GeneralRe: Data exceeds length of varchar datatype Pin
smadan8-Mar-06 0:42
smadan8-Mar-06 0:42 
QuestionDataSets and VS2005 Pin
slappe5-Mar-06 23:16
slappe5-Mar-06 23:16 
QuestionDevelopin Import Export tool Pin
tusha5-Mar-06 20:20
tusha5-Mar-06 20:20 
AnswerRe: Developin Import Export tool Pin
cbhkenshin5-Mar-06 21:46
cbhkenshin5-Mar-06 21:46 
Questiondata type conversion in stored procedure. Pin
GBal5-Mar-06 20:19
GBal5-Mar-06 20:19 
AnswerRe: data type conversion in stored procedure. Pin
Colin Angus Mackay5-Mar-06 22:37
Colin Angus Mackay5-Mar-06 22:37 
QuestionWhich Command to use in SQL 2000 That will give me the same as Limit in MySql Pin
cbhkenshin5-Mar-06 19:31
cbhkenshin5-Mar-06 19:31 
AnswerRe: Which Command to use in SQL 2000 That will give me the same as Limit in MySql Pin
Eric Dahlvang8-Mar-06 9:26
Eric Dahlvang8-Mar-06 9:26 
Questionquery 2nd Pin
welbert5-Mar-06 14:56
welbert5-Mar-06 14:56 
AnswerRe: query 2nd Pin
Colin Angus Mackay5-Mar-06 22:33
Colin Angus Mackay5-Mar-06 22:33 
Questionquery Pin
welbert5-Mar-06 14:33
welbert5-Mar-06 14:33 
AnswerRe: query Pin
Colin Angus Mackay5-Mar-06 22:29
Colin Angus Mackay5-Mar-06 22:29 
QuestionChange to default instance Pin
Tiger4565-Mar-06 14:12
Tiger4565-Mar-06 14:12 
QuestionSearch button to filter a Dataset Pin
thebison5-Mar-06 4:09
thebison5-Mar-06 4:09 
QuestionDuplicate Query Pin
cbhkenshin4-Mar-06 21:59
cbhkenshin4-Mar-06 21:59 
AnswerRe: Duplicate Query Pin
Ritesh12345-Mar-06 18:16
Ritesh12345-Mar-06 18:16 
GeneralRe: Duplicate Query Pin
cbhkenshin5-Mar-06 18:48
cbhkenshin5-Mar-06 18:48 
QuestionMySQL Append? Pin
Expert Coming4-Mar-06 17:03
Expert Coming4-Mar-06 17:03 
QuestionPlease Read It,I Need Urgent Help............. Pin
Monotheismbeliver4-Mar-06 3:18
Monotheismbeliver4-Mar-06 3:18 
AnswerRe: Please Read It,I Need Urgent Help............. Pin
Expert Coming4-Mar-06 17:04
Expert Coming4-Mar-06 17:04 
Questionhow to turn off system error when i add daplicated ID unique? Pin
superdragon4-Mar-06 2:54
superdragon4-Mar-06 2:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.