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.

Aremyst · Accepted Answer · 2012-12-18 06:58:37Z

19

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'

answered Dec 18, 2012 at 6:58

Aremyst

1,5282 gold badges22 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

DeanOC Over a year ago

It's quite acceptable to ask a (reasonable) question and then answer it. I didn't know that the exec was at all optional, so you've taught me something today (+1 for that)

Arkaine55 Over a year ago

I did notice Exec was now optional in Sql server 2008+higher, but didn't know about the "when the statement is the first one in a batch" requirement which seems like a big "gotcha" that would have been confusing to debug one day. So I have also learned something useful :) Thanks!

Collectives™ on Stack Overflow

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

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related