这样的存储过程如何写?

[ncoxwwz]

我的查询非常复杂,我想把所有的查询条件综合成一句查询语句,然后再把此查询语句赋给存储过程中的参数,但是出错.请各位帮帮我?急,在线等!我的存储过程如下:
CREATE proc MC014
@t_sqlstr varchar(255)

as
select * from Table1 where @t_sqlstr
go

[adminis]

CREATE proc MC014
@t_sqlstr varchar(255)

as
Exec('select * from Table1 where ' + @t_sqlstr )
go

[xluzhong]

---需用动态sql
CREATE proc MC014
@t_sqlstr varchar(255)

as
exec('select * from Table1 where '+@t_sqlstr)
go

[ncoxwwz]

我先试一下.首先谢谢了.

[jinjazz]

exec('select * from Table1 where '+@t_sqlstr)

[jinjazz]

exec('select * from Table1 where 1=1'+@t_sqlstr)

否则 @t_sqlstr 空时就错了

[ncoxwwz]

我用的是Delphi 7,但在程式中出错,请各位帮我看看:
ADOStoredProc1.Close;
ADOStoredProc1.Parameters.Clear;
ADOStoredProc1.ProcedureName :='MC014';
ADOStoredProc1.Parameters.CreateParameter('@t_sqlstr',ftString,pdInput,255,SQLStr);
ADOStoredProc1.Prepared;
ADOStoredProc1.ExecProc;

if ADOStoredProc1.RecordCount =0 then
Begin
Application.MessageBox('Not Inquire Data !','System Information',MB_ICONERROR);
Exit;
end
else
ADOStoredProc1.Active:=True;
出错提示为:cannot perform this operation on a closed dataset.

[Frewin]

ADOStoredProc1.Close;
ADOStoredProc1.Parameters.Clear;
ADOStoredProc1.ProcedureName :='MC014';
ADOStoredProc1.Parameters.Refresh;
ADOStoredProc1.Parameters.ParamByName('@t_sqlstr'').Value:=''
ADOStoredProc1.Prepared;
ADOStoredProc1.Open;

[ncoxwwz]

谢谢各位的帮助,问题已经解决,给分.

[yunshiyu]

你的ADOStoredProc1.ExecProc了，就不能返回ADOStoredProc1.RecordCount的值了
只能用ADOStoredProc1.Active:=True;才能返回ADOStoredProc1.RecordCount