Wednesday, 12 July 2017

Multiple Condition with parameter in sql server

Multiple Condition with parameter in sql server


USE [Girfa_Portal]
GO
--=========== Condition with concatenate =========================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[Girfa]
(@arg varchar(500))

as
begin
declare @sql varchar(MAX)
set @sql='select * from    student'
exec(@sql + @arg)
end