Viewing 4 posts - 1 through 4 (of 4 total)
Use TABLOCKX Option.
July 3, 2008 at 8:22 am
#837892
sorry syntax is missed.
with numbered as(SELECT rowno=row_number()
over (partition by rand() order by rand())from Tablename)
Delete from numbered where rowno= (select max(rowno) from numbered)
June 23, 2008 at 3:42 am
#832528
over (partition by rand() order by rand())from )
select * from numbered where rowno= (select max(rowno) from numbered)
June 23, 2008 at 3:39 am
#832527
Hi,
use this Query...
June 23, 2008 at 3:38 am
#832526