Thanks guys anyway no answer necessary now, I found what is the way to do it...

Wrong my friend al rows are diferent

SELECT TOP 3 * FROM myTable

ORDER BY Column4, Column1

I hope this helps

My apologies you are right! I think I might get a dirty read and I didn't notice. Plan 1 and 3 are the same.

I am sorry, when I checked...

Sure, here is the example I am using to test:

CREATE INDEX INX_ReportsTo on Employees(reportsTo)

go

set ansi_nulls off

go

SELECT * FROM employees where reportsto = null

go

set...

DBCC CHECKIDENT

Checks the current identity value for the specified table and, if needed, corrects the identity value.

Syntax

DBCC CHECKIDENT

    ( 'table_name'

        [ , { NORESEED

                | { RESEED [ ,...

- Remi what you are saying is not totally wrong, actually I consider it a good aproach but, I have done some tests of my own and your solution also...

Pls allow me to explain my self better.

If you use  [ set ansi_nulls off ] you will be able to use null as value comparison this means:

column1 = null ...

SET ANSI_NULLS OFF

Specifies SQL-92 compliant behavior of the Equals (=) and Not Equal to (<&gt comparison operators when used with null values.

Try this in...

I agree with netmikem,

You don't have to see certifications as titles but as knowledge that help you out in your work....