Skip to main content

How to Get a Random Row From a SQL Database?

How to Get a Random Row From a SQL Database?

use this Quary
  • select Top 5 Id from YourTable order by NEWID()  

NEWID (Transact-SQL) 

Applies to: SQL Server (SQL Server 2008 through current version).
Creates a unique value of type uniqueidentifier.

NEWID() is based on a combination of a pseudorandom number (from the clock) and the MAC address of the primary NIC.

However, inserting random numbers like this as the clustered key on a table is terrible for performance. You should consider either NEWSEQUENTIALID() or a COMB-type function for generating GUIDs that still offer the collision-avoidance benefits of NEWID() while still maintaining acceptable INSERT performance.

Comments

Post a Comment

Popular posts from this blog

How to put counter of remaining charector of text in textbox

How to put counter for char remaining in textbox Html <asp:TextBox runat="server" ID="TxtBody" CssClass="form-control" TextMode="MultiLine" Rows="5" placeholder="Body" MaxLength="159" ></asp:TextBox> <div id="Textremaining"></div> Javascript $(document).ready(function() {     var maxChar = 159;     $('#Textremaining').html(maxChar + ' remaining');     $('#<%=TxtBody.ClientID%>').keyup(function() {         var length = $('#<%=TxtBody.ClientID%>').val().length;         var remaining = maxChar - length;         $('#Textremaining').html(remaining  + ' characters remaining');     }); });
3 comments
Read more

MIME Types list

Multipurpose Internet Mail Extensions (MIME) is an Internet standard that extends the format of email to support: Text in character sets other than ASCII Non-text attachments: audio, video, images, application programs etc. Message bodies with multiple parts Header information in non-ASCII character sets    MIME Types list   Suffixes Mime .3dm x-world/x-3dmf .3dmf x-world/x-3dmf .a application/octet-stream .aab application/x-authorware-bin .aam application/x-authorware-map .aas application/x-authorware-seg .abc text/vnd.abc .acgi text/html .afl video/animaflex .ai application/postscript .aif audio/aiff .aif audio/x-aiff .aifc audio/aiff .aifc audio/x-aiff .aiff audio/aiff .aiff audio/x-aiff .aim application/x-aim .aip text/x-audiosoft-intra .ani application/x-navi-animation .aos application/x-nokia-9000-communicator-add-on-software .aps application/mime .arc ap...
4 comments
Read more

Check your content

http://www.copyscape.com want to check your content is posted in other site or in blog. check in from this site. this site list out the content is posted which places. very useful for bloggers.
Post a Comment
Read more