T-SQL(MS SQL 2008), Executing procedure without 'EXEC' or 'EXECUTE' word

Question

Is it OK to execute a stored procedure without 'EXEC' or 'EXECUTE' word in the beginning ?

Normally to execute stored procedure I do

EXEC DeleteProfile 'Joe Smith'

But, I've noticed that next command works as well:

DeleteProfile 'Joe Smith'

Why should I write 'EXEC' or 'EXECUTE' word?

Is it ok not to write it before stored procedure name to execute stored procedure?

Thanks.

Answer 1

I've found in MSDN "You do not have to specify the EXECUTE keyword when you execute stored procedures when the statement is the first one in a batch."

Get it. Sorry for question.

This wouldn't work without GO at the end of each statement:

DeleteProfile 'Joe Smith'
DeleteProfile 'Joe Smith'
DeleteProfile 'Joe Smith'