CREATE procedure product @con_stras begin set nocount on exec(@con_str) set nocount off end
CREATE procedure product @con_stras begin set nocount on exec(@con_str=“select * from product where cate=1 and brand=3 and product_name like '%%'” ) set nocount off end
@con_stras
begin
set nocount on
exec(@con_str)
set nocount off
end
@con_stras
begin
set nocount on
exec(@con_str=“select * from product where cate=1 and brand=3 and product_name like '%%'”
)
set nocount off
end