by Rajeev » Tue, 14 Jan 2003 21:14:06
by TLV » Tue, 14 Jan 2003 21:41:01
Bulk insert can import more than 256 characters.Quote:>-----Original Message-----
>Can we bulk copy or bulk insert character columns from
>text file having datalength morethan 256.
>I have tried it but it is importing upto 256 characters.
>.
by Rajeev » Tue, 14 Jan 2003 22:15:57
Yes it was the setting of query analyser .
It is able to insert more than 256 .
thanks,
Rajeev R
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
by Rajeev » Tue, 14 Jan 2003 22:23:50
Thanks,
Rajeev R
Quote:>-----Original Message-----
>>-----Original Message-----
>>Can we bulk copy or bulk insert character columns from
>>text file having datalength morethan 256.
>>I have tried it but it is importing upto 256 characters.
>>.
>Bulk insert can import more than 256 characters.
>It could be the setting of the Query Analyzer
>Check the setting
>tools\options\result under "Maximum characters per
>column" .
>.
I have to append a table every week.
I run a SELECT statement with some calculated fields -
about 15,000 records are in the result set.
What is the best way to append a table from a SELECT
result set?
Thanks.
Lynn.
2. Q: DataEase for Windows 1.1
3. BULK INSERT under bulk copy?
4. help!!
5. Error when bulk insert follows another large bulk insert
6. MDI child close icon - problem
7. Bulk Delete (as opposed to Bulk Insert)
10. Open Client 10.0.2 Bulk Copy Inserting NULLs Instead of Correct Values
11. Copy, Bulk copy, fastload - Ingres II 2.0 AXM on OpenVMS 7.x
12. Copy, Bulk copy, fastload - Ingres II 2.0 AXM on OpenV MS 7.x