SQL中执行存储过程时:
DB-Library: Unexpected EOF from SQL Server. General network error. Check your documentation.
Net-Library error 10054: ConnectionCheckForData ((null)()).
DB-Library Process Dead - Connection Broken
...全文
1416打赏收藏
这是什么错呀?
SQL中执行存储过程时: DB-Library: Unexpected EOF from SQL Server. General network error. Check your documentation. Net-Library error 10054: ConnectionCheckForData ((null)()). DB-Library Process Dead - Connection Broken
from qa_jlad
where jlgs = @hjslc and jldate >= @hdatea and jldate <= @hdateb
and jlmac = @hjsdepaa and jlchar = @hjschar order by jldate,jltime
open tftable
fetch tftable into @hjssam ,@hjsnumber ,@hjsdate
while @@fetch_status=0
begin
select @ii = @ii + 1
fetch tftable into @hjssam ,@hjsnumber ,@hjsdate
end
close tftable
deallocate tftable
问题就在这一句上:
select convert(char(13),jltime) ,convert(char(13),jlreadnumber) ,convert(char(13),jldate)
原来是
select convert(char(13),jltime) AS JLTIME,convert(char(13),jlreadnumber) AS READNUMBER,convert(char(13),jldate) AS JLDATE