declare @parm int, @myname varchar(20)set @parm = 210select @myname = myname from temp where @parm between start and end
selent MYName from temp where 210 between start and [end]
select myname from table where @inputnum between start and end
--用户输入100你输出什么?declare @temp table ( start int, [end] int, MYName varchar(2) ) insert into @temp select 1,100,'我' union all select 100,300,'你' union all select 500,1000,'他'declare @a int set @a=210 select myname from @temp where start<@a and [end]>=@aset @a=600 select myname from @temp where start<@a and [end]>=@a/* myname ------ 你 myname ------ 他 */
declare @t table( start int,[end] int,myname varchar(10)) insert @t select 1,100,'我' union all select 100,300,'你' union all select 500,1000,'他'select myname from @t where 210 between start and [end]
declare @a int set @a = 210 selent MYName from temp where @a between start and [end]
先回贴1>取得用户输入值 2>组合成SQLDim strTmp as string strTmp=trim(用户输入值框)strTmp='SELECT MyName from temp where " + strtmp + ' between start and [and] 'Ado.connection.execute(strtmp) ---------------------------------------------------- 再接分.
jf-------- declare @t table( start int,[end] int,myname varchar(10)) insert @t select 1,100,'我' union all select 100,300,'你' union all select 500,1000,'他'declare @a int set @a = 210 select myname from @t where @a between start and [end]
selent MYName from temp where 210 between start and [end]不就搞定了吗,
俺也来接分. select MYNAME FROM temp where @InputNumber BETWEEN start and end
selent MYName from temp where 210 between start and [end]
--我的应该最符合要求 declare @temp table ( start int, [end] int, MYName varchar(2) ) insert into @temp select 1,100,'我' union all select 100,300,'你' union all select 500,1000,'他' declare @InputValue int declare @MyName varchar(2)set @InputValue=600select @MyName=MyName from @temp where(@InputValue>=Start) and (@InputValue<[End])print @MyName
用case when 语句即可实现
selent MYName from temp where start < 210 and end >210
jf select MYName from temp where 210 between start and [end]
select MYNAME FROM temp where @InputNumber BETWEEN start and end
@myname varchar(20)set @parm = 210select @myname = myname from temp where @parm between start and end
where 210 between start and [end]
(
start int,
[end] int,
MYName varchar(2)
)
insert into @temp
select 1,100,'我' union all
select 100,300,'你' union all
select 500,1000,'他'declare @a int
set @a=210
select myname
from @temp
where start<@a and [end]>=@aset @a=600
select myname
from @temp
where start<@a and [end]>=@a/*
myname
------
你
myname
------
他
*/
insert @t select 1,100,'我'
union all select 100,300,'你'
union all select 500,1000,'他'select myname
from @t
where 210 between start and [end]
set @a = 210
selent MYName from temp
where @a between start and [end]
2>组合成SQLDim strTmp as string
strTmp=trim(用户输入值框)strTmp='SELECT MyName from temp where " + strtmp + ' between start and [and] 'Ado.connection.execute(strtmp)
----------------------------------------------------
再接分.
declare @t table( start int,[end] int,myname varchar(10))
insert @t select 1,100,'我'
union all select 100,300,'你'
union all select 500,1000,'他'declare @a int
set @a = 210
select myname from @t
where @a between start and [end]
where 210 between start and [end]不就搞定了吗,
select MYNAME FROM temp
where @InputNumber BETWEEN start and end
where 210 between start and [end]
declare @temp table
(
start int,
[end] int,
MYName varchar(2)
)
insert into @temp
select 1,100,'我' union all
select 100,300,'你' union all
select 500,1000,'他'
declare @InputValue int
declare @MyName varchar(2)set @InputValue=600select @MyName=MyName from @temp where(@InputValue>=Start) and (@InputValue<[End])print @MyName
where start < 210 and end >210
select MYName from temp
where 210 between start and [end]
where @InputNumber BETWEEN start and end