Programming Solutions
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment