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'
Post your comments / questions
Recent Article
- Fix-Gradient effect turning to gray in after effects
- How to blur an image in python?
- ModuleNotFoundError: No module named 'whois' in Python GoviralHost Without Terminal
- How to Convert Image to Pencil Sketch in Python?
- AttributeError: module 'urllib' has no attribute 'request' - Python
- How to Extract audio from video files using python?
- PermissionError: [Errno 13] Permission denied: 'shampoo_sales.csv' - Python
- [WinError 145] The directory is not empty: 'FolderPath' - Python
Related Article