Fake a long running SQL statement

Question

I want to fake a long running SQL statement so I can experiment with sys.dm_exec_requests

"Fake" isn't the best way to describe it, but does anyone have a good tip on perhaps selecting autogenerated records? Perhaps using a CTE?

Answer 1

Here's a long-running SQL statement:

WAITFOR DELAY '0:05';

It will take around five minutes to execute.