Table variable - 2

Question

Table variable - 2

Ron McCullough

SSC Guru

Points: 63877
More actions
November 14, 2011 at 8:36 pm

#260031

Comments posted to this topic are about the item Table variable - 2
If everything seems to be going well, you have obviously overlooked something.
Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]
November 15, 2011 at 12:31 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 23 total)

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Thanks Ron.

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

iBar SSCertifiable Points: 5872 More actions · Answer 2

Thanks.

http://msdn.microsoft.com/en-us/library/ms188927.aspx

Iulian -207023 SSCertifiable Points: 7639 More actions · Answer 3

Iulian -207023

SSCertifiable

Points: 7639

November 15, 2011 at 12:19 am

#1407641

Thanks for the question

Iulian

Ant-Green SSC Guru Points: 113507 More actions · Answer 4

good question, but in my morning daze i forgot to click @qoda is created, doh, epic fail on my part

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 5

Good questione, but the explanation is a bit too short. I assume Ron intended to write "You cannot create a named constraint on a table variable". On temporary and permanent tables, creating names constraints is supported (though it's not really a good idea for temporary tables).

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Gazareth One Orange Chip Points: 27737 More actions · Answer 6

Gazareth

One Orange Chip

Points: 27737

November 15, 2011 at 4:41 am

#1407744

Good question, agree with Hugo's points.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 7

I love the new question style Ron! Nice way to do this :cool:.

Thomas Abraham SSChampion Points: 10761 More actions · Answer 8

Thanks for the question. I, too, like the question format.

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

Ron McCullough SSC Guru Points: 63877 More actions · Answer 9

Hugo Kornelis (11/15/2011)
Good questione, but the explanation is a bit too short. I assume Ron intended to write "You cannot create a named constraint on a table variable". On temporary and permanent tables, creating names constraints is supported (though it's not really a good idea for temporary tables).

I kept my explanation deliberately short, hopping that people would read the excellent article here on SSC by Wayne Sheffield, and thus learn a great deal more than I could say in a few words.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Britt Cluff SSCertifiable Points: 5083 More actions · Answer 10

Thanks for the question.

http://brittcluff.blogspot.com/

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

I like this question too. Table variables often get a poor press, but not allowing named constraints (which could well conflict for objects in tempdb) is one thing I like about them. The ability to create named constraints on #temp tables is almost certainly only there for backward compatibility.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Ron McCullough SSC Guru Points: 63877 More actions · Answer 12

Ninja's_RGR'us (11/15/2011)
I love the new question style Ron! Nice way to do this :cool:.

Why thank you for the compliment, it made my morning joyous.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Bob Razumich SSCrazy Points: 2142 More actions · Answer 13

Good question, thank you.

I will "third" liking your question format. It forces us to actually type the code if we want to cheat that way before answering the question.

Or conversely, if lazy and not feeling like typing, doing research.

Sorry folks, I'm sure all of us have done that at least once - I freely admit that myself.