NewID() in Order By
I have seen examples where NewId() is used in the order by. For example: Select TOP 10 * From Authors ORDER BY NEWID()What does NewID() in the order by clause is responsible for? Thanks in Advance.
2004-11-03
9 reads
Date
2004-10-04
The SQLServerCentral.com Store
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists
2004-08-27
3 reads
RE: Linking "text" item with "numeric" item -- Please HELP !
Use cast to convert text to int/numericOFFERITEMS ON ITEMMAST.EDPNO = CAST(SUBSTRING(OFFERITEMS.OFFERITEM, 9, 8) as int)
2004-06-11
2004-06-02
RE: table corruption - INSERT fails?
Check the table fragmentation with DBCC showcontig. Based on the indexes and the order of inserts, over a period of time the table could get severely fragmented slowing down inserts. You might want to check for any locks or deadlocks.
2004-05-26
RE: SQL Books Online installation on network drive
I've had issues with moving this before. Instead, the easier solution, IMHO, is to let each person install the client tools on their workstation. Simple, fast, not that large, and works well.There are relatively few updates to BOL, so this shouldn't be a big deal to update everyone.
2004-04-08
Soap RPC via SQLXML
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-03-01
INSERT INTO used with CASE SQL statement
Hello: I need help with a SQL INSERT INTO SELECT statement. I am trying to insert some data into a table called Months based on a SELECT statement from the table called Weeks. I'm using SQL Server 2000. First, I have a SELECT statement As follows: SELECT last_name, first_name, SUM(bhrs) AS totalbhrs FROM Weeks WHERE workdate between […]
2004-02-26
RE: Dynamic "IN" or somehting better
Great! Hmm i guess it doesn't match the nulls cause its not "IS NULL"
2004-02-21
Blogs
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers