Dear all,
I am building a news web site for oneof my customers and actually I have
question regarding the way to store huge big text document.
The web site is build using ASP.NET 1.1
I need to update or store time to time news information in an sql server
database.
For that I was wondering how this kind of information are store in fields.
For instance I have a content of a word document which can be big.
I can I store that document content in the database in order that when my
client browse to the proper page news information cames from that document.
Any sample to test it or tips ?
Do I have to store in database only the path for the document or the full
content ?
thnaks for your help
regards
sergea.. Try not to use TEXT or NTEXT datatypes for storing large textual data.
The TEXT datatype has some inherent problems associated with it. For
example, you cannot directly write or update text data using the INSERT or
UPDATE statements. Instead, you have to use special statements like
READTEXT, WRITETEXT and UPDATETEXT. There are also a lot of bugs associated
with replicating tables containing text columns. So, if you don't have to
store more than 8KB of text, use CHAR(8000) or VARCHAR(8000) datatypes
instead.
a.. If you have a choice, do not store binary or image files (Binary Large
Objects or BLOBs) inside the database. Instead, store the path to the binary
or image file in the database and use that as a pointer to the actual binary
file stored elsewhere on a server. Retrieving and manipulating these large
binary files is better performed outside the database, and after all, a
database is not meant for storing files.
Extract from http://www.sql-server-performance.c...t_practices.asp
"serge calderara" <sergecalderara@.discussions.microsoft.com> wrote in
message news:10BB4A34-AD64-46C6-8714-D5D032BEF7E2@.microsoft.com...
> Dear all,
> I am building a news web site for oneof my customers and actually I have
> question regarding the way to store huge big text document.
> The web site is build using ASP.NET 1.1
> I need to update or store time to time news information in an sql server
> database.
> For that I was wondering how this kind of information are store in fields.
> For instance I have a content of a word document which can be big.
> I can I store that document content in the database in order that when my
> client browse to the proper page news information cames from that
document.
> Any sample to test it or tips ?
> Do I have to store in database only the path for the document or the full
> content ?
> thnaks for your help
> regards
> serge|||Thanks for your reply
How do I add text in those fields, directly typing in without formatting.?
Or can I open word, use copy and paste the content in the field ?
regards
serge
"Jonathan Chong" wrote:
> a.. Try not to use TEXT or NTEXT datatypes for storing large textual data.
> The TEXT datatype has some inherent problems associated with it. For
> example, you cannot directly write or update text data using the INSERT or
> UPDATE statements. Instead, you have to use special statements like
> READTEXT, WRITETEXT and UPDATETEXT. There are also a lot of bugs associate
d
> with replicating tables containing text columns. So, if you don't have to
> store more than 8KB of text, use CHAR(8000) or VARCHAR(8000) datatypes
> instead.
>
> a.. If you have a choice, do not store binary or image files (Binary Large
> Objects or BLOBs) inside the database. Instead, store the path to the bina
ry
> or image file in the database and use that as a pointer to the actual bina
ry
> file stored elsewhere on a server. Retrieving and manipulating these large
> binary files is better performed outside the database, and after all, a
> database is not meant for storing files.
> Extract from [url]http://www.sql-server-performance.com/vk_sql_best_practices.asp[/ur
l]
>
> "serge calderara" <sergecalderara@.discussions.microsoft.com> wrote in
> message news:10BB4A34-AD64-46C6-8714-D5D032BEF7E2@.microsoft.com...
> document.
>
>
Showing posts with label text. Show all posts
Showing posts with label text. Show all posts
Friday, March 30, 2012
Monday, March 26, 2012
help on join statement
I have table A:
ID int
Name text
And Table B
ID int
Name text
Now, I want to select all records from A where there is no matching record in B based on the ID
I want to do this with a JOIN statement and not a subquery as I understood that the execution plan for JOIN statements is more efficient...
Any help?
Something like this:
select *
from TableA
left outer join TableB
on TableA.ID= TableB.ID
where TableB.ID is null
The inner query does an outer join, all records show up, some with nulls
The outer query gets the records with null
|||SELECT A.* FROM A LEFT OUTER JOIN B on A.ID = B.ID WHERE B.ID IS NULL
I would strongly advise comparing performance with
SELECT * FROM A WHERE A.ID NOT IN (SELECT ID FROM B)
sqlFriday, March 23, 2012
Help on Ignored Words in Full Text Query
I'm implementing the search features on a web site.
If I search for several words not in the noise file everithing is ok.
If I search with several words and only one of it is in the noise file
the query fails with
Execution of a full-text operation failed. A clause of the query
contained only ignored words.
Why say me that the clause contain only ignored words?
This is the query:
SELECT * FROM MyTable WHERE CONTAINS(*,'"lock" AND "close" AND
"window"')
SELECT * FROM MyTable WHERE CONTAINS(*,'"lock" AND "from" AND
"window"')
Thanks a lot for your help!!
Andrew
"From" is considered to be a noise word and can trigger this error. The best
approach for smaller tables you are Full Text Indexing is to empty the
contents your noise word list and replace it with a single space.
To do this go to a command prompt and type net stop MSSearch and press enter
Go to go to c:\Program Files\Microsoft
SQLServer\mssql\ftdata\sqlserver\config. Then edit the noise.enu (for US
English) in notepad, press ctrl and A, and then press the space bar. Then
select File and Save.
Then restart MSSearch.
You should then do a full population.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Andrew" <a.fileccia@.contactaspa.com> wrote in message
news:53107877.0412040626.80f78c3@.posting.google.co m...
> I'm implementing the search features on a web site.
> If I search for several words not in the noise file everithing is ok.
> If I search with several words and only one of it is in the noise file
> the query fails with
> Execution of a full-text operation failed. A clause of the query
> contained only ignored words.
> Why say me that the clause contain only ignored words?
> This is the query:
>
> SELECT * FROM MyTable WHERE CONTAINS(*,'"lock" AND "close" AND
> "window"')
> SELECT * FROM MyTable WHERE CONTAINS(*,'"lock" AND "from" AND
> "window"')
> Thanks a lot for your help!!
> Andrew
|||Andrew,
This is a common question on this newsgroup and one that can be workaround,
via either client-side or server-side solutions. As for the text of the
message, I agree that it is badly written as most often the query will not
contain only noise words, but in fact one or more depending upon how the
search words are specified in the search condition.
I'd recommend that you review SQL Server 2000 BOL title "Full-text Search
Recommendations", and KB article 246800 (Q246800) "INF: Correctly Parsing
Quotation Marks in FTS Queries" at
http://support.microsoft.com//defaul...b;EN-US;246800 (with T-SQL,
JavaScript, & VBScript coding examples) and search this newsgroup for
SearchPage.htm (or SearchPage.zip) for server-side and client-side solution
of removing the noise words before issuing a SQL FTS query.
Hope this helps!
John
"Andrew" <a.fileccia@.contactaspa.com> wrote in message
news:53107877.0412040626.80f78c3@.posting.google.co m...
> I'm implementing the search features on a web site.
> If I search for several words not in the noise file everithing is ok.
> If I search with several words and only one of it is in the noise file
> the query fails with
> Execution of a full-text operation failed. A clause of the query
> contained only ignored words.
> Why say me that the clause contain only ignored words?
> This is the query:
>
> SELECT * FROM MyTable WHERE CONTAINS(*,'"lock" AND "close" AND
> "window"')
> SELECT * FROM MyTable WHERE CONTAINS(*,'"lock" AND "from" AND
> "window"')
> Thanks a lot for your help!!
> Andrew
sql
If I search for several words not in the noise file everithing is ok.
If I search with several words and only one of it is in the noise file
the query fails with
Execution of a full-text operation failed. A clause of the query
contained only ignored words.
Why say me that the clause contain only ignored words?
This is the query:
SELECT * FROM MyTable WHERE CONTAINS(*,'"lock" AND "close" AND
"window"')
SELECT * FROM MyTable WHERE CONTAINS(*,'"lock" AND "from" AND
"window"')
Thanks a lot for your help!!
Andrew
"From" is considered to be a noise word and can trigger this error. The best
approach for smaller tables you are Full Text Indexing is to empty the
contents your noise word list and replace it with a single space.
To do this go to a command prompt and type net stop MSSearch and press enter
Go to go to c:\Program Files\Microsoft
SQLServer\mssql\ftdata\sqlserver\config. Then edit the noise.enu (for US
English) in notepad, press ctrl and A, and then press the space bar. Then
select File and Save.
Then restart MSSearch.
You should then do a full population.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Andrew" <a.fileccia@.contactaspa.com> wrote in message
news:53107877.0412040626.80f78c3@.posting.google.co m...
> I'm implementing the search features on a web site.
> If I search for several words not in the noise file everithing is ok.
> If I search with several words and only one of it is in the noise file
> the query fails with
> Execution of a full-text operation failed. A clause of the query
> contained only ignored words.
> Why say me that the clause contain only ignored words?
> This is the query:
>
> SELECT * FROM MyTable WHERE CONTAINS(*,'"lock" AND "close" AND
> "window"')
> SELECT * FROM MyTable WHERE CONTAINS(*,'"lock" AND "from" AND
> "window"')
> Thanks a lot for your help!!
> Andrew
|||Andrew,
This is a common question on this newsgroup and one that can be workaround,
via either client-side or server-side solutions. As for the text of the
message, I agree that it is badly written as most often the query will not
contain only noise words, but in fact one or more depending upon how the
search words are specified in the search condition.
I'd recommend that you review SQL Server 2000 BOL title "Full-text Search
Recommendations", and KB article 246800 (Q246800) "INF: Correctly Parsing
Quotation Marks in FTS Queries" at
http://support.microsoft.com//defaul...b;EN-US;246800 (with T-SQL,
JavaScript, & VBScript coding examples) and search this newsgroup for
SearchPage.htm (or SearchPage.zip) for server-side and client-side solution
of removing the noise words before issuing a SQL FTS query.
Hope this helps!
John
"Andrew" <a.fileccia@.contactaspa.com> wrote in message
news:53107877.0412040626.80f78c3@.posting.google.co m...
> I'm implementing the search features on a web site.
> If I search for several words not in the noise file everithing is ok.
> If I search with several words and only one of it is in the noise file
> the query fails with
> Execution of a full-text operation failed. A clause of the query
> contained only ignored words.
> Why say me that the clause contain only ignored words?
> This is the query:
>
> SELECT * FROM MyTable WHERE CONTAINS(*,'"lock" AND "close" AND
> "window"')
> SELECT * FROM MyTable WHERE CONTAINS(*,'"lock" AND "from" AND
> "window"')
> Thanks a lot for your help!!
> Andrew
sql
Wednesday, March 21, 2012
Help on a Query
I have a table (ResidentList) which includes the following fields
- ID (autonumber)
- Address2 (text)
- Area (text)
Address2 usually contains an apartment number like "122 GV" but is always
blank when Area is "Duplex"
Area contains a string like "Glen View", "Northwind", "Duplex", ec.
I want a query to return the count of unique values for the combination of
(Address2 + Area) and the total count of IDs. The result must be grouped by
Area
I get all tangled up trying to code the count of unique values of Address2 +
Area. I think I am approaching it the wrong way. To get just the count of
IDs grouped by Area I use the following query which works fine but when I
start trying to add the unique values of Address2 + Area I can't find the
correct syntax.
SELECT ResidentList.Area, Count(ResidentList.ID) AS CountOfID
FROM ResidentList
GROUP BY ResidentList.Area
ORDER BY Count(ID) DESC;
--
Any suggestions are appreciated.Try this:
SELECT ResidentList.Area, ResidentList.Address2, Count(ResidentList.ID) AS
CountOfID
FROM ResidentList
GROUP BY ResidentList.Area, ResidentList.Address2
ORDER BY Count(ID) DESC;
ML
http://milambda.blogspot.com/|||I appreciate the response but that results in a row for every value of
Address2. I want the distict count
Wayne
"ML" <ML@.discussions.microsoft.com> wrote in message
news:A44A7033-F87F-4C4B-B713-149331B17AA6@.microsoft.com...
> Try this:
> SELECT ResidentList.Area, ResidentList.Address2, Count(ResidentList.ID) AS
> CountOfID
> FROM ResidentList
> GROUP BY ResidentList.Area, ResidentList.Address2
> ORDER BY Count(ID) DESC;
>
> ML
> --
> http://milambda.blogspot.com/|||Can you post the DDL for this and some sample data
"Wayne Wengert" wrote:
> I have a table (ResidentList) which includes the following fields
> - ID (autonumber)
> - Address2 (text)
> - Area (text)
> Address2 usually contains an apartment number like "122 GV" but is always
> blank when Area is "Duplex"
> Area contains a string like "Glen View", "Northwind", "Duplex", ec.
> I want a query to return the count of unique values for the combination of
> (Address2 + Area) and the total count of IDs. The result must be grouped b
y
> Area
> I get all tangled up trying to code the count of unique values of Address2
+
> Area. I think I am approaching it the wrong way. To get just the count of
> IDs grouped by Area I use the following query which works fine but when I
> start trying to add the unique values of Address2 + Area I can't find the
> correct syntax.
> --
> SELECT ResidentList.Area, Count(ResidentList.ID) AS CountOfID
> FROM ResidentList
> GROUP BY ResidentList.Area
> ORDER BY Count(ID) DESC;
> --
> Any suggestions are appreciated.
>
>|||Sorry - Should have included that in the original post... I needed to
obscure some personal information first.
========================================
=====
CREATE TABLE [ResidentList] (
[ID] [int] NOT NULL ,
[LastName] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[FirstName] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Address1] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Address2] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[City] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[State] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ZIP] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Area] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Phone] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Email] [nvarchar] (65) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(1,
'Burton', 'Betty', '2101 S. Podunk Ave', '139 GV', 'SomeCity', 'CA',
'12345', 'Garden View', '555-9024', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(2,
'Parker', 'Bonnie', '2101 S. Podunk Ave.', '138 GV', 'SomeCity', 'CA',
'12345', 'Garden View', '555-6738', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(3,
'Galloway', 'Richard', '2101 S. Podunk Ave.', '126 GV', 'SomeCity', 'CA',
'12345', 'Garden View', '555-3213', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(4,
'Martin', 'Ruth A.', '2113 S. Podunk Ave.', NULL, 'SomeCity', 'CA', '12345',
'Duplex', '555-1855', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(5,
'Adams', 'Ike', '2101 S. Podunk Ave.', '234 B', 'SomeCity', 'CA', '12345',
'Boulevard', '555-9679', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(6,
'Anderson', 'Barbara', '2101 S. Podunk Ave.', '039 GV', 'SomeCity', 'CA',
'12345', 'Garden View', '555-1286', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(7,
'Bachman', 'Joe', '2101 S. Podunk Ave.', '252 BH', 'SomeCity', 'CA',
'12345', 'Blue Heron', '555-5012', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(8,
'Bailey', 'Richard', '2101 S. Podunk Ave.', '156 BH', 'SomeCity', 'CA',
'12345', 'Blue Heron', '555-6454', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(9,
'Baker', 'Jewell', '2101 S. Podunk Ave.', '136 GV', 'SomeCity', 'CA',
'12345', 'Garden View', '555-37778', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(10,
'Ballard', 'Margie', '2101 S. Podunk Ave.', '043 BH', 'SomeCity', 'CA',
'12345', 'Blue Heron', '555-4623', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(11,
'Benson', 'Helen Louise', '2101 S. Podunk Ave.', '409 AL', 'SomeCity', 'CA',
'12345', 'Assisted Living', '555-0684', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(12,
'Bernhardt', 'Irene', '2101 S. Podunk Ave.', '130 B', 'SomeCity', 'CA',
'12345', 'Boulevard', '555-0771', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(13,
'Bigge', 'CArrine', '2101 S. Podunk Ave.', '121 B', 'SomeCity', 'CA',
'12345', 'Boulevard', '555-4052', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(14,
'Bischoff', 'Donna', '2101 S. Podunk Ave.', '135 GV', 'SomeCity', 'CA',
'12345', 'Garden View', '555-3739', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(15,
'Bishop', 'Ruth', '2101 S. Podunk Ave.', '204 AL', 'SomeCity', 'CA',
'12345', 'Assisted Living', '555-9241', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(16,
'Blomberg', 'Ruth', '2101 S. Podunk Ave.', '226 B', 'SomeCity', 'CA',
'12345', 'Boulevard', '555-9772', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(17,
'Boeke', 'Adah', '2101 S. Podunk Ave.', '427 BS', 'SomeCity', 'CA', '12345',
'Boulevard South', '555-5359', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(18,
'Bower', 'Dawn', '2101 S. Podunk Ave.', '137 GV', 'SomeCity', 'CA', '12345',
'Garden View', '555-2020', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(19,
'Brennesholt', 'Evelyn', '2101 S. Podunk Ave.', '315 AL', 'SomeCity', 'CA',
'12345', 'Assisted Living', '613-1558', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(20,
'Brown', 'Roberta', '2101 S. Podunk Ave.', '038 GV', 'SomeCity', 'CA',
'12345', 'Garden View', '555-8590', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(21,
'Brownlee', 'Jo', '2101 S. Podunk Ave.', '433 B', 'SomeCity', 'CA', '12345',
'Boulevard', '555-4432', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(22,
'Bruce', 'William', '2101 S. Podunk Ave.', '158 BH', 'SomeCity', 'CA',
'12345', 'Blue Heron', '555-0161', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(23,
'Bruce', 'Thelma', '2101 S. Podunk Ave.', '158 BH', 'SomeCity', 'CA',
'12345', 'Blue Heron', '555-0161', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(24,
'Bucklen', 'Helen', '2101 S. Podunk Ave.', '258 BH', 'SomeCity', 'CA',
'12345', 'Blue Heron', '555-0327', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(25,
'Bucklen', 'Sharon', '2101 S. Podunk Ave.', '258 BH', 'SomeCity', 'CA',
'12345', 'Blue Heron', '555-0327', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(26,
'Callahan', 'Margaret', '2101 S. Podunk Ave.', '322 B', 'SomeCity', 'CA',
'12345', 'Boulevard', '555-8198', NULL)
========================================
=====
"Sha Anand" <ShaAnand@.discussions.microsoft.com> wrote in message
news:18A0273D-337D-4E90-916C-52EDA2A0DA3C@.microsoft.com...
> Can you post the DDL for this and some sample data
> "Wayne Wengert" wrote:
>|||try Count(distinct (Area+Address2))?
YH
"Wayne Wengert" wrote:
> I have a table (ResidentList) which includes the following fields
> - ID (autonumber)
> - Address2 (text)
> - Area (text)
> Address2 usually contains an apartment number like "122 GV" but is always
> blank when Area is "Duplex"
> Area contains a string like "Glen View", "Northwind", "Duplex", ec.
> I want a query to return the count of unique values for the combination of
> (Address2 + Area) and the total count of IDs. The result must be grouped b
y
> Area
> I get all tangled up trying to code the count of unique values of Address2
+
> Area. I think I am approaching it the wrong way. To get just the count of
> IDs grouped by Area I use the following query which works fine but when I
> start trying to add the unique values of Address2 + Area I can't find the
> correct syntax.
> --
> SELECT ResidentList.Area, Count(ResidentList.ID) AS CountOfID
> FROM ResidentList
> GROUP BY ResidentList.Area
> ORDER BY Count(ID) DESC;
> --
> Any suggestions are appreciated.
>
>|||I had tried that. I get an error that "distinct" is an undefined function in
the expression?
"YH" <YH@.discussions.microsoft.com> wrote in message
news:904262EB-0A7F-4111-99FA-123CF4CB36D3@.microsoft.com...
> try Count(distinct (Area+Address2))?
> YH
> "Wayne Wengert" wrote:
>|||Is this what you are looking at
SELECT ResidentList.Area, Count(DISTINCT ISNULL(ResidentList.Address2,''))
AS CountOfID
FROM ResidentList
GROUP BY ResidentList.Area
ORDER BY ResidentList.Area
Assisted Living 3
Blue Heron 5
Boulevard 6
Boulevard South 1
Duplex 1
Garden View 8
- Sha Anand
"Wayne Wengert" wrote:
> I had tried that. I get an error that "distinct" is an undefined function
in
> the expression?
>
> "YH" <YH@.discussions.microsoft.com> wrote in message
> news:904262EB-0A7F-4111-99FA-123CF4CB36D3@.microsoft.com...
>
>|||Sha;
Interesting approch but when I try it I get a "Syntax error (missing
operator) in expression 'Count(DISTINCT ISNULL(ResidentList.Address2,''))'
Wayne
"Sha Anand" <ShaAnand@.discussions.microsoft.com> wrote in message
news:F235F5F4-BD81-49FA-AFF6-CDD04ED92CC7@.microsoft.com...
> Is this what you are looking at
>
> SELECT ResidentList.Area, Count(DISTINCT ISNULL(ResidentList.Address2,''))
> AS CountOfID
> FROM ResidentList
> GROUP BY ResidentList.Area
> ORDER BY ResidentList.Area
> Assisted Living 3
> Blue Heron 5
> Boulevard 6
> Boulevard South 1
> Duplex 1
> Garden View 8
>
> - Sha Anand
> "Wayne Wengert" wrote:
>|||Hi Wayne,
The query i sent you works fine in SQL 2000,
by looking at the error msg - i assume that you are trying to run this
in MS-Access. All SQL 2000 queries may not be compatible with MS-Access.
You need to check MS-Access documentation.
Otherwise you can create a view in SQL 2000 and use it in MS-Access
- Sha Anand
"Wayne Wengert" wrote:
> Sha;
> Interesting approch but when I try it I get a "Syntax error (missing
> operator) in expression 'Count(DISTINCT ISNULL(ResidentList.Address2,''))'
> Wayne
> "Sha Anand" <ShaAnand@.discussions.microsoft.com> wrote in message
> news:F235F5F4-BD81-49FA-AFF6-CDD04ED92CC7@.microsoft.com...
>
>
- ID (autonumber)
- Address2 (text)
- Area (text)
Address2 usually contains an apartment number like "122 GV" but is always
blank when Area is "Duplex"
Area contains a string like "Glen View", "Northwind", "Duplex", ec.
I want a query to return the count of unique values for the combination of
(Address2 + Area) and the total count of IDs. The result must be grouped by
Area
I get all tangled up trying to code the count of unique values of Address2 +
Area. I think I am approaching it the wrong way. To get just the count of
IDs grouped by Area I use the following query which works fine but when I
start trying to add the unique values of Address2 + Area I can't find the
correct syntax.
SELECT ResidentList.Area, Count(ResidentList.ID) AS CountOfID
FROM ResidentList
GROUP BY ResidentList.Area
ORDER BY Count(ID) DESC;
--
Any suggestions are appreciated.Try this:
SELECT ResidentList.Area, ResidentList.Address2, Count(ResidentList.ID) AS
CountOfID
FROM ResidentList
GROUP BY ResidentList.Area, ResidentList.Address2
ORDER BY Count(ID) DESC;
ML
http://milambda.blogspot.com/|||I appreciate the response but that results in a row for every value of
Address2. I want the distict count
Wayne
"ML" <ML@.discussions.microsoft.com> wrote in message
news:A44A7033-F87F-4C4B-B713-149331B17AA6@.microsoft.com...
> Try this:
> SELECT ResidentList.Area, ResidentList.Address2, Count(ResidentList.ID) AS
> CountOfID
> FROM ResidentList
> GROUP BY ResidentList.Area, ResidentList.Address2
> ORDER BY Count(ID) DESC;
>
> ML
> --
> http://milambda.blogspot.com/|||Can you post the DDL for this and some sample data
"Wayne Wengert" wrote:
> I have a table (ResidentList) which includes the following fields
> - ID (autonumber)
> - Address2 (text)
> - Area (text)
> Address2 usually contains an apartment number like "122 GV" but is always
> blank when Area is "Duplex"
> Area contains a string like "Glen View", "Northwind", "Duplex", ec.
> I want a query to return the count of unique values for the combination of
> (Address2 + Area) and the total count of IDs. The result must be grouped b
y
> Area
> I get all tangled up trying to code the count of unique values of Address2
+
> Area. I think I am approaching it the wrong way. To get just the count of
> IDs grouped by Area I use the following query which works fine but when I
> start trying to add the unique values of Address2 + Area I can't find the
> correct syntax.
> --
> SELECT ResidentList.Area, Count(ResidentList.ID) AS CountOfID
> FROM ResidentList
> GROUP BY ResidentList.Area
> ORDER BY Count(ID) DESC;
> --
> Any suggestions are appreciated.
>
>|||Sorry - Should have included that in the original post... I needed to
obscure some personal information first.
========================================
=====
CREATE TABLE [ResidentList] (
[ID] [int] NOT NULL ,
[LastName] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[FirstName] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Address1] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Address2] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[City] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[State] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ZIP] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Area] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Phone] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Email] [nvarchar] (65) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(1,
'Burton', 'Betty', '2101 S. Podunk Ave', '139 GV', 'SomeCity', 'CA',
'12345', 'Garden View', '555-9024', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(2,
'Parker', 'Bonnie', '2101 S. Podunk Ave.', '138 GV', 'SomeCity', 'CA',
'12345', 'Garden View', '555-6738', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(3,
'Galloway', 'Richard', '2101 S. Podunk Ave.', '126 GV', 'SomeCity', 'CA',
'12345', 'Garden View', '555-3213', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(4,
'Martin', 'Ruth A.', '2113 S. Podunk Ave.', NULL, 'SomeCity', 'CA', '12345',
'Duplex', '555-1855', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(5,
'Adams', 'Ike', '2101 S. Podunk Ave.', '234 B', 'SomeCity', 'CA', '12345',
'Boulevard', '555-9679', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(6,
'Anderson', 'Barbara', '2101 S. Podunk Ave.', '039 GV', 'SomeCity', 'CA',
'12345', 'Garden View', '555-1286', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(7,
'Bachman', 'Joe', '2101 S. Podunk Ave.', '252 BH', 'SomeCity', 'CA',
'12345', 'Blue Heron', '555-5012', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(8,
'Bailey', 'Richard', '2101 S. Podunk Ave.', '156 BH', 'SomeCity', 'CA',
'12345', 'Blue Heron', '555-6454', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(9,
'Baker', 'Jewell', '2101 S. Podunk Ave.', '136 GV', 'SomeCity', 'CA',
'12345', 'Garden View', '555-37778', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(10,
'Ballard', 'Margie', '2101 S. Podunk Ave.', '043 BH', 'SomeCity', 'CA',
'12345', 'Blue Heron', '555-4623', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(11,
'Benson', 'Helen Louise', '2101 S. Podunk Ave.', '409 AL', 'SomeCity', 'CA',
'12345', 'Assisted Living', '555-0684', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(12,
'Bernhardt', 'Irene', '2101 S. Podunk Ave.', '130 B', 'SomeCity', 'CA',
'12345', 'Boulevard', '555-0771', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(13,
'Bigge', 'CArrine', '2101 S. Podunk Ave.', '121 B', 'SomeCity', 'CA',
'12345', 'Boulevard', '555-4052', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(14,
'Bischoff', 'Donna', '2101 S. Podunk Ave.', '135 GV', 'SomeCity', 'CA',
'12345', 'Garden View', '555-3739', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(15,
'Bishop', 'Ruth', '2101 S. Podunk Ave.', '204 AL', 'SomeCity', 'CA',
'12345', 'Assisted Living', '555-9241', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(16,
'Blomberg', 'Ruth', '2101 S. Podunk Ave.', '226 B', 'SomeCity', 'CA',
'12345', 'Boulevard', '555-9772', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(17,
'Boeke', 'Adah', '2101 S. Podunk Ave.', '427 BS', 'SomeCity', 'CA', '12345',
'Boulevard South', '555-5359', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(18,
'Bower', 'Dawn', '2101 S. Podunk Ave.', '137 GV', 'SomeCity', 'CA', '12345',
'Garden View', '555-2020', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(19,
'Brennesholt', 'Evelyn', '2101 S. Podunk Ave.', '315 AL', 'SomeCity', 'CA',
'12345', 'Assisted Living', '613-1558', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(20,
'Brown', 'Roberta', '2101 S. Podunk Ave.', '038 GV', 'SomeCity', 'CA',
'12345', 'Garden View', '555-8590', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(21,
'Brownlee', 'Jo', '2101 S. Podunk Ave.', '433 B', 'SomeCity', 'CA', '12345',
'Boulevard', '555-4432', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(22,
'Bruce', 'William', '2101 S. Podunk Ave.', '158 BH', 'SomeCity', 'CA',
'12345', 'Blue Heron', '555-0161', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(23,
'Bruce', 'Thelma', '2101 S. Podunk Ave.', '158 BH', 'SomeCity', 'CA',
'12345', 'Blue Heron', '555-0161', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(24,
'Bucklen', 'Helen', '2101 S. Podunk Ave.', '258 BH', 'SomeCity', 'CA',
'12345', 'Blue Heron', '555-0327', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(25,
'Bucklen', 'Sharon', '2101 S. Podunk Ave.', '258 BH', 'SomeCity', 'CA',
'12345', 'Blue Heron', '555-0327', NULL)
Insert into [ResidentList] ([ID], [LastName], [FirstName], [Address1],
[Address2], [City], [State], [ZIP], [Area], [Phone], [Email]) values(26,
'Callahan', 'Margaret', '2101 S. Podunk Ave.', '322 B', 'SomeCity', 'CA',
'12345', 'Boulevard', '555-8198', NULL)
========================================
=====
"Sha Anand" <ShaAnand@.discussions.microsoft.com> wrote in message
news:18A0273D-337D-4E90-916C-52EDA2A0DA3C@.microsoft.com...
> Can you post the DDL for this and some sample data
> "Wayne Wengert" wrote:
>|||try Count(distinct (Area+Address2))?
YH
"Wayne Wengert" wrote:
> I have a table (ResidentList) which includes the following fields
> - ID (autonumber)
> - Address2 (text)
> - Area (text)
> Address2 usually contains an apartment number like "122 GV" but is always
> blank when Area is "Duplex"
> Area contains a string like "Glen View", "Northwind", "Duplex", ec.
> I want a query to return the count of unique values for the combination of
> (Address2 + Area) and the total count of IDs. The result must be grouped b
y
> Area
> I get all tangled up trying to code the count of unique values of Address2
+
> Area. I think I am approaching it the wrong way. To get just the count of
> IDs grouped by Area I use the following query which works fine but when I
> start trying to add the unique values of Address2 + Area I can't find the
> correct syntax.
> --
> SELECT ResidentList.Area, Count(ResidentList.ID) AS CountOfID
> FROM ResidentList
> GROUP BY ResidentList.Area
> ORDER BY Count(ID) DESC;
> --
> Any suggestions are appreciated.
>
>|||I had tried that. I get an error that "distinct" is an undefined function in
the expression?
"YH" <YH@.discussions.microsoft.com> wrote in message
news:904262EB-0A7F-4111-99FA-123CF4CB36D3@.microsoft.com...
> try Count(distinct (Area+Address2))?
> YH
> "Wayne Wengert" wrote:
>|||Is this what you are looking at
SELECT ResidentList.Area, Count(DISTINCT ISNULL(ResidentList.Address2,''))
AS CountOfID
FROM ResidentList
GROUP BY ResidentList.Area
ORDER BY ResidentList.Area
Assisted Living 3
Blue Heron 5
Boulevard 6
Boulevard South 1
Duplex 1
Garden View 8
- Sha Anand
"Wayne Wengert" wrote:
> I had tried that. I get an error that "distinct" is an undefined function
in
> the expression?
>
> "YH" <YH@.discussions.microsoft.com> wrote in message
> news:904262EB-0A7F-4111-99FA-123CF4CB36D3@.microsoft.com...
>
>|||Sha;
Interesting approch but when I try it I get a "Syntax error (missing
operator) in expression 'Count(DISTINCT ISNULL(ResidentList.Address2,''))'
Wayne
"Sha Anand" <ShaAnand@.discussions.microsoft.com> wrote in message
news:F235F5F4-BD81-49FA-AFF6-CDD04ED92CC7@.microsoft.com...
> Is this what you are looking at
>
> SELECT ResidentList.Area, Count(DISTINCT ISNULL(ResidentList.Address2,''))
> AS CountOfID
> FROM ResidentList
> GROUP BY ResidentList.Area
> ORDER BY ResidentList.Area
> Assisted Living 3
> Blue Heron 5
> Boulevard 6
> Boulevard South 1
> Duplex 1
> Garden View 8
>
> - Sha Anand
> "Wayne Wengert" wrote:
>|||Hi Wayne,
The query i sent you works fine in SQL 2000,
by looking at the error msg - i assume that you are trying to run this
in MS-Access. All SQL 2000 queries may not be compatible with MS-Access.
You need to check MS-Access documentation.
Otherwise you can create a view in SQL 2000 and use it in MS-Access
- Sha Anand
"Wayne Wengert" wrote:
> Sha;
> Interesting approch but when I try it I get a "Syntax error (missing
> operator) in expression 'Count(DISTINCT ISNULL(ResidentList.Address2,''))'
> Wayne
> "Sha Anand" <ShaAnand@.discussions.microsoft.com> wrote in message
> news:F235F5F4-BD81-49FA-AFF6-CDD04ED92CC7@.microsoft.com...
>
>
Monday, March 19, 2012
Help needed with importing text files
I have a load (180,000+) of text files whose contents need to go into a SQL server database.
Whats the best way of doing this? Using a c# console program and if so, using FileStream or StreamReader? Or using a feature of SQL server itself. The text files themselves are less that 1k and are literally less than 200 characters.
The problem is, I've tried a WinForm and although I can detect what files are there, as soon as I attempt to open one for reading, everything stops working and won't insert anything to the database.
http://www.sqldts.com/default.aspx?237
Help needed with complex query
Hi,
I have a sql table, over 30 milion recs, with the following fields:
(id1 int, id2 int, itemsCollection varchar(100), myText TEXT)
I have also sql table, with the following fields: (item varchar(10), rate int)
I need to write a query that returns the following info: id1, id2, itemsCollection, item, rate, myText
The output need to be ordered as:
- Get id1 & id2 with the bigest rate
- output all the recs for the id1 & 2, ordered by rate (sub order)
eg
Main table:
id1 id2 itemsCollection myText
1 1 'a,b' 'count-11-a,B - max = 15 additional txt'
1 1 'a,b' 'count-11-a-B - max = 15'
1 1 '' 'count-11'
1 1 'a,c' 'count-11-a,C - max = 20'
2 8 'c,d' 'count-28-C-d - max = 20 additional txt'
2 8 'c,d' 'count-28-C-d - max = 20'
2 8 'd' 'count-28-D - max = 5'
3 2 'a,d' 'count-32-A-d - max = 10'
3 2 '' 'count-32'
Rates table:
item rate
a 10
b 15
c 20
d 5
'' 0
RequestedOutput:
itemsCollection item rate id1 id2 myText
a,c c 20 1 1 count-11-a,C - max = 20
a,b b 15 1 1 count-11-a,B - max = 15 additional txy
a,b b 15 1 1 count-11-a,B - max = 15
0 1 1 count-11
c,d c 20 2 8 count-28-C-d - max = 20 additional txt
c,d c 20 2 8 count-28-C-d - max = 20
d d 5 2 8 count-28-D - max = 5
a,d a 10 3 2 count-32-A-d - max = 10
0 3 2 count-32
Thanks!you need an application program for that logic
you can sort the results of a join (and in your case the join will be monstrously inefficient, because of the comma-separated list of ids) by descending order of rate, but you can not "take a side trip" and sort all the a/b rows up under the a/b row with the largest rate|||r937, thanks for reply.
No app available - I'm trying to do it using cursor & temp tables, because
Thanks anyway|||okay, then transact-sql is your application programming language
good luck
I have a sql table, over 30 milion recs, with the following fields:
(id1 int, id2 int, itemsCollection varchar(100), myText TEXT)
I have also sql table, with the following fields: (item varchar(10), rate int)
I need to write a query that returns the following info: id1, id2, itemsCollection, item, rate, myText
The output need to be ordered as:
- Get id1 & id2 with the bigest rate
- output all the recs for the id1 & 2, ordered by rate (sub order)
eg
Main table:
id1 id2 itemsCollection myText
1 1 'a,b' 'count-11-a,B - max = 15 additional txt'
1 1 'a,b' 'count-11-a-B - max = 15'
1 1 '' 'count-11'
1 1 'a,c' 'count-11-a,C - max = 20'
2 8 'c,d' 'count-28-C-d - max = 20 additional txt'
2 8 'c,d' 'count-28-C-d - max = 20'
2 8 'd' 'count-28-D - max = 5'
3 2 'a,d' 'count-32-A-d - max = 10'
3 2 '' 'count-32'
Rates table:
item rate
a 10
b 15
c 20
d 5
'' 0
RequestedOutput:
itemsCollection item rate id1 id2 myText
a,c c 20 1 1 count-11-a,C - max = 20
a,b b 15 1 1 count-11-a,B - max = 15 additional txy
a,b b 15 1 1 count-11-a,B - max = 15
0 1 1 count-11
c,d c 20 2 8 count-28-C-d - max = 20 additional txt
c,d c 20 2 8 count-28-C-d - max = 20
d d 5 2 8 count-28-D - max = 5
a,d a 10 3 2 count-32-A-d - max = 10
0 3 2 count-32
Thanks!you need an application program for that logic
you can sort the results of a join (and in your case the join will be monstrously inefficient, because of the comma-separated list of ids) by descending order of rate, but you can not "take a side trip" and sort all the a/b rows up under the a/b row with the largest rate|||r937, thanks for reply.
No app available - I'm trying to do it using cursor & temp tables, because
Thanks anyway|||okay, then transact-sql is your application programming language
good luck
Monday, March 12, 2012
help needed to bring in text files..
background: sql2k on nt5.
can someone give me some advice on how to bring in text files located on a
file server directory into a sql server database?
the text files will always have the same structure, but the file names are
not static (but following a naming standard, such as
location+date.txt, such as
or_05102004
wa_05122004
and so on.
so each file will be broung in as a table such as or_05102004, and
wa_05122004 table.
thank you.
Will you be loading all of the text files into one table, or does each =
type (or, wa, ...) have a different table that it should be loaded into? =
=20
Perhaps you could use BCP or BULK INSERT to import the text files. You =
can define a format file if you choose to use BCP. This format file =
will define the layout of the file and it will determine how it gets =
loaded into the destination table. You could create a stored procedure =
that would take a filename as a param and use a bit of dynamic sql to =
generate the appropriate BCP statement that uses the appropriate format =
file.
Another method would be DTS. You could create a DTS package to insert =
the data into SQL Server. This solution might be difficult to maintain =
if the file names change often. Then again, you could create a routine =
that imports from a standard file name. When you get a new file (on the =
network share) you could copy it to the specific location and file name =
that your DTS package knows about.
--=20
Keith
"=3D=3D Steve Pdx=3D=3D" <lins@.nospam.portptld.com> wrote in message =
news:uCHOz%23sNEHA.1196@.TK2MSFTNGP11.phx.gbl...
> background: sql2k on nt5.
>=20
> can someone give me some advice on how to bring in text files located =
on a
> file server directory into a sql server database?
> the text files will always have the same structure, but the file names =
are
> not static (but following a naming standard, such as
> location+date.txt, such as
> or_05102004
> wa_05122004
> and so on.
>=20
> so each file will be broung in as a table such as or_05102004, and
> wa_05122004 table.
>=20
> thank you.
>=20
>
can someone give me some advice on how to bring in text files located on a
file server directory into a sql server database?
the text files will always have the same structure, but the file names are
not static (but following a naming standard, such as
location+date.txt, such as
or_05102004
wa_05122004
and so on.
so each file will be broung in as a table such as or_05102004, and
wa_05122004 table.
thank you.
Will you be loading all of the text files into one table, or does each =
type (or, wa, ...) have a different table that it should be loaded into? =
=20
Perhaps you could use BCP or BULK INSERT to import the text files. You =
can define a format file if you choose to use BCP. This format file =
will define the layout of the file and it will determine how it gets =
loaded into the destination table. You could create a stored procedure =
that would take a filename as a param and use a bit of dynamic sql to =
generate the appropriate BCP statement that uses the appropriate format =
file.
Another method would be DTS. You could create a DTS package to insert =
the data into SQL Server. This solution might be difficult to maintain =
if the file names change often. Then again, you could create a routine =
that imports from a standard file name. When you get a new file (on the =
network share) you could copy it to the specific location and file name =
that your DTS package knows about.
--=20
Keith
"=3D=3D Steve Pdx=3D=3D" <lins@.nospam.portptld.com> wrote in message =
news:uCHOz%23sNEHA.1196@.TK2MSFTNGP11.phx.gbl...
> background: sql2k on nt5.
>=20
> can someone give me some advice on how to bring in text files located =
on a
> file server directory into a sql server database?
> the text files will always have the same structure, but the file names =
are
> not static (but following a naming standard, such as
> location+date.txt, such as
> or_05102004
> wa_05122004
> and so on.
>=20
> so each file will be broung in as a table such as or_05102004, and
> wa_05122004 table.
>=20
> thank you.
>=20
>
help needed to bring in text files..
background: sql2k on nt5.
can someone give me some advice on how to bring in text files located on a
file server directory into a sql server database?
the text files will always have the same structure, but the file names are
not static (but following a naming standard, such as
location+date.txt, such as
or_05102004
wa_05122004
and so on.
so each file will be broung in as a table such as or_05102004, and
wa_05122004 table.
thank you.Will you be loading all of the text files into one table, or does each =
type (or, wa, ...) have a different table that it should be loaded into? =
=20
Perhaps you could use BCP or BULK INSERT to import the text files. You =
can define a format file if you choose to use BCP. This format file =
will define the layout of the file and it will determine how it gets =
loaded into the destination table. You could create a stored procedure =
that would take a filename as a param and use a bit of dynamic sql to =
generate the appropriate BCP statement that uses the appropriate format =
file.
Another method would be DTS. You could create a DTS package to insert =
the data into SQL Server. This solution might be difficult to maintain =
if the file names change often. Then again, you could create a routine =
that imports from a standard file name. When you get a new file (on the =
network share) you could copy it to the specific location and file name =
that your DTS package knows about.
--=20
Keith
"=3D=3D Steve Pdx=3D=3D" <lins@.nospam.portptld.com> wrote in message =
news:uCHOz%23sNEHA.1196@.TK2MSFTNGP11.phx.gbl...
> background: sql2k on nt5.
>=20
> can someone give me some advice on how to bring in text files located =
on a
> file server directory into a sql server database?
> the text files will always have the same structure, but the file names =
are
> not static (but following a naming standard, such as
> location+date.txt, such as
> or_05102004
> wa_05122004
> and so on.
>=20
> so each file will be broung in as a table such as or_05102004, and
> wa_05122004 table.
>=20
> thank you.
>=20
>
can someone give me some advice on how to bring in text files located on a
file server directory into a sql server database?
the text files will always have the same structure, but the file names are
not static (but following a naming standard, such as
location+date.txt, such as
or_05102004
wa_05122004
and so on.
so each file will be broung in as a table such as or_05102004, and
wa_05122004 table.
thank you.Will you be loading all of the text files into one table, or does each =
type (or, wa, ...) have a different table that it should be loaded into? =
=20
Perhaps you could use BCP or BULK INSERT to import the text files. You =
can define a format file if you choose to use BCP. This format file =
will define the layout of the file and it will determine how it gets =
loaded into the destination table. You could create a stored procedure =
that would take a filename as a param and use a bit of dynamic sql to =
generate the appropriate BCP statement that uses the appropriate format =
file.
Another method would be DTS. You could create a DTS package to insert =
the data into SQL Server. This solution might be difficult to maintain =
if the file names change often. Then again, you could create a routine =
that imports from a standard file name. When you get a new file (on the =
network share) you could copy it to the specific location and file name =
that your DTS package knows about.
--=20
Keith
"=3D=3D Steve Pdx=3D=3D" <lins@.nospam.portptld.com> wrote in message =
news:uCHOz%23sNEHA.1196@.TK2MSFTNGP11.phx.gbl...
> background: sql2k on nt5.
>=20
> can someone give me some advice on how to bring in text files located =
on a
> file server directory into a sql server database?
> the text files will always have the same structure, but the file names =
are
> not static (but following a naming standard, such as
> location+date.txt, such as
> or_05102004
> wa_05122004
> and so on.
>=20
> so each file will be broung in as a table such as or_05102004, and
> wa_05122004 table.
>=20
> thank you.
>=20
>
help needed to bring in text files..
background: sql2k on nt5.
can someone give me some advice on how to bring in text files located on a
file server directory into a sql server database?
the text files will always have the same structure, but the file names are
not static (but following a naming standard, such as
location+date.txt, such as
or_05102004
wa_05122004
and so on.
so each file will be broung in as a table such as or_05102004, and
wa_05122004 table.
thank you.Will you be loading all of the text files into one table, or does each =type (or, wa, ...) have a different table that it should be loaded into? =
Perhaps you could use BCP or BULK INSERT to import the text files. You =can define a format file if you choose to use BCP. This format file =will define the layout of the file and it will determine how it gets =loaded into the destination table. You could create a stored procedure =that would take a filename as a param and use a bit of dynamic sql to =generate the appropriate BCP statement that uses the appropriate format =file.
Another method would be DTS. You could create a DTS package to insert =the data into SQL Server. This solution might be difficult to maintain =if the file names change often. Then again, you could create a routine =that imports from a standard file name. When you get a new file (on the =network share) you could copy it to the specific location and file name =that your DTS package knows about.
-- Keith
"=3D=3D Steve Pdx=3D=3D" <lins@.nospam.portptld.com> wrote in message =news:uCHOz%23sNEHA.1196@.TK2MSFTNGP11.phx.gbl...
> background: sql2k on nt5.
> > can someone give me some advice on how to bring in text files located =on a
> file server directory into a sql server database?
> the text files will always have the same structure, but the file names =are
> not static (but following a naming standard, such as
> location+date.txt, such as
> or_05102004
> wa_05122004
> and so on.
> > so each file will be broung in as a table such as or_05102004, and
> wa_05122004 table.
> > thank you.
> >
can someone give me some advice on how to bring in text files located on a
file server directory into a sql server database?
the text files will always have the same structure, but the file names are
not static (but following a naming standard, such as
location+date.txt, such as
or_05102004
wa_05122004
and so on.
so each file will be broung in as a table such as or_05102004, and
wa_05122004 table.
thank you.Will you be loading all of the text files into one table, or does each =type (or, wa, ...) have a different table that it should be loaded into? =
Perhaps you could use BCP or BULK INSERT to import the text files. You =can define a format file if you choose to use BCP. This format file =will define the layout of the file and it will determine how it gets =loaded into the destination table. You could create a stored procedure =that would take a filename as a param and use a bit of dynamic sql to =generate the appropriate BCP statement that uses the appropriate format =file.
Another method would be DTS. You could create a DTS package to insert =the data into SQL Server. This solution might be difficult to maintain =if the file names change often. Then again, you could create a routine =that imports from a standard file name. When you get a new file (on the =network share) you could copy it to the specific location and file name =that your DTS package knows about.
-- Keith
"=3D=3D Steve Pdx=3D=3D" <lins@.nospam.portptld.com> wrote in message =news:uCHOz%23sNEHA.1196@.TK2MSFTNGP11.phx.gbl...
> background: sql2k on nt5.
> > can someone give me some advice on how to bring in text files located =on a
> file server directory into a sql server database?
> the text files will always have the same structure, but the file names =are
> not static (but following a naming standard, such as
> location+date.txt, such as
> or_05102004
> wa_05122004
> and so on.
> > so each file will be broung in as a table such as or_05102004, and
> wa_05122004 table.
> > thank you.
> >
Help needed on Full text Search
Hello,
we got a requirement where i hvae to implement a full text search in SQL
Server 2000/2005. Can some one help me Where/How to start ? Any links for
the articles is also good.
Thanks in Advance
Srinivas
have a look at the links in indexserverfaq.com for sql fts.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Srinivas Kollipara" <skollipara@.stratasolutions.com> wrote in message
news:eweiaU9FGHA.516@.TK2MSFTNGP15.phx.gbl...
> Hello,
> we got a requirement where i hvae to implement a full text search in SQL
> Server 2000/2005. Can some one help me Where/How to start ? Any links for
> the articles is also good.
> Thanks in Advance
> Srinivas
>
we got a requirement where i hvae to implement a full text search in SQL
Server 2000/2005. Can some one help me Where/How to start ? Any links for
the articles is also good.
Thanks in Advance
Srinivas
have a look at the links in indexserverfaq.com for sql fts.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Srinivas Kollipara" <skollipara@.stratasolutions.com> wrote in message
news:eweiaU9FGHA.516@.TK2MSFTNGP15.phx.gbl...
> Hello,
> we got a requirement where i hvae to implement a full text search in SQL
> Server 2000/2005. Can some one help me Where/How to start ? Any links for
> the articles is also good.
> Thanks in Advance
> Srinivas
>
Help needed on Full text Search
Hello,
we got a requirement where i hvae to implement a full text search in SQL
Server 2000/2005. Can some one help me Where/How to start ? Any links for
the articles is also good.
Thanks in Advance
Srinivashave a look at the links in indexserverfaq.com for sql fts.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Srinivas Kollipara" <skollipara@.stratasolutions.com> wrote in message
news:eweiaU9FGHA.516@.TK2MSFTNGP15.phx.gbl...
> Hello,
> we got a requirement where i hvae to implement a full text search in SQL
> Server 2000/2005. Can some one help me Where/How to start ? Any links for
> the articles is also good.
> Thanks in Advance
> Srinivas
>
we got a requirement where i hvae to implement a full text search in SQL
Server 2000/2005. Can some one help me Where/How to start ? Any links for
the articles is also good.
Thanks in Advance
Srinivashave a look at the links in indexserverfaq.com for sql fts.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Srinivas Kollipara" <skollipara@.stratasolutions.com> wrote in message
news:eweiaU9FGHA.516@.TK2MSFTNGP15.phx.gbl...
> Hello,
> we got a requirement where i hvae to implement a full text search in SQL
> Server 2000/2005. Can some one help me Where/How to start ? Any links for
> the articles is also good.
> Thanks in Advance
> Srinivas
>
Help needed on Full text Search
Hello,
we got a requirement where i hvae to implement a full text search in SQL
Server 2000/2005. Can some one help me Where/How to start ? Any links for
the articles is also good.
Thanks in Advance
Srinivashave a look at the links in indexserverfaq.com for sql fts.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Srinivas Kollipara" <skollipara@.stratasolutions.com> wrote in message
news:eweiaU9FGHA.516@.TK2MSFTNGP15.phx.gbl...
> Hello,
> we got a requirement where i hvae to implement a full text search in SQL
> Server 2000/2005. Can some one help me Where/How to start ? Any links for
> the articles is also good.
> Thanks in Advance
> Srinivas
>
we got a requirement where i hvae to implement a full text search in SQL
Server 2000/2005. Can some one help me Where/How to start ? Any links for
the articles is also good.
Thanks in Advance
Srinivashave a look at the links in indexserverfaq.com for sql fts.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Srinivas Kollipara" <skollipara@.stratasolutions.com> wrote in message
news:eweiaU9FGHA.516@.TK2MSFTNGP15.phx.gbl...
> Hello,
> we got a requirement where i hvae to implement a full text search in SQL
> Server 2000/2005. Can some one help me Where/How to start ? Any links for
> the articles is also good.
> Thanks in Advance
> Srinivas
>
Friday, March 9, 2012
Help Needed For reporting service 2005(Rendering in PDF)
Hi experts
I am working on sql server reporting services 2005.
Now a days i m developing a text report. Which shows text for selected
parameters.
I have added more table headers in my layout. And i am using one row
for heading and just below row for description.
This description is comming from database so it is variable, somtimes
it is having ony 100 chars and some times it is
having more than 20000 chars. Problem starts here when the number of
charcters are less then report is looking good in PDF
But when it is more then the description row moves on next page. I
have tried this by selecting the table property "Fit table in one page
if possible"
I have once cheked this property and once unchecked this but result is
same. Report looks good in report viewer but not looks good in PDF
format.
MY another question is it possible that i can bind two rows in the
table that if second rows goes in the second page then
the row above also goes on next page. RIght now heading row appears on
first page in pdf and then second row starts on new page after leaving
all the available space on first page.
So please if any body have any idea about my problem, Please help me.
Any help will be gratefull.
Regards
DineshTry to use group.
"Dinesh" wrote:
> Hi experts
> I am working on sql server reporting services 2005.
> Now a days i m developing a text report. Which shows text for selected
> parameters.
> I have added more table headers in my layout. And i am using one row
> for heading and just below row for description.
> This description is comming from database so it is variable, somtimes
> it is having ony 100 chars and some times it is
> having more than 20000 chars. Problem starts here when the number of
> charcters are less then report is looking good in PDF
> But when it is more then the description row moves on next page. I
> have tried this by selecting the table property "Fit table in one page
> if possible"
> I have once cheked this property and once unchecked this but result is
> same. Report looks good in report viewer but not looks good in PDF
> format.
> MY another question is it possible that i can bind two rows in the
> table that if second rows goes in the second page then
> the row above also goes on next page. RIght now heading row appears on
> first page in pdf and then second row starts on new page after leaving
> all the available space on first page.
> So please if any body have any idea about my problem, Please help me.
> Any help will be gratefull.
> Regards
> Dinesh
>
I am working on sql server reporting services 2005.
Now a days i m developing a text report. Which shows text for selected
parameters.
I have added more table headers in my layout. And i am using one row
for heading and just below row for description.
This description is comming from database so it is variable, somtimes
it is having ony 100 chars and some times it is
having more than 20000 chars. Problem starts here when the number of
charcters are less then report is looking good in PDF
But when it is more then the description row moves on next page. I
have tried this by selecting the table property "Fit table in one page
if possible"
I have once cheked this property and once unchecked this but result is
same. Report looks good in report viewer but not looks good in PDF
format.
MY another question is it possible that i can bind two rows in the
table that if second rows goes in the second page then
the row above also goes on next page. RIght now heading row appears on
first page in pdf and then second row starts on new page after leaving
all the available space on first page.
So please if any body have any idea about my problem, Please help me.
Any help will be gratefull.
Regards
DineshTry to use group.
"Dinesh" wrote:
> Hi experts
> I am working on sql server reporting services 2005.
> Now a days i m developing a text report. Which shows text for selected
> parameters.
> I have added more table headers in my layout. And i am using one row
> for heading and just below row for description.
> This description is comming from database so it is variable, somtimes
> it is having ony 100 chars and some times it is
> having more than 20000 chars. Problem starts here when the number of
> charcters are less then report is looking good in PDF
> But when it is more then the description row moves on next page. I
> have tried this by selecting the table property "Fit table in one page
> if possible"
> I have once cheked this property and once unchecked this but result is
> same. Report looks good in report viewer but not looks good in PDF
> format.
> MY another question is it possible that i can bind two rows in the
> table that if second rows goes in the second page then
> the row above also goes on next page. RIght now heading row appears on
> first page in pdf and then second row starts on new page after leaving
> all the available space on first page.
> So please if any body have any idea about my problem, Please help me.
> Any help will be gratefull.
> Regards
> Dinesh
>
Monday, February 27, 2012
help me! read text file in sql
HELLO,
please help me, how to read txt file and then insert it to sql table.
i have file like this name.txe
<...
012301231923123902132003
23423i4u23490342342342343
...>
I have 4 column and want to fractionise this text '012301231923123902132003'
and put in to table.
Best regards
RobertHi
If you want to use DTS see the following tutorial
http://www.sqldts.com/default.aspx?6,107,276,7,1
John
"Robert K" <rkloma@.hotmail.com> wrote in message
news:bhap7a$c3n$1@.news.onet.pl...
> HELLO,
> please help me, how to read txt file and then insert it to sql table.
> i have file like this name.txe
> <...
> 012301231923123902132003
> 23423i4u23490342342342343
> ...>
> I have 4 column and want to fractionise this text
'012301231923123902132003'
> and put in to table.
>
> Best regards
> Robert|||See response in microsoft.public.sqlserver.programming
--
- Anith
( Please reply to newsgroups only )|||Hi,
You can use the xp_cmdshell to read the contents of a text file.
You can look at the sample at
http://www.kodyaz.com/articles/read...p_cmdshell.aspx
Eralper
http://www.kodyaz.com
Help me write a Search function please
Hi all,
I'm very new to ASP.NET stuffs, I'm trying to write a Search function for my website... I have two text boxes, one if called "SongTitle" and the other is "Artist"... Now I need to populate the GridView to display the result, based on the input of the textbox... So if only the "SongTitle" have input, it will search for the Song Titles on the database... if the Artist is searched, then it will return the artist... If both text boxes have value in them, then it need to check for both fields in the database and return the correct item...
For the "Artist", I have 2 columns in the Database (originalArtist and performer), so for the Artist select statement, it need to check both columns on the table, if any of them match then it will return the item.
Any help would be greatly appreciated,
Thank you all,
Kenny.
Try something like this:
SELECTFROM YourTableWHERE (@.SongTitleISNULL OR SongTitle = @.SongTitle)AND (@.ArtistISNULL OR (originalArtist = @.ArtistOR Performer = @.Artist ))|||
ndinakar,
Thank you very much, here is what I put for my SqlDataSource, but it doesn't appear to work... Nothing returned when I try to search, using just the artist, the song, or both for the input:
<asp:SqlDataSource ID="DSResults" runat="server" ConnectionString="<%$ ConnectionStrings:notesnhacConnectionString1 %>"
SelectCommand="SELECT DISTINCT [MUSIC_TITLE], [MUSIC_ORIGINAL_SINGER], [MUSIC_PERFORMER] FROM [t_music] WHERE (@.MUSIC_TITLE IS NULL OR [MUSIC_TITLE2] LIKE '%' + @.MUSIC_TITLE + '%') AND (@.MUSIC_ARTIST IS NULL OR [MUSIC_ORIGINAL_SINGER] LIKE '%' + @.MUSIC_ARTIST + '%' OR [MUSIC_PERFORMER] LIKE '%' + @.MUSIC_ARTIST + '%')">
<SelectParameters>
<asp:QueryStringParameter Name="MUSIC_TITLE" QueryStringField="title" Type="String" />
<asp:QueryStringParameter Name="MUSIC_ARTIST" QueryStringField="artist" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
If you run thre query in your query analyzer with some values for the parameters does it work as expected? If not, post some sample data from your table and the query you used so we can better understand why its not working.
|||Here is what I put on the Query window of SQL Manager Studio Express:
DECLARE @.MUSIC_TITLE NVARCHAR(100)
DECLARE @.MUSIC_ARTIST NVARCHAR(100)
SELECT DISTINCT [MUSIC_TITLE], [MUSIC_ORIGINAL_SINGER], [MUSIC_PERFORMER]
FROM [t_music]
WHERE (@.MUSIC_TITLE IS NULL OR [MUSIC_TITLE] LIKE '%' + @.MUSIC_TITLE + '%') AND (@.MUSIC_ARTIST IS NULL OR [MUSIC_ORIGINAL_SINGER] LIKE '%' + @.MUSIC_ARTIST + '%' OR [MUSIC_PERFORMER] LIKE '%' + @.MUSIC_ARTIST + '%')
SET @.MUSIC_TITLE = 'Everytime'
SET @.MUSIC_ARTIST = 'Cascada'
I've tried to use just @.MUSIC_TITLE, or just @.MUSIC_ARTIST, and both... each time it return ALL the records in the table... But if I execute the same select statement in VS 2005, it returns nothing... In the table, there is a song called "Everytime We Touch" performed by Cascada.
Are you setting the values after running the SELECT? post some sample data from your table so I can test it on my machine..
|||sorry. you need to use OR instead of AND in your WHERE clause.
|||As you can see I have the SET @.MUSIC_TITLE = 'Everytime' in the previous post... Here are some sample data:
MUSIC_TITLE MUSIC_ORIGINAL_SINGER MUSIC_PERFORMER
Everytime We Touch Cascada Cascada
Dancing Queen ABBA Purity
Heaven Bryan Adam
Hotel California Eagles Eagles
Thank you very much for your help,
Kenny.
|||Changed the "AND" to "OR" have helped, but I have some problem:
1. If I don't enter anything for the "Artist" or in the "Title" box (meaning only of the box have input), no records returned even if I type part of the name of the song/artist, or even the full name of the song/artist.
2. For example if I have two songs that have some similiar words, i.e. "Hotel", in the Title box I typed "Hotel" and in the Artist box, I typed "Eagles", which should return 1 record only that contain both Hotel & Eagles in the record... But instead it returns all the songs with "Hotel" in it.
Thanks again,
Kenny.
|||I think we had it right the first time itself. AND should work.
|||Dinakar,
You are right, the "AND" should work... The problem is that it only works if both the Title and Artist text box have values in them... Leaving one or the other blank does not return any results even if they should be... Any help?
Thank you,
Kenny.
HEre's a sample I set up. I was able to get both records when I used "hotel" for music_title and left the second field blank.
Declare @.ttable (col1int identity, MUSIC_TITLEvarchar(50), MUSIC_ORIGINAL_SINGERvarchar(50), MUSIC_PERFORMERvarchar(50))insert into @.tvalues ('Everytime We Touch','Cascada','Cascada')insert into @.tvalues ('Dancing Queen','ABBA','Purity')insert into @.tvalues ('hotel','Bryan Adam',null)insert into @.tvalues ('Hotel California','Eagles','Cascada')DECLARE @.MUSIC_TITLENVARCHAR(100)DECLARE @.MUSIC_ARTISTNVARCHAR(100)SET @.MUSIC_TITLE ='hotel'SET @.MUSIC_ARTIST =nullSELECT DISTINCT [MUSIC_TITLE], [MUSIC_ORIGINAL_SINGER], [MUSIC_PERFORMER]FROM @.t--where ([MUSIC_ORIGINAL_SINGER] LIKE '%' + @.MUSIC_ARTIST + '%' OR [MUSIC_PERFORMER] LIKE '%' + @.MUSIC_ARTIST + '%')WHERE (@.MUSIC_TITLEISNULL OR [MUSIC_TITLE]LIKE'%' + @.MUSIC_TITLE +'%')AND (@.MUSIC_ARTISTISNULL OR ([MUSIC_ORIGINAL_SINGER]LIKE'%' + @.MUSIC_ARTIST +'%'OR [MUSIC_PERFORMER]LIKE'%' + @.MUSIC_ARTIST +'%'))|||I tried the code above in SQL Manager Studio and they seems to work as expected... but somehow it doesn't work with my SqlDataSource! I don't know what else I have to do...
Thank you very, very much for your help Dinakar.
Kenny.
I think that it doesn't work with SqlDataSource because the empty string (when nothing was entered in either one of the textbox) doesn't mean null in ADO.NET... Can anyone help me convert this to a code-behind, or help me convert that empty string to null? I would love to put this in code-behind file but like I said in my first post, I'm very new to ASP.NET.
Thanks,
Kenny.
Unfortunately I dont do any .NET code so I cant help you there. Perhaps you can create a new post and someone might help you there. Posts with 0 replies have a better chance of being "looked at" than the ones with 12 replies.
Friday, February 24, 2012
Help me please with length of text filed
i have to make one application with msde sql server
in my app i want to save in one field a big data(more than 2 milions caracters)
from documentations of sql 2000 server i understanded that a field text can store aboute 2^31-1 caracters. but when i build the insert query with this long data the msde tells me that i try to insert too long data value(permiesed length is 128 caracters).
please tell me where i'm wrong
i have to make some settings to can insert more than 128 caracters?
thanks
--
Message posted via http://www.sqlmonster.comHow are you trying to do the insert right now? Can you post the code you're
using?
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Simirad Iulian via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:e742f5ec453347e8866881cf5f73cd79@.SQLMonster.com...
> i have to make one application with msde sql server
> in my app i want to save in one field a big data(more than 2 milions
caracters)
> from documentations of sql 2000 server i understanded that a field text
can store aboute 2^31-1 caracters. but when i build the insert query with
this long data the msde tells me that i try to insert too long data
value(permiesed length is 128 caracters).
> please tell me where i'm wrong
> i have to make some settings to can insert more than 128 caracters?
> thanks
> --
> Message posted via http://www.sqlmonster.com|||insert into table(Column) VALUES('more than 128 caracters')
--
Message posted via http://www.sqlmonster.com|||"Simirad Iulian via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:8b0f081259e6493f911ac88839f2c2f5@.SQLMonster.com...
> insert into table(Column) VALUES('more than 128 caracters')
:)
Can you post the exact error you're getting?
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--|||By default Query Analyzer only permits you to deal with 128 charactors.
You can change it by going into Tools, Options and results tab up to a
value of 8192. Thats all QA can handle.
If you need to import a huge string of data, you might as well use DTS
to import that text thru a text file. I am not sure as I have never
tried... Just an idea...!!|||To Adam Machanic:
The error is:
The identifier that starts with 'my caracters' is too long. Maximum length is 128.
To QueryBuilder:
i didn't find what do you say.
--
Message posted via http://www.sqlmonster.com|||I did some research on that error, and the only guess I have is that you may
be using double-quotes instead of single-quotes around your value -- switch
to single quotes if that's the case, and the problem should go away...
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Simirad Iulian via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:f079327cced04fb9a3d3a8ff06af97a8@.SQLMonster.com...
> To Adam Machanic:
> The error is:
> The identifier that starts with 'my caracters' is too long. Maximum
length is 128.
> To QueryBuilder:
> i didn't find what do you say.
> --
> Message posted via http://www.sqlmonster.com|||To Simirad:
Query Analyzer only supports 128 chars by default.. You can increase by
going into options and make it use upto 8192 charactors..!
If you insist on wanting to add more charactors in one shot.. the easy
way is to store the text in one text file.. Open DTS package and create
connection to your DB and another connection to your text file. Then do
a data transfermation to your table column...! If you have a primary
key in the table, put that key value in the text file as a column and
pump the data into the table..! You can also do this thru ActiveX in
DTS..! I tested it and it worked..!
Hope this helped..!|||Did you bother to read my reply or run the example I posted? The limit in
QA has nothing to do with INSERTs.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"QueryBuilder" <pg.242w@.gmail.com> wrote in message
news:1106253826.201162.129390@.f14g2000cwb.googlegroups.com...
> To Simirad:
> Query Analyzer only supports 128 chars by default.. You can increase by
> going into options and make it use upto 8192 charactors..!
> If you insist on wanting to add more charactors in one shot.. the easy
> way is to store the text in one text file.. Open DTS package and create
> connection to your DB and another connection to your text file. Then do
> a data transfermation to your table column...! If you have a primary
> key in the table, put that key value in the text file as a column and
> pump the data into the table..! You can also do this thru ActiveX in
> DTS..! I tested it and it worked..!
> Hope this helped..!
>|||i use double-quotes but i obtain same error.
i thinck there is another problems
--
Message posted via http://www.sqlmonster.com|||QueryBuilder wrote:
</b>Query Analyzer only supports 128 chars by default.. You can increase by
going into options and make it use upto 8192 charactors..!</b>
I use Microsoft SQL Web Data Administrator and i didn't find options.
please explain how i can modify this limit
thx
--
Message posted via http://www.sqlmonster.com|||You need to use SINGLE-quotes.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Simirad Iulian via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:9e29790cfd5b43f88e872e073c5bdf59@.SQLMonster.com...
> i use double-quotes but i obtain same error.
> i thinck there is another problems
> --
> Message posted via http://www.sqlmonster.com
in my app i want to save in one field a big data(more than 2 milions caracters)
from documentations of sql 2000 server i understanded that a field text can store aboute 2^31-1 caracters. but when i build the insert query with this long data the msde tells me that i try to insert too long data value(permiesed length is 128 caracters).
please tell me where i'm wrong
i have to make some settings to can insert more than 128 caracters?
thanks
--
Message posted via http://www.sqlmonster.comHow are you trying to do the insert right now? Can you post the code you're
using?
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Simirad Iulian via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:e742f5ec453347e8866881cf5f73cd79@.SQLMonster.com...
> i have to make one application with msde sql server
> in my app i want to save in one field a big data(more than 2 milions
caracters)
> from documentations of sql 2000 server i understanded that a field text
can store aboute 2^31-1 caracters. but when i build the insert query with
this long data the msde tells me that i try to insert too long data
value(permiesed length is 128 caracters).
> please tell me where i'm wrong
> i have to make some settings to can insert more than 128 caracters?
> thanks
> --
> Message posted via http://www.sqlmonster.com|||insert into table(Column) VALUES('more than 128 caracters')
--
Message posted via http://www.sqlmonster.com|||"Simirad Iulian via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:8b0f081259e6493f911ac88839f2c2f5@.SQLMonster.com...
> insert into table(Column) VALUES('more than 128 caracters')
:)
Can you post the exact error you're getting?
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--|||By default Query Analyzer only permits you to deal with 128 charactors.
You can change it by going into Tools, Options and results tab up to a
value of 8192. Thats all QA can handle.
If you need to import a huge string of data, you might as well use DTS
to import that text thru a text file. I am not sure as I have never
tried... Just an idea...!!|||To Adam Machanic:
The error is:
The identifier that starts with 'my caracters' is too long. Maximum length is 128.
To QueryBuilder:
i didn't find what do you say.
--
Message posted via http://www.sqlmonster.com|||I did some research on that error, and the only guess I have is that you may
be using double-quotes instead of single-quotes around your value -- switch
to single quotes if that's the case, and the problem should go away...
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Simirad Iulian via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:f079327cced04fb9a3d3a8ff06af97a8@.SQLMonster.com...
> To Adam Machanic:
> The error is:
> The identifier that starts with 'my caracters' is too long. Maximum
length is 128.
> To QueryBuilder:
> i didn't find what do you say.
> --
> Message posted via http://www.sqlmonster.com|||To Simirad:
Query Analyzer only supports 128 chars by default.. You can increase by
going into options and make it use upto 8192 charactors..!
If you insist on wanting to add more charactors in one shot.. the easy
way is to store the text in one text file.. Open DTS package and create
connection to your DB and another connection to your text file. Then do
a data transfermation to your table column...! If you have a primary
key in the table, put that key value in the text file as a column and
pump the data into the table..! You can also do this thru ActiveX in
DTS..! I tested it and it worked..!
Hope this helped..!|||Did you bother to read my reply or run the example I posted? The limit in
QA has nothing to do with INSERTs.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"QueryBuilder" <pg.242w@.gmail.com> wrote in message
news:1106253826.201162.129390@.f14g2000cwb.googlegroups.com...
> To Simirad:
> Query Analyzer only supports 128 chars by default.. You can increase by
> going into options and make it use upto 8192 charactors..!
> If you insist on wanting to add more charactors in one shot.. the easy
> way is to store the text in one text file.. Open DTS package and create
> connection to your DB and another connection to your text file. Then do
> a data transfermation to your table column...! If you have a primary
> key in the table, put that key value in the text file as a column and
> pump the data into the table..! You can also do this thru ActiveX in
> DTS..! I tested it and it worked..!
> Hope this helped..!
>|||i use double-quotes but i obtain same error.
i thinck there is another problems
--
Message posted via http://www.sqlmonster.com|||QueryBuilder wrote:
</b>Query Analyzer only supports 128 chars by default.. You can increase by
going into options and make it use upto 8192 charactors..!</b>
I use Microsoft SQL Web Data Administrator and i didn't find options.
please explain how i can modify this limit
thx
--
Message posted via http://www.sqlmonster.com|||You need to use SINGLE-quotes.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Simirad Iulian via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:9e29790cfd5b43f88e872e073c5bdf59@.SQLMonster.com...
> i use double-quotes but i obtain same error.
> i thinck there is another problems
> --
> Message posted via http://www.sqlmonster.com
Help me please with length of text filed
i have to make one application with msde sql server
in my app i want to save in one field a big data(more than 2 milions caracte
rs)
from documentations of sql 2000 server i understanded that a field text can
store aboute 2^31-1 caracters. but when i build the insert query with this l
ong data the msde tells me that i try to insert too long data value(permiese
d length is 128 caracters).
please tell me where i'm wrong
i have to make some settings to can insert more than 128 caracters?
thanks
Message posted via http://www.droptable.comHow are you trying to do the insert right now? Can you post the code you're
using?
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Simirad Iulian via droptable.com" <forum@.droptable.com> wrote in message
news:e742f5ec453347e8866881cf5f73cd79@.SQ
droptable.com...
> i have to make one application with msde sql server
> in my app i want to save in one field a big data(more than 2 milions
caracters)
> from documentations of sql 2000 server i understanded that a field text
can store aboute 2^31-1 caracters. but when i build the insert query with
this long data the msde tells me that i try to insert too long data
value(permiesed length is 128 caracters).
> please tell me where i'm wrong
> i have to make some settings to can insert more than 128 caracters?
> thanks
> --
> Message posted via http://www.droptable.com|||insert into table(Column) VALUES('more than 128 caracters')
Message posted via http://www.droptable.com|||"Simirad Iulian via droptable.com" <forum@.droptable.com> wrote in message
news:8b0f081259e6493f911ac88839f2c2f5@.SQ
droptable.com...
> insert into table(Column) VALUES('more than 128 caracters')
Can you post the exact error you're getting?
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--|||By default Query Analyzer only permits you to deal with 128 charactors.
You can change it by going into Tools, Options and results tab up to a
value of 8192. Thats all QA can handle.
If you need to import a huge string of data, you might as well use DTS
to import that text thru a text file. I am not sure as I have never
tried... Just an idea...!!|||You can _insert_ more than 8192 characters in QA. You just can't select
more than that (the results will be truncated, though -- no error message).
Try:
create table #a (bigcol text)
insert #a
values
('00000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
0000000000')
select datalength(bigcol) from #a
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"QueryBuilder" <pg.242w@.gmail.com> wrote in message
news:1106159402.371899.277330@.z14g2000cwz.googlegroups.com...
> By default Query Analyzer only permits you to deal with 128 charactors.
> You can change it by going into Tools, Options and results tab up to a
> value of 8192. Thats all QA can handle.
> If you need to import a huge string of data, you might as well use DTS
> to import that text thru a text file. I am not sure as I have never
> tried... Just an idea...!!
>|||To Adam Machanic:
The error is:
The identifier that starts with 'my caracters' is too long. Maximum length
is 128.
To QueryBuilder:
i didn't find what do you say.
Message posted via http://www.droptable.com|||I did some research on that error, and the only guess I have is that you may
be using double-quotes instead of single-quotes around your value -- switch
to single quotes if that's the case, and the problem should go away...
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Simirad Iulian via droptable.com" <forum@.droptable.com> wrote in message
news:f079327cced04fb9a3d3a8ff06af97a8@.SQ
droptable.com...
> To Adam Machanic:
> The error is:
> The identifier that starts with 'my caracters' is too long. Maximum
length is 128.
> To QueryBuilder:
> i didn't find what do you say.
> --
> Message posted via http://www.droptable.com|||To Simirad:
Query Analyzer only supports 128 chars by default.. You can increase by
going into options and make it use upto 8192 charactors..!
If you insist on wanting to add more charactors in one shot.. the easy
way is to store the text in one text file.. Open DTS package and create
connection to your DB and another connection to your text file. Then do
a data transfermation to your table column...! If you have a primary
key in the table, put that key value in the text file as a column and
pump the data into the table..! You can also do this thru ActiveX in
DTS..! I tested it and it worked..!
Hope this helped..!|||Did you bother to read my reply or run the example I posted? The limit in
QA has nothing to do with INSERTs.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"QueryBuilder" <pg.242w@.gmail.com> wrote in message
news:1106253826.201162.129390@.f14g2000cwb.googlegroups.com...
> To Simirad:
> Query Analyzer only supports 128 chars by default.. You can increase by
> going into options and make it use upto 8192 charactors..!
> If you insist on wanting to add more charactors in one shot.. the easy
> way is to store the text in one text file.. Open DTS package and create
> connection to your DB and another connection to your text file. Then do
> a data transfermation to your table column...! If you have a primary
> key in the table, put that key value in the text file as a column and
> pump the data into the table..! You can also do this thru ActiveX in
> DTS..! I tested it and it worked..!
> Hope this helped..!
>
in my app i want to save in one field a big data(more than 2 milions caracte
rs)
from documentations of sql 2000 server i understanded that a field text can
store aboute 2^31-1 caracters. but when i build the insert query with this l
ong data the msde tells me that i try to insert too long data value(permiese
d length is 128 caracters).
please tell me where i'm wrong
i have to make some settings to can insert more than 128 caracters?
thanks
Message posted via http://www.droptable.comHow are you trying to do the insert right now? Can you post the code you're
using?
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Simirad Iulian via droptable.com" <forum@.droptable.com> wrote in message
news:e742f5ec453347e8866881cf5f73cd79@.SQ
droptable.com...
> i have to make one application with msde sql server
> in my app i want to save in one field a big data(more than 2 milions
caracters)
> from documentations of sql 2000 server i understanded that a field text
can store aboute 2^31-1 caracters. but when i build the insert query with
this long data the msde tells me that i try to insert too long data
value(permiesed length is 128 caracters).
> please tell me where i'm wrong
> i have to make some settings to can insert more than 128 caracters?
> thanks
> --
> Message posted via http://www.droptable.com|||insert into table(Column) VALUES('more than 128 caracters')
Message posted via http://www.droptable.com|||"Simirad Iulian via droptable.com" <forum@.droptable.com> wrote in message
news:8b0f081259e6493f911ac88839f2c2f5@.SQ
droptable.com...
> insert into table(Column) VALUES('more than 128 caracters')
Can you post the exact error you're getting?
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--|||By default Query Analyzer only permits you to deal with 128 charactors.
You can change it by going into Tools, Options and results tab up to a
value of 8192. Thats all QA can handle.
If you need to import a huge string of data, you might as well use DTS
to import that text thru a text file. I am not sure as I have never
tried... Just an idea...!!|||You can _insert_ more than 8192 characters in QA. You just can't select
more than that (the results will be truncated, though -- no error message).
Try:
create table #a (bigcol text)
insert #a
values
('00000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
0000000000')
select datalength(bigcol) from #a
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"QueryBuilder" <pg.242w@.gmail.com> wrote in message
news:1106159402.371899.277330@.z14g2000cwz.googlegroups.com...
> By default Query Analyzer only permits you to deal with 128 charactors.
> You can change it by going into Tools, Options and results tab up to a
> value of 8192. Thats all QA can handle.
> If you need to import a huge string of data, you might as well use DTS
> to import that text thru a text file. I am not sure as I have never
> tried... Just an idea...!!
>|||To Adam Machanic:
The error is:
The identifier that starts with 'my caracters' is too long. Maximum length
is 128.
To QueryBuilder:
i didn't find what do you say.
Message posted via http://www.droptable.com|||I did some research on that error, and the only guess I have is that you may
be using double-quotes instead of single-quotes around your value -- switch
to single quotes if that's the case, and the problem should go away...
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Simirad Iulian via droptable.com" <forum@.droptable.com> wrote in message
news:f079327cced04fb9a3d3a8ff06af97a8@.SQ
droptable.com...
> To Adam Machanic:
> The error is:
> The identifier that starts with 'my caracters' is too long. Maximum
length is 128.
> To QueryBuilder:
> i didn't find what do you say.
> --
> Message posted via http://www.droptable.com|||To Simirad:
Query Analyzer only supports 128 chars by default.. You can increase by
going into options and make it use upto 8192 charactors..!
If you insist on wanting to add more charactors in one shot.. the easy
way is to store the text in one text file.. Open DTS package and create
connection to your DB and another connection to your text file. Then do
a data transfermation to your table column...! If you have a primary
key in the table, put that key value in the text file as a column and
pump the data into the table..! You can also do this thru ActiveX in
DTS..! I tested it and it worked..!
Hope this helped..!|||Did you bother to read my reply or run the example I posted? The limit in
QA has nothing to do with INSERTs.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"QueryBuilder" <pg.242w@.gmail.com> wrote in message
news:1106253826.201162.129390@.f14g2000cwb.googlegroups.com...
> To Simirad:
> Query Analyzer only supports 128 chars by default.. You can increase by
> going into options and make it use upto 8192 charactors..!
> If you insist on wanting to add more charactors in one shot.. the easy
> way is to store the text in one text file.. Open DTS package and create
> connection to your DB and another connection to your text file. Then do
> a data transfermation to your table column...! If you have a primary
> key in the table, put that key value in the text file as a column and
> pump the data into the table..! You can also do this thru ActiveX in
> DTS..! I tested it and it worked..!
> Hope this helped..!
>
Sunday, February 19, 2012
Help me please with length of text filed
i have to make one application with msde sql server
in my app i want to save in one field a big data(more than 2 milions caracters)
from documentations of sql 2000 server i understanded that a field text can store aboute 2^31-1 caracters. but when i build the insert query with this long data the msde tells me that i try to insert too long data value(permiesed length is 128 caracters).
please tell me where i'm wrong
i have to make some settings to can insert more than 128 caracters?
thanks
Message posted via http://www.sqlmonster.com
How are you trying to do the insert right now? Can you post the code you're
using?
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"Simirad Iulian via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:e742f5ec453347e8866881cf5f73cd79@.SQLMonster.c om...
> i have to make one application with msde sql server
> in my app i want to save in one field a big data(more than 2 milions
caracters)
> from documentations of sql 2000 server i understanded that a field text
can store aboute 2^31-1 caracters. but when i build the insert query with
this long data the msde tells me that i try to insert too long data
value(permiesed length is 128 caracters).
> please tell me where i'm wrong
> i have to make some settings to can insert more than 128 caracters?
> thanks
> --
> Message posted via http://www.sqlmonster.com
|||insert into table(Column) VALUES('more than 128 caracters')
Message posted via http://www.sqlmonster.com
|||"Simirad Iulian via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:8b0f081259e6493f911ac88839f2c2f5@.SQLMonster.c om...
> insert into table(Column) VALUES('more than 128 caracters')
Can you post the exact error you're getting?
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
|||By default Query Analyzer only permits you to deal with 128 charactors.
You can change it by going into Tools, Options and results tab up to a
value of 8192. Thats all QA can handle.
If you need to import a huge string of data, you might as well use DTS
to import that text thru a text file. I am not sure as I have never
tried... Just an idea...!!
|||You can _insert_ more than 8192 characters in QA. You just can't select
more than that (the results will be truncated, though -- no error message).
Try:
create table #a (bigcol text)
insert #a
values
('000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 ')
select datalength(bigcol) from #a
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"QueryBuilder" <pg.242w@.gmail.com> wrote in message
news:1106159402.371899.277330@.z14g2000cwz.googlegr oups.com...
> By default Query Analyzer only permits you to deal with 128 charactors.
> You can change it by going into Tools, Options and results tab up to a
> value of 8192. Thats all QA can handle.
> If you need to import a huge string of data, you might as well use DTS
> to import that text thru a text file. I am not sure as I have never
> tried... Just an idea...!!
>
|||To Adam Machanic:
The error is:
The identifier that starts with 'my caracters' is too long. Maximum length is 128.
To QueryBuilder:
i didn't find what do you say.
Message posted via http://www.sqlmonster.com
|||I did some research on that error, and the only guess I have is that you may
be using double-quotes instead of single-quotes around your value -- switch
to single quotes if that's the case, and the problem should go away...
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"Simirad Iulian via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:f079327cced04fb9a3d3a8ff06af97a8@.SQLMonster.c om...
> To Adam Machanic:
> The error is:
> The identifier that starts with 'my caracters' is too long. Maximum
length is 128.
> To QueryBuilder:
> i didn't find what do you say.
> --
> Message posted via http://www.sqlmonster.com
|||To Simirad:
Query Analyzer only supports 128 chars by default.. You can increase by
going into options and make it use upto 8192 charactors..!
If you insist on wanting to add more charactors in one shot.. the easy
way is to store the text in one text file.. Open DTS package and create
connection to your DB and another connection to your text file. Then do
a data transfermation to your table column...! If you have a primary
key in the table, put that key value in the text file as a column and
pump the data into the table..! You can also do this thru ActiveX in
DTS..! I tested it and it worked..!
Hope this helped..!
|||Did you bother to read my reply or run the example I posted? The limit in
QA has nothing to do with INSERTs.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"QueryBuilder" <pg.242w@.gmail.com> wrote in message
news:1106253826.201162.129390@.f14g2000cwb.googlegr oups.com...
> To Simirad:
> Query Analyzer only supports 128 chars by default.. You can increase by
> going into options and make it use upto 8192 charactors..!
> If you insist on wanting to add more charactors in one shot.. the easy
> way is to store the text in one text file.. Open DTS package and create
> connection to your DB and another connection to your text file. Then do
> a data transfermation to your table column...! If you have a primary
> key in the table, put that key value in the text file as a column and
> pump the data into the table..! You can also do this thru ActiveX in
> DTS..! I tested it and it worked..!
> Hope this helped..!
>
in my app i want to save in one field a big data(more than 2 milions caracters)
from documentations of sql 2000 server i understanded that a field text can store aboute 2^31-1 caracters. but when i build the insert query with this long data the msde tells me that i try to insert too long data value(permiesed length is 128 caracters).
please tell me where i'm wrong
i have to make some settings to can insert more than 128 caracters?
thanks
Message posted via http://www.sqlmonster.com
How are you trying to do the insert right now? Can you post the code you're
using?
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"Simirad Iulian via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:e742f5ec453347e8866881cf5f73cd79@.SQLMonster.c om...
> i have to make one application with msde sql server
> in my app i want to save in one field a big data(more than 2 milions
caracters)
> from documentations of sql 2000 server i understanded that a field text
can store aboute 2^31-1 caracters. but when i build the insert query with
this long data the msde tells me that i try to insert too long data
value(permiesed length is 128 caracters).
> please tell me where i'm wrong
> i have to make some settings to can insert more than 128 caracters?
> thanks
> --
> Message posted via http://www.sqlmonster.com
|||insert into table(Column) VALUES('more than 128 caracters')
Message posted via http://www.sqlmonster.com
|||"Simirad Iulian via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:8b0f081259e6493f911ac88839f2c2f5@.SQLMonster.c om...
> insert into table(Column) VALUES('more than 128 caracters')
Can you post the exact error you're getting?
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
|||By default Query Analyzer only permits you to deal with 128 charactors.
You can change it by going into Tools, Options and results tab up to a
value of 8192. Thats all QA can handle.
If you need to import a huge string of data, you might as well use DTS
to import that text thru a text file. I am not sure as I have never
tried... Just an idea...!!
|||You can _insert_ more than 8192 characters in QA. You just can't select
more than that (the results will be truncated, though -- no error message).
Try:
create table #a (bigcol text)
insert #a
values
('000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 ')
select datalength(bigcol) from #a
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"QueryBuilder" <pg.242w@.gmail.com> wrote in message
news:1106159402.371899.277330@.z14g2000cwz.googlegr oups.com...
> By default Query Analyzer only permits you to deal with 128 charactors.
> You can change it by going into Tools, Options and results tab up to a
> value of 8192. Thats all QA can handle.
> If you need to import a huge string of data, you might as well use DTS
> to import that text thru a text file. I am not sure as I have never
> tried... Just an idea...!!
>
|||To Adam Machanic:
The error is:
The identifier that starts with 'my caracters' is too long. Maximum length is 128.
To QueryBuilder:
i didn't find what do you say.
Message posted via http://www.sqlmonster.com
|||I did some research on that error, and the only guess I have is that you may
be using double-quotes instead of single-quotes around your value -- switch
to single quotes if that's the case, and the problem should go away...
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"Simirad Iulian via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:f079327cced04fb9a3d3a8ff06af97a8@.SQLMonster.c om...
> To Adam Machanic:
> The error is:
> The identifier that starts with 'my caracters' is too long. Maximum
length is 128.
> To QueryBuilder:
> i didn't find what do you say.
> --
> Message posted via http://www.sqlmonster.com
|||To Simirad:
Query Analyzer only supports 128 chars by default.. You can increase by
going into options and make it use upto 8192 charactors..!
If you insist on wanting to add more charactors in one shot.. the easy
way is to store the text in one text file.. Open DTS package and create
connection to your DB and another connection to your text file. Then do
a data transfermation to your table column...! If you have a primary
key in the table, put that key value in the text file as a column and
pump the data into the table..! You can also do this thru ActiveX in
DTS..! I tested it and it worked..!
Hope this helped..!
|||Did you bother to read my reply or run the example I posted? The limit in
QA has nothing to do with INSERTs.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"QueryBuilder" <pg.242w@.gmail.com> wrote in message
news:1106253826.201162.129390@.f14g2000cwb.googlegr oups.com...
> To Simirad:
> Query Analyzer only supports 128 chars by default.. You can increase by
> going into options and make it use upto 8192 charactors..!
> If you insist on wanting to add more charactors in one shot.. the easy
> way is to store the text in one text file.. Open DTS package and create
> connection to your DB and another connection to your text file. Then do
> a data transfermation to your table column...! If you have a primary
> key in the table, put that key value in the text file as a column and
> pump the data into the table..! You can also do this thru ActiveX in
> DTS..! I tested it and it worked..!
> Hope this helped..!
>
Subscribe to:
Posts (Atom)