0
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!

Wendy
  • 21
  • 4

1 Answers1

0

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
Shakeer Mirza
  • 4,786
  • 2
  • 15
  • 39
  • I would use an full text query with replacing tags instead to build `@QRY : @QRY = 'SELECT #COL1# FROM #TABLE# WHERE #COL1# LIKE ''%#KEY#''';` folowed by `@QRY = REPLACE(REPLACE(REPLACE(@QRY,'#COL1#',@Column),'#TABLE#',@Table),'#KEY#',@searchkey)` – Stéphane CLEMENT Sep 27 '17 at 06:35
  • Its not a SQL Server syntax.. OP need it in SQL Server @clementakis – Shakeer Mirza Sep 27 '17 at 06:57
  • Sorry for the missing SET ... `SET @QRY = 'SELECT #COL1# FROM #TABLE# WHERE #COL1# LIKE ''%#KEY#'''` folowed by `SET @QRY = REPLACE(REPLACE(REPLACE(@QRY,'#COL1#',@Column),'#TABLE#',@Table),'#KEY#',@searckey)` – Stéphane CLEMENT Sep 27 '17 at 07:17