create procedure search
@table varchar(50),@column varchar(50),@searchkey varchar(20)
as
select @column from @table where @column like '%@searchkey%'
is that possible? if not please do suggest. Thank you!
create procedure search
@table varchar(50),@column varchar(50),@searchkey varchar(20)
as
select @column from @table where @column like '%@searchkey%'
is that possible? if not please do suggest. Thank you!
Yes, Go with Dynamic coding
create procedure search
@table varchar(50),@column varchar(50),@searchkey varchar(20)
as
BEGIN
DECLARE @QRY VARCHAR(MAX)='select '+@column+' from '+@table+'
where '+@column+' like %'+@searchkey+'%';
EXEC (@QRY);
END