有熟SQL sever7的吗?帮哦看一下
CREATE PROCEDURE sp_hgp_select
@strpara varchar(50)
AS
set @strpara="select * from HGP where id<>null and " + @strpara
exec @strpara
exec sp_hgp_select "kfdh='1213123'" 在执行时报错:
Server: Msg 2812, Level 16, State 62, Line 5
Could not find stored procedure 'select * from HGP where id<>null and kfdh='1213123'.
主要是想通过存储过程实现灵活的条件查询