CREATE PROCEDURE [dbo].[Display_Select_Student]
(
@Col_Name varchar(500)=null,
@Col_Value varchar(500)=null
)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @Qry VARCHAR(1000)
SET @Qry = 'SELECT * FROM [Student] WHERE '+@Col_Name+'='''+@Col_Value+''''
EXEC(@Qry)
SET NOCOUNT OFF;
END
No comments:
Post a Comment