CREATE PROCEDURE test_sproc_with_params
(
	@id int,
	@value int
)
AS
BEGIN
    SELECT * FROM TEST_TABLE WHERE @id = id AND @value = value
END