62,046
社区成员
发帖
与我相关
我的任务
分享
create table #A
(
Value int
)
insert into #A select 10
insert into #A select 45
create table #B
(
ID1 int,
ID2 int,
str1 nvarchar(50),
str2 nvarchar(50)
)
insert into #B select 5,20,'csdn1','csdn2'
insert into #B select 30,60,'csdn3','csdn4'
select A.Value,B.str1,B.str2 from
(
select *,
(select count(*)+1 from #A where [Value]<A.[Value]) ID
from #A A
)
A
join
(
select *,
(select count(*)+1 from #B where ID1<B.ID1) ID
from #B B
)
B
on A.ID=B.ID and A.Value between B.ID1 and B.ID2
Value str1 str2
----------- -------------------------------------------------- --------------------------------------------------
10 csdn1 csdn2
45 csdn3 csdn4
(2 行受影响)
string strSql = "select top 10 字段1 from a";
DataTable dt1 = Sqlselect(strSql);
string ipstr = dt1.Rows[0]["字段1"].ToString();
Int64 num = 公式转换ipstr ..;
string strSql2 = "select * from b where " + num + ">=字段1 and " + num + "<=字段2";
create table #A
(
ID int identity(1,1) primary key,
Value int
)
insert into #A select 10
insert into #A select 45
create table #B
(
ID int identity(1,1) primary key,
ID1 int,
ID2 int,
str1 nvarchar(50),
str2 nvarchar(50)
)
insert into #B select 5,20,'csdn1','csdn2'
insert into #B select 30,60,'csdn3','csdn4'
select A.Value,B.str1,B.str2 from #A A
join #B B
on A.ID=B.ID and A.Value between B.ID1 and B.ID2
Value str1 str2
----------- -------------------------------------------------- --------------------------------------------------
10 csdn1 csdn2
45 csdn3 csdn4
(2 行受影响)