DF208: DDL and DML statements found within a routine body.
The topic describes the DF208 T-SQL code analysis rule.
Category
PERFORMANCE
Message
DDL and DML statements found within a routine body.
Description
It is not recommended to use DDL statements after DML statements within a single routine body, due to potential recompilation issues.
Noncompliant code example
CREATE PROCEDURE dbo.demoprocedure
AS
BEGIN
SET NOCOUNT ON
CREATE TABLE dbo.t1 (a INT NOT NULL)
SELECT a FROM dbo.t1
CREATE TABLE dbo.t2 (a INT NOT NULL)
SELECT a FROM dbo.t2
END
GO
Compliant solution
CREATE PROCEDURE dbo.demoprocedure
AS
BEGIN
SET NOCOUNT ON
CREATE TABLE dbo.t1 (a INT NOT NULL)
CREATE TABLE dbo.t2 (a INT NOT NULL)
SELECT a FROM dbo.t1
SELECT a FROM dbo.t2
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?