let
源 = Sql.Database("l\l1", "test",
[CommandTimeout=#duration(0,1,0,0),ConnectionTimeout=#duration(0,1,0,0)]),
all= 源{[Schema="dbo",Item="One_M_TY"]}[Data],
r=if (TopRow)>=0 then Table.FirstN(all,TopRow) else all
in
r
let
all = Sql.Database("l\l1",
"test", [Query="select * from [dbo].[Sheet1] "
//[Query="select "&TopRow&"* from [dbo].[Sheet1] "
,CommandTimeout=#duration(0,1,0,0)])
in
all
=================================================
vs直接设置
网友评论