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  5592 
>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...
|
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...
|
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...
|
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...
|
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?
...
| | |
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...
|
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:
...
|
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) =...
|
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...
|
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...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| | |
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...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
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,...
|
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...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
| | |
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...
| |
