Users Pricing

forum

home / developersection / forums / sql server: what will trigger execution plan?

SQL Server: what will trigger execution plan?

Pravesh Singh 2289 08 May 2013
Hi Everyone!

If I have statement

DECLARE @i INT;
DECLARE @d NUMERIC(9,3);
SET @i = 123;
SET @d = @i;
SELECT @d;

and I include actual execution plan and run this query, I don't get an execution plan. Will the query trigger execution plan only when there is FROM statement in the batch?

Thanks in advance! 

Student


1 Answers