SQL Variable vs Values

[PMR191061]

I have two identical select statements. One uses Variables and the other uses actual hard coded values but for some reason they return data in a different order.

please can you help me?

 

[Zathras]

If you want a specific order, then use the ORDER BY clause. Without specifying an ORDER BY, the DBMS is free to return the records in any order it wants.

 

[SQLDenis]

Also look at your query execution plan, is it the same for both?

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/