T-SQL Oddities

Question

T-SQL Oddities

Viewing 15 posts - 16 through 30 (of 33 total)

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

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 1

Just to be cruel... go into query options (on someone else's machine) and change the batch separator from "GO" to "SELECT".

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

spaghettidba SSC Guru Points: 105732 More actions · Answer 2

You definitely have to check out this[/url] and this.

Very funny.

-- Gianluca Sartori

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

The Dixie Flatline (3/24/2010)
Just to be cruel... go into query options (on someone else's machine) and change the batch separator from "GO" to "SELECT".

Awesome! Cannot wait to try that...:-D

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Garadin One Orange Chip Points: 29613 More actions · Answer 4

The Dixie Flatline (3/24/2010)
Just to be cruel... go into query options (on someone else's machine) and change the batch separator from "GO" to "SELECT".

And what opportune timing, with April Fool's day right around the corner. Now I just need to figure out how to get onto my co-worker's computer without him knowing...

Seth Phelabaum

Consistency is only a virtue if you're not a screwup. 😉

Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

WayneS SSC Guru Points: 95460 More actions · Answer 5

Gianluca Sartori (3/24/2010)
You definitely have to check out this[/url] and this.
Very funny.

I knew I had seen this, but I thought it was on this site. Thanks for the links.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

The Dixie Flatline (3/24/2010)
Just to be cruel... go into query options (on someone else's machine) and change the batch separator from "GO" to "SELECT".

That is totally rotten.

I like it.

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

Gianluca Sartori (3/24/2010)
You definitely have to check out this[/url] and this.
Very funny.

Ah yes, it is all coming back to me now. I remember a blog about tibbling and then reading that same article by Phil. I think it would be quite funny to name the tables something like those characters.

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

John McC Hall of Fame Points: 3410 More actions · Answer 8

At least in 2k8 we have Intellisense otherwise it might be a tad difficult remembering which symbolic (or should that be shambolic) table is which 😉

Now was it ~¬.¬~ or ¬~.~¬

-------------------------------------------------------------------------
Normal chaos will be resumed as soon as possible. :crazy:

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

John McC (3/25/2010)
At least in 2k8 we have Intellisense otherwise it might be a tad difficult remembering which symbolic (or should that be shambolic) table is which 😉
Now was it ~¬.¬~ or ¬~.~¬

neither. It was ¿¿?¿¿

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

John McC Hall of Fame Points: 3410 More actions · Answer 10

Ah.

That would explain why I couldn't find the b@##y st??%d table

-------------------------------------------------------------------------
Normal chaos will be resumed as soon as possible. :crazy:

SQLRNNR SSC Guru Points: 281334 More actions · Answer 11

John McC (3/26/2010)
Ah.
That would explain why I couldn't find the b@##y st??%d table

I think so.

Another reason could be that the table changes names daily. Guess what it is today.

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

Garadin One Orange Chip Points: 29613 More actions · Answer 12

I'm almost inspired to create a whole database with "picture text" table names like >^.^< and <('.'<).

...

Almost.

Seth Phelabaum

Consistency is only a virtue if you're not a screwup. 😉

Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 13

Garadin (3/26/2010)
I'm almost inspired to create a whole database with "picture text" table names like >^.^< and <('.'<).
...
Almost.

That would be a fun database and could be quite a fun blog or presentation.

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

Jeff Moden SSC Guru Points: 1004318 More actions · Answer 14

As a bit of a side bar, my favorite name for a Temp table used to resolve a difficult problem is... you guessed it... #MyHead. 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

TomThomson SSC Guru Points: 104773 More actions · Answer 15

Peter Brinkhaus (3/23/2010)
Note that variable names @, @@ or names starting with @@ are deprecated in SQL 2008. See http://msdn.microsoft.com/en-us/library/ms143729.aspx:
Do not use @ or @@ or names that begin with @@ as identifiers.
Peter

And # and ## as temp table and stored proc names are going too, either someone at MS has no sense of humour or they are making an attempt to prevent people writing ridiculously incomprehensible code, which would be bound to fail because all good programmers can write incomprehensible code in any useful language, and bad programmers can't write any other sort.

Tom