Skip to content

Instantly share code, notes, and snippets.

@mdyusufalam

mdyusufalam/Store Procedure Startup Template

Created May 13, 2020 07:20
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save mdyusufalam/ee51d78fe809112cff77291101890b8c to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save mdyusufalam/ee51d78fe809112cff77291101890b8c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Store Procedure Startup Template
/*
-- ======================================================================================
-- Author: Md Yusuf Alam
-- Create date: 13th May 2020
-- Description: https://docs.google.com/document/d/1GaIkxK5Dt3p7hGTMm7rZzSq1g656q78uhOaYrD9RBqk/edit Implement Quick Search
---------------------------------------------------------------------------------------
Ref# Modified By Modified date Descriptions
#1 [Developer Name] [Date] [Description]
----------------------------------------------------------------------------------------
*/
CREATE PROCEDURE [dbo].[usp_{spName}]
(
@stParameters XML
)
AS
BEGIN TRY
SET NOCOUNT ON;
SET NOCOUNT OFF;
END TRY
BEGIN CATCH
END CATCH
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment