呵呵,它会返回多个结果的,类似于执行
select
xx1 as TABLE_QUALIFIER,
xx2 as TABLE_OWNER,
xx3 as TABLE_NAME,
xx4 as COLUMN_NAME,
xx5 as KEY_SEQ,
xx6 PK_NAME
from xxxx
当然,只有一条返回记录。看Delphi写的例子:
ADOQuery1.SQL.text := 'exec sp_pkeys "test"';
ADOQuery1.Open;
ShowMessage('FieldName = ' + ADOQuery1.FieldByName('COLUMN_NAME').AsString);
select
xx1 as TABLE_QUALIFIER,
xx2 as TABLE_OWNER,
xx3 as TABLE_NAME,
xx4 as COLUMN_NAME,
xx5 as KEY_SEQ,
xx6 PK_NAME
from xxxx
当然,只有一条返回记录。看Delphi写的例子:
ADOQuery1.SQL.text := 'exec sp_pkeys "test"';
ADOQuery1.Open;
ShowMessage('FieldName = ' + ADOQuery1.FieldByName('COLUMN_NAME').AsString);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货