Thursday, January 21, 2010

Sql query for select the rendom record in sqlserver

SELECT TOP 1 * FROM TBL_PERDETAILS ORDER BY NEWID()

//HERE NEWID() FUNCTION WILL GENRATE THE RENDOM ID

No comments:

Post a Comment