0 007_1 Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-03 #3 select count(id) as id_count from 临时
Q qianwt Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-03 #5 declare @rows integer select @rows=count(*) from 表名 print @rows
J jinmen Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-03 #6 执行了Sql语句后用 TQuery.RecordCount取得
K KeepObject Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-03 #7 AdoQuery1.sql.add('select count(id) as id_count from 临时'); AdoQeury1.Open; Result:=AdoQuery1.Fields[0].AsInteger;
AdoQuery1.sql.add('select count(id) as id_count from 临时'); AdoQeury1.Open; Result:=AdoQuery1.Fields[0].AsInteger;
J jsxjd Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-03 #8 var n:integer; query1.close query1.sql.clear query1.sql.add('select count(*) from table1'); query1.opon; n:=query1.fields[0].asinteger;
var n:integer; query1.close query1.sql.clear query1.sql.add('select count(*) from table1'); query1.opon; n:=query1.fields[0].asinteger;
Z Zhejiang_Knight Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-03 #9 各位老哥,是在Delphi中啊 象qianwt这样的是不行的吧
K ka_lee Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-03 #12 唉,来迟了。 我认为KeepObject的方法不可取。它增加了网路的流量。用: SELECT rowcnt FROM sysindexes WHERE (id = (select id from dbo.sysobjects where name='临时')) 最好。
唉,来迟了。 我认为KeepObject的方法不可取。它增加了网路的流量。用: SELECT rowcnt FROM sysindexes WHERE (id = (select id from dbo.sysobjects where name='临时')) 最好。