CREATE PROCEDURE sp_1
@values varchar(10),
@va varchar(10)
AS
exec ('SELECT * from tbl_modeltype where modelid=' +@values +
' and modeltype= '+@va)

exec sp_1 1,屈刀模
例如这样的 老是有错啊

加个use 表
看看

CREATE PROCEDURE sp_1
@values varchar(10),
@va varchar(10)
AS
exec ('SELECT * from tbl_modeltype where modelid=' +@values +
' and modeltype= '+@va)

exec sp_1 '1','屈刀模'