Hmm,

I tested the first solution..

SELECT *

FROM Thanksgiving t

ORDER BY RAND()

and it worked, repeatedly.

Talking of the new interface, the only way I seem to be able to get back to the list of questions is to click on QotD in the menu bar,...

All the possible answers assume that the table exists and that the @Contador variable has been declared.

This a forum about SQL Server and all the questions are posted in English. I can read and speak German, but what you have posted has nothing to do with...

Of the 200 million rows, how many are in the current year, i.e. how many do you want to keep?

You'll need to use the DATEPART function and concatenate the hour, minutes and seconds, like this:

declare @now datetime
set @now = getdate()
select CAST(datepart(hh,dateadd(d,-datediff(d,0,@now),@now))...

The timing of this article being republished is interesting because the day before, I received a spam email demanding a ransom of USD5000 in Bitcoin within 48 hours, otherwise my...

This seems to me to be an ETL (Extract, Transform, Load) scenario and for these I tend to use an SSIS package. You can include the excellent suggestions from Steve...