, Guest>> || || |
/ Microsoft SQL Server
    [new]
Nikolay Gerasimov
Member

:
: 493
txt :
001   1405 24  000   2     
002        0605 02  00092   1   
003         1305 000  000   2           0646
004   1005 01  000   2   
005   1005 01  0000   2     
006   1005 01  000   2   
007   1005 01  0000   2     
008   1505 01  00043   1     
009   0705 19  0002   4     
010   0705 19  0002   4     
:
8.0
13
1  SQLCHAR 0 4  "\t"   1  num  ""
2  SQLCHAR 0 21 "\t"   2  fio  ""
3  SQLCHAR 0 8  "\t"   3  dat  ""
4  SQLCHAR 0 7  "\t"   4  agn  ""
5  SQLCHAR 0 7  "\t"   5  pnr  ""
6  SQLCHAR 0 2  "\t"   6  cl   ""
7  SQLCHAR 0 3  "\t"   7  gor1 ""
8  SQLCHAR 0 4  "\t"   8  gor2 ""
9  SQLCHAR 0 2  "\t"   9  st   ""
10 SQLCHAR 0 4  "\t"   10 km   ""
11 SQLCHAR 0 3  "\t"   11 t    ""
12 SQLCHAR 0 7  "\t"   12 b    ""
13 SQLCHAR 0 4  "\r\n" 13 nm   ""

create table #t (num varchar(4), fio varchar(21),dat varchar(8),
	agn varchar(7),pnr varchar(7),cl varchar(2),gor1 varchar(3),
	gor2 varchar(4),st varchar(2),km varchar(4),t varchar(3),
	b varchar(7),nm varchar(4))
bulk insert #t from 'C:\DBCLIENT\TEMUL32\temul.txt'
WITH (
   FORMATFILE = 'C:\DBCLIENT\TEMUL32\temul.fmt'
)
select * from #t
drop table #t
. , , ?
15 05, 12:17[2174508]      |
 Re:   [new]
saint
Member

:
: 2262
, . , : '\t\t'
15 05, 14:55[2175428]      |
/ Microsoft SQL Server