SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-07-2008, 08:38 AM
| ||||
| ||||
 help,a difficult text how to sql table code ? help,a difficult text how to sql table code ? i have a text 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 help me how write the sql code ?      |
|
05-11-2008, 08:41 PM
| ||||
| ||||
| Re: help,a difficult text how to sql table code ? What??? -- Sincerely, John K Knowledgy Consulting http://knowledgy.org/ Atlanta's Business Intelligence and Data Warehouse Experts "agiler" <sulichun@tom.com> wrote in message news:Op5IO%23ulIHA.5956@TK2MSFTNGP03.phx.gbl... > help,a difficult text how to sql table code ? > > i have a text 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 help me how write the sql code ? > |
Linear Mode
