I found one small SQL Server behavior that surprised me more than I expected. You can create a stored procedure with an empty body, and SQL Server will accept it. No SELECT, no INSERT, no PRINT, nothing inside. Even more surprisingly, the procedure can be executed without any error. I always assumed at least one statement would be required, but apparently not.
This is not something you will usually use in real production logic, but it is a useful edge case to know. It helps when you test how SQL Server validates object definitions and execution flow.
Simple demo:
CREATE PROCEDURE MyEmptyProcedure AS GO EXEC MyEmptyProcedure GO
So yes, it really works. The procedure body can be empty, and SQL Server still allows create + execute.