VISUAL STUDIO FEEDS

Consider the following two statements --Query 1 select name, dateadd(day,datediff(day,0,create_date),0) as date_only from sys.objects where date_only>getdate()-100 --Query 2 select name, dateadd(day,datediff(day,0,create_date),0) as date_only from sys.objects order by date_only While the first query throws an error Invalid column name 'date_only'. ,How does the second query work?

...(Read whole news on source site)