SQL语句
SELECT distinct top 300 [word] FROM [AriDic].[dbo].[lib] where word>='x'
T-SQL执行 正常
显示了所有数据asp程序里面 用同样的语句
结果只有三行 是
x
X being the o
X certificate符合条件的原始数据 word 类型varchar(500)
word
x
x
x
x
x
x
x
x
x
x
x
X
x
X being the o
X certificate
X chromosome
x è maggiore o uguale a y
X e Y sono arrivati a pari merito
X is kind to your skin
X is twice the l
X legs
X s
X rated
X ray
x ray
X Windows
x x x
x y diagram
X, or
Xanadu
Xanax
xantato
xantato
xanteina
xantelasma
xantene
xantene
xantenico
xantenico
xanthate
xanthein
xanthein
.........
SELECT distinct top 300 [word] FROM [AriDic].[dbo].[lib] where word>='x'
T-SQL执行 正常
显示了所有数据asp程序里面 用同样的语句
结果只有三行 是
x
X being the o
X certificate符合条件的原始数据 word 类型varchar(500)
word
x
x
x
x
x
x
x
x
x
x
x
X
x
X being the o
X certificate
X chromosome
x è maggiore o uguale a y
X e Y sono arrivati a pari merito
X is kind to your skin
X is twice the l
X legs
X s
X rated
X ray
x ray
X Windows
x x x
x y diagram
X, or
Xanadu
Xanax
xantato
xantato
xanteina
xantelasma
xantene
xantene
xantenico
xantenico
xanthate
xanthein
xanthein
.........
SELECT distinct top 300 [word] FROM [AriDic].[dbo].[lib] where word>='x'
T-SQL执行 正常
显示了所有数据---------------------你说的"显示了所有数据"是指重复的都显示了?
发现 asp页面
sql = "select distinct top 300 word from [lib] where word > 'x' ORDER BY [word]"
i=0
set rs = conn.Execute(sql)
While Not (rs.EOF Or rs.BOF)
'如果执行此句 执行几个循环 就结束了
str = str & "<span>"& rs("word") &"</span><br>"
'如果不执行上一句 单独执行以下计数语句 则循环持续了正确的次数
str = str & "-" & i
i=i+1
rs.MoveNext
Wend
leftlist.innerHTML = str我只有再检查下........
其他列都是正常的 就word列 数据会中断
最后是把数据导出,然后重新导入进去就正常了