SQL

How to use like Operator in Sql Stored procedure?

How to use like Operator in Sql Stored procedure?, someone asked me to explain?
SQL

In this article I will show you how to create Sql Server Stored procedure like, parameter implemented for it. Here I used  nullable parameter (IsNull) and search the product using Like keyword.

Example: 

CREATE PROCEDURE SearchProduct @Name VARCHAR(250)
AS   
SELECT * FROM [Product]
WHERE Name like '%'+IsNull(@Name,Name)+'%'

here i created a stored procedure name called SearchProduct for searching the product using Like keyword with nullable parameter.

Output:  I searched for mobile products,

EXEC ProductList 'mobile'

 

sql server stored procedure like parameter

Post your comments / questions