CREATE PROCEDURE TestPro
@tt varchar(20)
AS
select * from Equipment where Eq_Name=@tt;
GOtt為傳入參數,在表Equipment中Eq_Name字段下有符合的紀錄
返回結果為空紀錄集,為什么?
我直接寫ADOQuery.sql.text:='select * from Equipment where Eq_Name='''+tt+''''
查詢是有結果的
@tt varchar(20)
AS
select * from Equipment where Eq_Name=@tt;
GOtt為傳入參數,在表Equipment中Eq_Name字段下有符合的紀錄
返回結果為空紀錄集,為什么?
我直接寫ADOQuery.sql.text:='select * from Equipment where Eq_Name='''+tt+''''
查詢是有結果的
select *,@tt from Equipment where Eq_Name<>@tt; //这里是<> 不是=
结果中最后一列显示为'游标'
传'游標卡尺等等' 显示'游標卡'