SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE PROCEDURE getdata
(@num int,@semes char(12),@score int)
AS
BEGIN
SET NOCOUNT ON;
SELECT C,D from tablename where num=@num and semes=@semes
END
GO