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

Next Topic