Is there a limit to how much text you can concatenate (other than data
type limits, of course)? For example, if you write:
SELECT 'This is some text from: ' + Convert(char(15 ), SomeFieldName01 )
+ 'some more text' + Convert(char(25 ), SomeFieldName02 ) + 'yet more
text.' As BigNote
FROM Table
Is there a limit on how much you can concatenate into that big note
field, meaning is there a limit other than the size of the data type?
4  5604 
>Is there a limit on how much you can concatenate into that big note field, meaning is there a limit other than the size of the data type?
No.
Okay, so there is no limit on concatenation. If I continue to
concatenate chars and/or varchars in one column, won't I run into the
8K row size limit? If I do, what would happen? Would I get an error
message, or will the contents of said column be truncated?
ZeldorBlat wrote: Is there a limit on how much you can concatenate into that big note
field, meaning is there a limit other than the size of the data type?
No.
Okay, so there is no limit on concatenation. If I continue to
concatenate chars and/or varchars in one column, won't I run into the
8K row size limit? If I do, what would happen? Would I get an error
message, or will the contents of said column be truncated?
ZeldorBlat wrote: Is there a limit on how much you can concatenate into that big note
field, meaning is there a limit other than the size of the data type?
No.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Randall Sell |
last post by:
Hello all,
I am migrating a Paradox application to SQL Server. My problem is that the
existing Paradox table structure is limited. Correcting it will mean a
re-write of the application (Delphi app). Although the record and column
limits are higher in SQL Server, it will eventually hit the wall. So I was
wondering if anyone could offer advise on how we might do this best....
The application is essentially an evaluation tool. It is very...
|
by: Ken Post |
last post by:
Using Access 2003. Latest patches, on a dozen or so Win XP sp2
machines.
Each machine has its own front copy of the same front end. SQL Server
2000 backend.
Many of the forms have fields on them with controlsource like this:
= & " " &
This works fine on all of the machines except for 2 of them. On these
|
by: michael.casey |
last post by:
The purpose of this post is to obtain the communities opinion of the
usefulness, efficiency, and most importantly the correctness of this
small piece of code. I thank everyone in advance for your time in
considering this post, and for your comments.
I wrote this function to simplify the task of combining strings using
mixed sources. I often see the use of sprintf() which results in
several lines of code, and more processing than really...
|
by: genc_ymeri |
last post by:
Hi over there,
Propably this subject is discussed over and over several times. I did google
it too but I was a little bit surprised what I read on internet when it
comes 'when to use what'.
Most of articles I read from different experts and programmers tell me that
their "gut feelings" for using stringBuilder instead of string concatenation
is when the number of string concatunation is more then N ( N varies between
3 to max 15 from...
|
by: Edgar |
last post by:
Hello,
Using SQL SERVER 2000
I have 4 columns with varchar(80) each that I want to concatenate.
When I look at the result, it only gives me 256 characters. What am I
missing on my code?
Select Cust_Number, Info = convert(varchar(1000),rtrim(line1) +
char(13)+rtrim(Line2) + char(13)+ rtrim(line3) + char(13)+
| | |
by: Robert P |
last post by:
I have a database with 10,000 records and I want to just see record
1000 - 1025 is there an easy way to do this with a query. I have found
info for my SQL using limits but it does not work with SQL Server 2000.
Please help.
Thanks in advance.
|
by: NarutoFanatic |
last post by:
Hi!
I need help in MS ACCESS, I need to create a query that could move different rows into another column. More like concatenation but in a different column rather than in one column. Example:
OLD TABLE
Stud# School Major YrGrad
00001 ABC Science 1996
00001 ROC Math 2000
00002 SAR Biology 1998
|
by: Drew |
last post by:
Hello all,
Does anybody know if it is possible to set the default value of a
field to equal the concatenation of 2 other fields?
I.E.
Field 1 = 123
Field 2 = 345
Field 3 = (Field1 + Field2) = 123345
This is easy enough to do using a stored procedure, but I'm trying to
|
by: howard.canaway |
last post by:
I have always wondered about the specification page in the Access Help
files. It reads
Microsoft Access database (.mdb) file size 2 gigabytes. However,
because your database can include linked tables in other files, its
total size is limited only by available storage capacity.
Number of objects in a database 32,768
Modules (including forms and reports with the HasModule property set
to True) 1,000
Number of characters in an object name...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
