|
|
x********g
发帖数: 3717 | 3 还有什么途径看AV5啊？实在受不了firstrow,fromsports这些卡卡停停的货了。。 |
|
|
|
d********g
发帖数: 11948 | 6 可以看live tv啊 装个fusion然后装mash up 基本神马都能看
sportsdevil可以看firstrow 清晰度一般 但也有高清的 可以看espn2 espn
euroaports foxsports == |
|
|
|
|
w****z
发帖数: 288 | 10 azhibo，zhibo8，wasu，firstrow什么都不work ：（ |
|
A*****a
发帖数: 52743 | 11 firstrow sports肯定有
[在 Dzeko (狼堡9号) 的大作中提到：]
：求链接
：
：........... |
|
m***r
发帖数: 1801 | 12 skysports 在 firstrow就可以看了
手机装个kodi值不值得折腾？ |
|
m******o
发帖数: 8504 | 13 奥，firstrow上的链接是有很多广告
这场反正下半场德德踢的太烂了，让人昏昏欲睡 |
|
|
|
|
T******e
发帖数: 7425 | 17 even firstrow doesn't have the signal for this match, XX
what a bs for ATP Cincinnati organization. |
|
J********o
发帖数: 17447 | 18 firstrow最屌丝，但是肯定能看就是太不清楚 |
|
k**g
发帖数: 1558 | 19 我每天要bulk upload一个csv的文件，这个csv的 文件名有每天的日期，我用了下面的
语句，但是 出错，大家帮我一下吧？谢谢！
DECLARE @FileName VARCHAR(100)
SET @FileName='c:\DAILY_'+( CONVERT(VARCHAR(8),GETDATE(),112)+'.csv')
BULK INSERT DAILY
FROM @FileDate
WITH
(
FIRSTROW = 2,
FIELDTERMINATOR = ';',
ROWTERMINATOR = '\n'
)
Go
错误信息是：
Incorrect syntax near '@FileName'.
Msg 319, Level 15, State 1, Line 8
Incorrect syntax near the keyword 'with'. If this statement is a common
table expression or an xmlnamespaces clause, the previous statement must be
te... 阅读全帖 |
|
k**g
发帖数: 1558 | 20 不懂啊，是不是这样啊？谢谢！
BULK INSERT DAILY
FROM “@FileDate；”
WITH
(
FIRSTROW = 2,
FIELDTERMINATOR = ';',
ROWTERMINATOR = '\n'
)
Go
错误是：
Msg 4860, Level 16, State 1, Line 5
Cannot bulk load. The file "@FileDate;" does not exist. |
|
k**g
发帖数: 1558 | 21 还是不对阿
BULK INSERT DAILY
FROM @FileDate
;WITH
(
FIRSTROW = 2,
FIELDTERMINATOR = ';',
ROWTERMINATOR = '\n'
)
Go
错误信息
Msg 102, Level 15, State 1, Line 6
Incorrect syntax near '@FileDate'.
be |
|
k**g
发帖数: 1558 | 22 用了dynamic sql,还是出错。在with前加 了semicolon第二个error没有了，但是还是
有incorrect syntax near 'u:'
DECLARE @sql nvarchar(500)
SET @sql = 'BULK INSERT MSCIDAILY FROM u:\DAILY_'+(CONVERT(VARCHAR(8) ,
GETDATE(),112)+'.csv')+' WITH (FIRSTROW = 2,FIELDTERMINATOR = '';'',
ROWTERMINATOR = ''\n'')'
EXEC(@sql)
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'u:'.
Msg 319, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'with'. If this statement is a common
table expression or an xmlnamespaces clause,... 阅读全帖 |
|
A*******n
发帖数: 625 | 23 declare @sql nvarchar(400)
set @sql='
BULK INSERT DAILY
FROM '+'"c:\DAILY_'+( CONVERT(VARCHAR(50),GETDATE(),112)+'.txt"')+'
WITH
(
FIRSTROW = 2,
FIELDTERMINATOR = '';''
ROWTERMINATOR = ''\n''
)'
exec (@sql)
it is working for me. try that. |
|
A*******n
发帖数: 625 | 24 declare @sql nvarchar(400)
set @sql='
BULK INSERT DAILY
FROM '+'"c:\DAILY_'+( CONVERT(VARCHAR(50),GETDATE(),112)+'.txt"')+'
WITH
(
FIRSTROW = 2,
FIELDTERMINATOR = '';''
ROWTERMINATOR = ''\n''
)'
exec (@sql)
try this |
|
A*******n
发帖数: 625 | 25 declare @sql nvarchar(400)
set @sql='
BULK INSERT DAILY
FROM '+'"c:\DAILY_'+( CONVERT(VARCHAR(50),GETDATE(),112)+'.csv"')+'
WITH
(
FIRSTROW = 2,
FIELDTERMINATOR = '';''
ROWTERMINATOR = ''\n''
)'
exec (@sql) |
|
A*******n
发帖数: 625 | 26 DECLARE @SQL VARCHAR(400)
SET @SQL ='
BULK INSERT DAILY
FROM '+'"c :\DAILY_'+( CONVERT(VARCHAR(8),GETDATE(),112)+'.csv"')+'
WITH
(
FIRSTROW = 2,
FIELDTERMINATOR = ';',
ROWTERMINATOR = '\n'
)'
exec (@SQL)
试试看标点都对不对，差不多是这样。 |
|
A*******n
发帖数: 625 | 27 DECLARE @SQL VARCHAR(400)
SET @SQL ='
BULK INSERT DAILY
FROM '+'"c :\DAILY_'+( CONVERT(VARCHAR(8),GETDATE(),112)+'.csv"')+'
WITH
(
FIRSTROW = 2,
FIELDTERMINATOR = ';',
ROWTERMINATOR = '\n'
)'
exec (@SQL)
试试看标点都对不对，差不多是这样。 |
|
m******t
发帖数: 6905 | 28 Hi all
I created a table and tried the solution above but it failed. who can help
--Creat Table and loading data by using bulk insert
Drop Table Test20140317
Create Table Test20140317
(SalesDate date,
Sales Decimal)
Bulk insert Test20140317
from 'C:\filepath\Book1.txt'
with
(ROWTERMINATOR = '\n',
firstrow = 2)
select * from Test20140317
--Here is the above solution, I used DateName function to display week days.
select
Month(SalesDate),
case when DATENAME(WEEKDAY,(SalesDate)) = 0 then ... 阅读全帖 |
|
k**e
发帖数: 86 | 29 foo[firstrow SUBSEP firstcolumn] |
|
