Table Variable

Question

Post reply

Table Variable

Viewing 13 posts - 16 through 27 (of 27 total)

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

Jamsheer Ten Centuries Points: 1136 More actions · Answer 1

Nice question Sreepathi, Thanx for the easy point 🙂

sestell1 SSChampion Points: 10230 More actions · Answer 2

Excellent question. I remember this causing me a great deal of confusion when I first ran into it.

EL Jerry SSCertifiable Points: 7063 More actions · Answer 3

Great question, made me think and re-read twice.

"El" Jerry.

"A watt of Ottawa" - Gerardo Galvan

To better understand your help request, please follow these best practices.[/url]

Narud SSCrazy Points: 2837 More actions · Answer 4

Not all the rules have an exception, unless you use table variables in transactions 😀

I'm glad I did my homework about table variables when I studied that theme.

tilew-948340 Hall of Fame Points: 3431 More actions · Answer 5

Do you want to laugth at someone? Well, here you have the opportunity: I got it wrong because for me 2005 and 2012 were "date", not money and because the second one was null, so the answer I choose, was zero 🙂

I don't drink coffee... maybe I should start 🙂

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

Nice question

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

Rob Schripsema SSCertifiable Points: 7469 More actions · Answer 7

Rob Schripsema

SSCertifiable

Points: 7469

September 4, 2012 at 10:23 am

#1533390

Great question!

Rob Schripsema
Propack, Inc.

Ken SSCoach Points: 17191 More actions · Answer 8

Nice question, was doing too many things at once and chose the wrong answer. Doh!

(Bob Brown) SSCrazy Points: 2705 More actions · Answer 9

(Bob Brown)

SSCrazy

Points: 2705

September 5, 2012 at 4:06 am

#1533712

Very good question. Thanks.

JayK SSCrazy Points: 2679 More actions · Answer 10

Great question - was not aware of that issue with SQL variables at all. Leanred something very important this morning!:cool:

Ken Hiatt SSC-Addicted Points: 469 More actions · Answer 11

Wrong here. Probably because I don't know anything about table variables, or try/catch for that matter. One of these days I'll move beyond Visual FoxPro 6. 😀

Paul White SSC Guru Points: 150467 More actions · Answer 12

Very good question, thanks.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

udayroy15 Ten Centuries Points: 1076 More actions · Answer 13

Mainly...........

The "ROLLBACK TRANSACTION" does not work with table variables.