EXEC and EXECUTE

Question

Post reply

EXEC and EXECUTE

Steve Jones - SSC Editor

SSC Guru

Points: 736291
More actions
July 7, 2016 at 8:38 pm

#400378

Comments posted to this topic are about the item EXEC and EXECUTE
July 8, 2016 at 3:40 am

This was removed by the editor as SPAM

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Ed Wagner SSC Guru Points: 287026 More actions · Answer 1

Yes, it was an easy one. I admit I was looking for the trick.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

George Vobr SSChampion Points: 10000 More actions · Answer 2

Ed Wagner (7/8/2016)
Yes, it was an easy one. I admit I was looking for the trick.

+1 😉

Thanks Steve and happy weekend to all.

Revenant SSC-Forever Points: 42467 More actions · Answer 3

George Vobr (7/8/2016)
Ed Wagner (7/8/2016)
Yes, it was an easy one. I admit I was looking for the trick.
+1 😉
Thanks Steve and happy weekend to all.

+1 Yes, I even checked BoL...

Kaye Cahs SSCarpal Tunnel Points: 4135 More actions · Answer 4

Ed Wagner (7/8/2016)
Yes, it was an easy one. I admit I was looking for the trick.

Me, too. I read it half a dozen times to make sure I wasn't missing something.

Thanks, Steve.

barry.mcconnell Default port Points: 1447 More actions · Answer 5

Depends if you're talking about the EXEC() function or the EXEC abbreviated version of EXECUTE. As I recall the EXEC() function can't see any variables declared in the calling session because it executes in a separate session. EXEC/EXECUTE operate in the same session they are called in and can see those variables.

There are no facts, only interpretations.
Friedrich Nietzsche

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 6

Easy one. 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Alan Burstein SSC Guru Points: 61141 More actions · Answer 7

Easy one (but I still ran this in SSMS to be safe 😛 : EXECUTE('SELECT 1');)

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

TomThomson SSC Guru Points: 104773 More actions · Answer 8

Revenant (7/8/2016)
George Vobr (7/8/2016)
Ed Wagner (7/8/2016)
Yes, it was an easy one. I admit I was looking for the trick.
+1 😉
Thanks Steve and happy weekend to all.
+1 Yes, I even checked BoL...

Me too - I thought EXEC was an accepted way of writing EXECUTE and then thought "it can't be that easy", looked it up, and found it was that easy.

Tom

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

TomThomson (7/13/2016)
Revenant (7/8/2016)
George Vobr (7/8/2016)
Ed Wagner (7/8/2016)
Yes, it was an easy one. I admit I was looking for the trick.
+1 😉
Thanks Steve and happy weekend to all.
+1 Yes, I even checked BoL...
Me too - I thought EXEC was an accepted way of writing EXECUTE and then thought "it can't be that easy", looked it up, and found it was that easy.

I didn't look it up having seen it all over the place. IMHO there is a difference. It's all aesthetics and preference. I don't like seeing the shorthand version.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

DamianC SSCrazy Eights Points: 8023 More actions · Answer 10

Knew the answer but not sure why there are 2 almost identical commands that do exactly the same thing

- Damian

Luis Cazares SSC Guru Points: 183706 More actions · Answer 11

DamianC (11/15/2016)
Knew the answer but not sure why there are 2 almost identical commands that do exactly the same thing

Those are not 2 commands. It's one command and its short version. You can find different examples on this happening.

CREATE PROC and CREATE PROCEDURE

BEGIN TRAN and BEGIN TRANSACTION

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2