|
by: Peter |
last post by:
Hi everyone
I had an access database running as the source for a website but it
has become too large to run correctly so it has been ported to MS-SQL
the problem is that 4 of the fields were Memo fields in access and as
such are 5000+ characters long each this overflows the allowed size on
the SQL server (8192)
Is there a way round without splitting those 4 fields into seperate
tales?? as this would cause a truly major re-write of the...
|
by: kieran |
last post by:
Hi,
I have a form which is submitting into a sql server db. i have one of
the fields set to ntext which says length of 16. when i insert info,
it only sumbits about a paragraph and when i pull this back using
analyser it amounts to a byte count of 256 bytes. i thought you could
submit pages of info using ntext??
i had been trying to use varchar with a length of 7000, but for some
reason only info on the one line is submitted. if...
|
by: Pi |
last post by:
Hi guys,
I have a stored procedure that I will subsequently post below this
message. What the stored procedure does is, it reads some specific
tables in a database and created XML off it.
The problem comes in when the data is bigger than a few hundred/
thousand characters. The data is truncated and the XML file is not
fully made.
|
by: Sileesh |
last post by:
HI
I know this is not the right forum to post this question, but i think some
one might have a suggestion.
I have a Table "Test" with columns
Id bigint (PK), Number Varchar(50), Notes ntext. in sql server 2000
I ahve a stored procedure in which i am trying to insert the same data as
new record with column "Number" changed.
|
by: Chad |
last post by:
I've run into a problem where I create a DataTable, Create an Integer column
and assign the value DBNULL.Value to it.
When I use the ds.GetXML to get the XML represnetation of this table, if the
column contains only NULL values the column does not appear in the table.
I would expect the column to appear with no value between the tags or some
other convention used.
This can't be working as intended, can it?! :-(
|
|
by: AlanMF |
last post by:
A problem recently cropped up that I have not seen before and I am wondering
anyone has seen this one?
The 2 SQl Select statements on my ASP page differ by the addition of one
column ("Description") but in the 2nd case, column content is dropped
(blank). I can get somewhat different results by adding other columns to the
Select.
---------------------------------------------------
1)
|
by: Cylix |
last post by:
Is there any difference between a nText field value='' and value=NULL ?
|
by: radcaesar |
last post by:
Hi,
I am reading a xml file using T-SQL. I want the xml data to use in openxml. So i was using cursor here.
Here i am concatenating the xml data into a variable called @FileContents. When i print this variable content inside the WHILE FetchStatus of CURSOR, its printing fine. If i print after the cursor execution s over, it doen't shows anything and its blank.
Where am i missing ?
DECLARE @FileName varchar(255)
DECLARE @ExecCmd...
|
by: balamk81 |
last post by:
I've a question about ntext and text. How do you use them in a stored procedure? When I try to use an ntext data type in a proc i get this error -
'The assignment operator operation cannot take a ntext data type as an argument' -
this is the proc;
CREATE PROCEDURE test_content
@sno int OUTPUT,
@commens ntext OUTPUT
|
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: 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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
|
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: 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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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: 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: 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 we have to send another system
|
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|