How to fetch random record form a tblDNFRec

Posted by Amatya under Sql Server category on 9/26/2017 | Points: 40 | Views : 1585

Post Code |

Search Codes |

Code Home

How to fetch random record form a tblDNFRec .

Select top 1* from tblDNFRec order by NEWID()
The value returned by NEWID is different for each computer. The NEWID() function in SQL Server creates a unique value of type uniqueidentifier.

Thanks
Amatya

Alert Moderator

Bookmark It

Comments or Responses

Latest Code Snipptes

Code snippet for setInterval
Azure Function - Connect to MS Dynamics using application user - .NET core 3.1
MS Dynamics 365- Custom action - Read input parameter values from plugin
MS Dynamics 365- Disassociate record from N-N relationship entity
Search box with icon in Navbar in bootstrap 4
Remove HTML tags using Regular Expression in C#
MS Dynamics 365- Close Quote from C# / Custom action
How to show and hide submenu in tabs using jquery
How to add star rating and submit rating
More ...