SQL Server Loop

Question

how sql server handles infinite loops? Whether it detects this or kills the server.

EG:

WHILE (@number = 3)
BEGIN
    print @number
END

Answer 1

It depends on how long the client command waits.

By default, the .net application terminates after 30 seconds, and SSMS will wait forever (timeout = zero)

The SQL Server engine itself does not have the concept of "OK, I had enough"

Answer 2

try :) no, it does NOT detect them. it is simply regarded as a long running transaction.

also any type of loop is a sign of really bad sql coding practice