Query Order

Question

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

To ensure the results are always sorted in the same way you have to add an ORDER BY clause.

If you don't provide an explicit order, results are not sorted in a predictable way.

-- Gianluca Sartori

Jack Corbett SSC Guru Points: 184394 More actions · Answer 2

You also need to take into account collation. Are they all the same?

sugan SSC-Addicted Points: 492 More actions · Answer 3

I didn't explicitly added * Order by * in the query.

But how can i get ordered data of every run in 2 databases?

Can you please explain collation ?

I need some more descriptive.

Thanks.

Cookies on SQLServerCentral