SA0264 : Temporary table created but not used as table source |
 |
The topic describes the SA0264 analysis rule.
MessageTemporary table created but not used as table source
DescriptionThe rule checks T-SQL code for temporary tables created, but not used as a table source in any FROM clause of following SELECT, UPDATE, DELETE or MERGE statements.
How to fixReview the code and the temporary table usages and remove it if is not really needed.
ScopeThe rule has a Batch scope and is applied only on the SQL script.
ParametersRule has no parameters.
RemarksThe rule does not need Analysis Context or SQL Connection.
Effort To Fix3 minutes per issue.
CategoriesDesign Rules, Code Smells
Additional InformationThere is no additional info for this rule.
Example Test SQL|
SQL
1CREATE TABLE #Greeting 2( 3GreetingId INT IDENTITY (1,1) PRIMARY KEY, 4Message nvarchar(255) NOT NULL, 5) 6 7SELECT * INTO #Greeting2 FROM dbo.Greeting 8 9INSERT INTO #Greeting (Message) 10SELECT 'Hello!' 11UNION ALL 12SELECT 'Hi!' 13UNION ALL 14SELECT 'Hello, world!' 15 16DELETE #Greeting WHERE GreetingId = 3 17 18-- SELECT * FROM #Greeting g WHERE g.Message like 'Hello%' |
Analysis Results| Message | Line | Column | |
|---|---|---|---|
| 1 | SA0264 : Temporary table created but not used as table source. | 1 | 13 |
| 2 | SA0264 : Temporary table created but not used as table source. | 7 | 14 |
See Also