CREATE PROCEDURE GetQuestionByNo 
    -- Add the parameters for the stored procedure here
    @shopNo int = 0
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    SELECT * from dbo.DQuestionData where shop_no = @shopNo
END
GO

drop procedure GetQuestionByNo

exec GetQuestionByNo 2
exec GetQuestionByNo