create proc get_AllStockInfo
@stockname nvarchar(1000)
as
begin
select *
from Stock
where [name] = @stockname
end
go

------解决方案--------------------

SQL code
CREATE PROC PR_TEST
(
@仓库名称 NVARCHAR(50)
) 
AS
SELECT * FROM stock
WHERE 仓库名称 = @仓库名称
GO

--调用
EXEC PR_TEST '仓库1'

------解决方案--------------------

SQL code

create proc GetStockByName
(
    @仓库名称 varchar(100)
)
as
begin
    select * from stock where 仓库名称=@仓库名称
end