关于红字能够比较出数据的原理是啥??
不太清楚!请教一下!select distinct
b.gyomuno,
b.gyomudatetime,
b.gyomujanm,
b.gyomumemo,
'shisanno' as keyname,
a.shisanno as keyvalue
from
PHShisanDB.dbo.Tochirireki a
inner join
PHShisanDB.dbo.Gyomu b
on
a.gyomuno = b.gyomuno
and
b.deleteflag = '0'
where
a.shisanno = @shisanno
and
a.rirekino< 'BR0000014'
order by b.gyomuno desc
不太清楚!请教一下!select distinct
b.gyomuno,
b.gyomudatetime,
b.gyomujanm,
b.gyomumemo,
'shisanno' as keyname,
a.shisanno as keyvalue
from
PHShisanDB.dbo.Tochirireki a
inner join
PHShisanDB.dbo.Gyomu b
on
a.gyomuno = b.gyomuno
and
b.deleteflag = '0'
where
a.shisanno = @shisanno
and
a.rirekino< 'BR0000014'
order by b.gyomuno desc
不知道楼主问的是不是这个意思?
其实是想大家对 SQL2005中对字浮串比较大小,给出基础原理!!!
一般都只有数字才可以比较大小的!!!! 为啥字浮串也能,它的原理是啥!