agiler wrote:
> ,a regular text file how to sql 2000 table code ?
>
> i have a text file as follow, line with ¡°|¡±and {LF},
>
> 8|-000000186075919.|+000000000387820.|2008-03-31|20010423|
> 9|-000000000003919.|-000000000123620.|2008-03-31|20010123|
> 8|-000000018623419.|+000000000381230.|2008-05-30|20010423|
>
>
>
>
> i want to sign char(1)£¬year decimal(18,3) , month decimal(18,3), trandate
> smalldatetime£¬update smalldatetime£¬after to sql table is as follow,
>
>
> sign year month trandate update
> 8 -186075919.000 387820.000 3/31/2008 4/23/2001
> 9 -3919.000 -123620.000 3/31/2008 1/1/2001
> 8 -18623419.000 387820.000 5/30/2008 4/23/2001
>
>
>
> could you me how write the sql code ?
>
>
>

If this is for SQL Server 2000, as you indicate, you're in the wrong
group. This newsgroup is for MySQL, a completely different database.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

,a regular text file how to sql 2000 table code ?

i have a text file as follow, line with ¡°|¡±and {LF},

8|-000000186075919.|+000000000387820.|2008-03-31|20010423|
9|-000000000003919.|-000000000123620.|2008-03-31|20010123|
8|-000000018623419.|+000000000381230.|2008-05-30|20010423|




i want to sign char(1)£¬year decimal(18,3) , month decimal(18,3), trandate
smalldatetime£¬update smalldatetime£¬after to sql table is as follow,


sign year month trandate update
8 -186075919.000 387820.000 3/31/2008 4/23/2001
9 -3919.000 -123620.000 3/31/2008 1/1/2001
8 -18623419.000 387820.000 5/30/2008 4/23/2001



could you me how write the sql code ?