Skip to content

Instantly share code, notes, and snippets.

@hendrasyp

hendrasyp/SP_Select.sql

Created December 23, 2022 10:51
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save hendrasyp/54614ff2bac2331548c0f2ebb56c9334 to your computer and use it in GitHub Desktop.
Save hendrasyp/54614ff2bac2331548c0f2ebb56c9334 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Server - Stored Procedure Show Data
Raw
SP_Select.sql
CREATE PROCEDURE [Schema].[SP_Name] (@Param [DataType(Size)] = DEFAULT_VALUE)
AS
BEGIN
-- Condition With Coalesce
WHERE COALESCE(id, NULL) = COALESCE(@paramId, id, NULL) -- EQUALS
AND COALESCE(name, '%') LIKE COALESCE('%' + @paramName + '%', name, '%') -- LIKE
AND ( -- DATE RANGE
CONVERT(VARCHAR(10) , date, 111) >= CONVERT(VARCHAR(10) , @FromDate, 111) AND
CONVERT(VARCHAR(10) , date, 111) <= CONVERT(VARCHAR(10) , @ToDate, 111)
);
END
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment