Combination Procedure SqlServer UNION,Like For Search

Combination Script SqlServer UNION,Like For Search

EXAMPLE :



SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[Getcari] 

@idiklan nvarchar = 0

,@judul nvarchar = 0

,@nmkategori nvarchar = 0

,@status nvarchar = 0

,@harga nvarchar = 0

,@deskripsi nvarchar = 0

,@UserId nvarchar = 0

AS

BEGIN

SET NOCOUNT ON;

SELECT idiklan,judul,REPLACE(judul,' ','-')[SLUG],nmkategori,status,harga,deskripsi,image1,tglposting,UserId FROM tblproperti WHERE idiklan LIKE '%' + @idiklan + '%' OR judul LIKE '%' + @judul + '%'  OR nmkategori LIKE '%' + @nmkategori + '%' OR status LIKE '%' + @status + '%' OR harga LIKE '%' + @harga + '%' OR deskripsi LIKE '%' + @deskripsi + '%' OR UserId LIKE '%' + @UserId + '%' 

UNION

SELECT idiklan,judul,REPLACE(judul,' ','-')[SLUG],nmkategori,status,harga,deskripsi,image1,tglposting,UserId FROM tblother WHERE idiklan LIKE '%' + @idiklan + '%' OR judul LIKE '%' + @judul + '%' OR nmkategori LIKE '%' + @nmkategori + '%' OR status LIKE '%' + @status + '%' OR harga LIKE '%' + @harga + '%' OR deskripsi LIKE '%' + @deskripsi + '%' OR UserId LIKE '%' + @UserId + '%'

ORDER BY idiklan ASC

END



This Example Working My Home