DF194: Stored procedure name begins with ‘sp_’.
The topic describes the DF194 T-SQL code analysis rule.
Category
BEST PRACTICE
Message
Stored procedure name begins with ‘sp_’.
Description
It is recommended not to start the procedure name with ‘sp_’ as this prefix is commonly reserved for system stored procedures.
Noncompliant code example
CREATE PROCEDURE dbo.sp_DemoProc
AS
BEGIN
SET NOCOUNT ON;
SELECT id FROM dbo.DemoTable;
END
GO
Compliant solution
CREATE PROCEDURE dbo.DemoProc
AS
BEGIN
SET NOCOUNT ON;
SELECT id FROM dbo.DemoTable;
END
GO
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All features
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo
If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?