Viewing post 1 (of 1 total)
Like this:
ALTER TABLE
ADD COLUMN rowid int IDENTITY(1,1)
GO
select *
from table
where rowid % 3 = 0
March 19, 2004 at 10:28 am
#499540