两张表没有联系 用模糊存储过成查出来 在线的用户帮帮忙 多谢各位了

Create PROCEDURE PRO_SERCH@postTitle varchar(100),@resoutceTitle varchar(100)asDeclare @Str_SQL nvarchar(MAX),        @Choese varchar(10);BEGIN    if (@Choese='帖子')    set @Str_SQL='select * from tb_Post where postTitle like [email protected] %'' '    if (@Choese='资源')    set @Str_SQL='select * from tb_Resource where resoutceTitle like [email protected] %'' '    exec(@Str_SQL)    END

Create PROCEDURE PRO_SERCH@postTitle varchar(100),@resoutceTitle varchar(100)asDeclare @Str_SQL nvarchar(MAX)BEGIN    if @postTitle is not null    set @Str_SQL='select * from tb_Post where postTitle like [email protected] +'%'''    if @resoutceTitle is not null    set @Str_SQL='select * from tb_Resource where resoutceTitle like [email protected] +'%'''    exec(@Str_SQL)    END