Help on global variable for insert statement

I am new to DTS, but really enjoy it and was wondering if someone could help me with the following small vb app.

I am using the following DTS insert statement to insert records into my table. I have multiple textboxes that needs to be filled and then inserted, none of them exept Nulls. How can I modify my code to insert those textboxes as well as run through the boxes and then check if they have nulls and NOT insert the ones that has nulls?

My form has 9 textboxes. Textbox1, 2, 3 Needs to insert values into the first column. Textbox4, 5, 6 into the second and then Texrbox7, 8, 9 into the last column.

My question is how do I format the following line of code to do what I need?

oCustomTask1.SQLStatement = oCustomTask1.SQLStatement & "Values ('1rowst', '2rowst', '3rowst')"

I think it is something like this, but I am Really not sure and some help would be greatly appretiated:

oCustomTask1.SQLStatement = oCustomTask1.SQLStatement & "Values ('Textbox1', 'Textbox4', 'Textbox7')"

I am really not sure.

Here is all the code:

Public Sub Task_Sub1(ByVal goPackage As Object)

Dim oTask As DTS.Task
'Dim oLookup As DTS.Lookup

Dim oCustomTask1 As DTS.ExecuteSQLTask2
oTask = CType(goPackage, DTS.Package).Tasks.New("DTSExecuteSQLTask")
oTask.Name = "DTSTask_DTSExecuteSQLTask_1"
oCustomTask1 = oTask.CustomTask

oCustomTask1.Name = "DTSTask_DTSExecuteSQLTask_1"
oCustomTask1.Description = "Execute SQL Task: undefined"
oCustomTask1.SQLStatement = "Insert into TestTable (Test1, Test2, Test3) " & vbCrLf
oCustomTask1.SQLStatement = oCustomTask1.SQLStatement & "Values ('1rowst', '2rowst', '3rowst')"
oCustomTask1.ConnectionID = 1
oCustomTask1.CommandTimeout = 0
oCustomTask1.OutputAsRecordset = False

goPackage.Tasks.Add(oTask)
oCustomTask1 = Nothing
oTask = Nothing

End Sub

This sentence is confusing: "I have multiple textboxes that needs to be filled and then inserted, none of them exept Nulls."

Do you mean that the table fields do not accept NULL values?

If I recall correctly, a textbox cannot contain a NULL value. At the minimum, it contains an 'empty string'.

In your code sniplet, you are inserting the value '1rowst' in the field [Test1], etc. There is no ambiguity about NULL values.

Perhaps I am missing something. Could you please expand upon your request so in order to clear up the confusion?

|||

I am sorry, lack of english.

My form has 9 textboxes. Textbox1, 2, 3 Needs to insert values into the first column. Textbox4, 5, 6 into the second and then Texrbox7, 8, 9 into the last column.

My question is how do I format the following line of code do do what I need?

oCustomTask1.SQLStatement = oCustomTask1.SQLStatement & "Values ('1rowst', '2rowst', '3rowst')"

I think it is something like this, but I am Really not sure and some help would be greatly appretiated:

oCustomTask1.SQLStatement = oCustomTask1.SQLStatement & "Values ('Textbox1', 'Textbox4', 'Textbox7')"

I am really not sure.

Thanks

|||

I'm still confused. Please help me clarify.

You wish to put all the contents of three textboxes into a single field in the table?

"Textbox1, 2, 3 Needs to insert values into the first column"

If that is the situation, why not just have one textbox -not three?

|||

No, sorry Arnie,

Textbox 1,4,7 go in column 1

TextBox 2, 5, 8 Go in column 2

TextBox 3, 6, 9 Go in column 3

I need my application to insert the values into the Database. If there is Nulls in the textbox go to the next record.

I think the code should go something like this:

If Textbox2 = '' then

oCustomTask1.SQLStatement = oCustomTask1.SQLStatement & "Values ('" Textbox1.Text "', '" Textbox4.Text "', '" Textbox7.Text "')"

Elseif Textbox3 = '' then

oCustomTask1.SQLStatement = oCustomTask1.SQLStatement & "Values ('" Textbox1.Text "', '" Textbox4.Text "', '" Textbox7.Text "')"

And

oCustomTask1.SQLStatement = oCustomTask1.SQLStatement & "Values ('" Textbox2.Text "', '" Textbox5.Text "', '" Textbox8.Text"')"

As you can see I am throwing a rock into the grass, because I am not % 100 sure if this is correct.

Thanks for the patience Arnie

|||

If I am understanding you correctly, it appears that you wish to load textbox values into the table depending upon the status of other textbox values.

Your use of the IF...ELSEIF structure may work just fine for your intentions. Something like this might work.

IF Textbox1.Text = '' Then

IF Textbox2.Text = '' Then

oCustomTask1.SQLStatement = oCustomTask1.SQLStatement & "Values ('" + Textbox3.Text + "', '" + Textbox6.Text + "', '" + Textbox9.Text + "')"

ELSE

oCustomTask1.SQLStatement = oCustomTask1.SQLStatement & "Values ('" Textbox2.Text + "', '" + Textbox5.Text + "', '" + Textbox8.Text + "')"

END IF

ELSE

oCustomTask1.SQLStatement = oCustomTask1.SQLStatement & "Values ('" + Textbox1.Text + "', '" + Textbox4.Text + "', '" + Textbox7.Text + "')"

END IF

|||That was exactly what I needed. Thanks Arnie|||Of course you should be careful with this method since this is completely vulnerable to SQL injection attacks.

Just a friendly reminder.|||

Jon,

Thank you very much for that. I was not familiar with that at all. I just want to make sure. This is a big issue with web applications (wich mine is not). Is that correct?

Thanks

|||Yes it is, but it's completely possible from within windows forms applications as well. So it's definitely something to watch out for.

help -Object reference not set to an instance of an object.

i m new for asp.net

when i run app. i got this error,

-----
Object reference not set to an instance of an object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

Line 49:
Line 50: adpt.Fill(ds, "SMS_student_class_master")
Line 51: txt.Text = ds.Tables.Item("roll_no").ToString
Line 52: con.Close()
Line 53: End Sub

Source File: c:\inetpub\wwwroot\aspnet\sms\assignment_d.aspx.vb Line: 51
------

my source code given below,

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If Not IsNothing(Request.QueryString("id")) Then
sid = Request.QueryString("id")
End If
Dim con As New SqlConnection
Dim constr As String
Dim cmd As New SqlCommand
Dim ds As New DataSet
Dim adpt As New SqlDataAdapter

constr = "data source=Baroda;user id=sa;password=;" & _
"initial catalog=SMS;persist security info=False;workstation id=Baroda;Packet size=4096"
con.ConnectionString = constr
con.Open()

cmd.CommandText = "SELECT * FROM SMS_student_class_master WHERE " & _
"stud_id='" + sid + "'"
cmd.Connection = con
adpt.SelectCommand = cmd

adpt.Fill(ds, "SMS_student_class_master")
txt.Text = ds.Tables.Item("roll_no").ToString
con.Close()
End Sub
---

what should i do?
anyone have any idea?
plz give solution.
its urgent.

thanks in advance.cmd.Connection = con
adpt = new SqlDataAdapter(cmd)
adpt.Fill(...)

help needed ! sql query

my app contains one form (aspx) and it has different controls to be filled by user (textbox,radiobutton ..etc)
it has one button which i want to use to pass values entered in these controls to other page and do some queries to sql server there (2nd page)
Now the thing is ...my controls can have NULL values ...like user could enter just one parameter and hit button
or user can fill 2 parameter and hit enter
so on the other hand (2nd page) how should i query the database accordingly ...

Example:
if (myTextBox.Text == String.Empty)
{
myParameter.Value = DBNull.Value;
}
else
{
myParameter.Value = myTextBox.Text;
}
|||

You can always use an If Else loop to write the query.
If IsDbNull(parameter) Then
parameter = (Whatever default value or just null)
Else
parameter = Request.Form("name of parameter")
End If
I hope this is clear enough.

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

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..!
>

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..!
>