September 20, 2011 at 7:39 am
Kiara (9/20/2011)
Ninja's_RGR'us (9/20/2011)
Well now you can actually sell this as deep dive training! 😀
*groan* Are we going to be drowning in puns now?
for at least another 100 posts :-D.
September 20, 2011 at 7:56 am
Kiara (9/20/2011)
Ninja's_RGR'us (9/20/2011)
Well now you can actually sell this as deep dive training! 😀
*groan* Are we going to be drowning in puns now?
It's sink or swim on The Thread today.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
September 20, 2011 at 8:44 am
L' Eomot Inversé (9/20/2011)
Gianluca Sartori (9/20/2011)
SQL Kiwi (9/20/2011)
Ninja's_RGR'us (9/20/2011)
Try doing ;with () Without any select after the with and you'll see if the engine thinks the statement is complete ;-).Ok:
WITH CHANGE_TRACKING_CONTEXT (0x)
MERGE master.dbo.spt_values AS A USING (VALUES(NULL)) AS V(v) ON NULL = NULL
WHEN MATCHED THEN DELETE;
No SELECT there. I'm with Gail on the semicolon by the way.
That was nasty! I know very few people that can read that query and guess what it does.
On the semicolon, I'm with Gail too.
You mean there are people who think it does something?
Or does not changing any data, not returning any rows, and not influencing what future calls of changetable might return count as doing something? :hehe:
I too am with Gail on the semicolon, although I hate the thing and regard it as symptomatic of not looking after the language properly.
Also (this should be a separate post to help make up the 300, but I'm feeling lazy) I cry FOUL on Paul; the discussion was about CTEs, and WITH CHANGE_TRACKING_CONTEXT (0x) isn't a CTE at all. 😀
I was referring to the MERGE statement.
However, I know lots of people that would bet their house that it deletes some rows.
-- Gianluca Sartori
September 20, 2011 at 9:26 am
Gianluca Sartori (9/20/2011)
L' Eomot Inversé (9/20/2011)
Gianluca Sartori (9/20/2011)
SQL Kiwi (9/20/2011)
Ninja's_RGR'us (9/20/2011)
Try doing ;with () Without any select after the with and you'll see if the engine thinks the statement is complete ;-).Ok:
WITH CHANGE_TRACKING_CONTEXT (0x)
MERGE master.dbo.spt_values AS A USING (VALUES(NULL)) AS V(v) ON NULL = NULL
WHEN MATCHED THEN DELETE;
No SELECT there. I'm with Gail on the semicolon by the way.
That was nasty! I know very few people that can read that query and guess what it does.
On the semicolon, I'm with Gail too.
You mean there are people who think it does something?
Or does not changing any data, not returning any rows, and not influencing what future calls of changetable might return count as doing something? :hehe:
I too am with Gail on the semicolon, although I hate the thing and regard it as symptomatic of not looking after the language properly.
Also (this should be a separate post to help make up the 300, but I'm feeling lazy) I cry FOUL on Paul; the discussion was about CTEs, and WITH CHANGE_TRACKING_CONTEXT (0x) isn't a CTE at all. 😀
I was referring to the MERGE statement.
However, I know lots of people that would bet their house that it deletes some rows.
Depending on your ANSI NULLs setting, it might try.
SET ANSI_NULLS OFF;
CREATE TABLE #T (
ID INT PRIMARY KEY);
INSERT INTO #T (ID)
VALUES (1),(2),(3);
SELECT * FROM #T;
MERGE #T AS A
USING (VALUES(NULL)) AS V(v) ON NULL = NULL
WHEN MATCHED THEN DELETE;
SELECT * FROM #T;
Try that. You might be surprised by the results.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 20, 2011 at 9:31 am
GSquared (9/20/2011)
Gianluca Sartori (9/20/2011)
L' Eomot Inversé (9/20/2011)
Gianluca Sartori (9/20/2011)
SQL Kiwi (9/20/2011)
Ninja's_RGR'us (9/20/2011)
Try doing ;with () Without any select after the with and you'll see if the engine thinks the statement is complete ;-).Ok:
WITH CHANGE_TRACKING_CONTEXT (0x)
MERGE master.dbo.spt_values AS A USING (VALUES(NULL)) AS V(v) ON NULL = NULL
WHEN MATCHED THEN DELETE;
No SELECT there. I'm with Gail on the semicolon by the way.
That was nasty! I know very few people that can read that query and guess what it does.
On the semicolon, I'm with Gail too.
You mean there are people who think it does something?
Or does not changing any data, not returning any rows, and not influencing what future calls of changetable might return count as doing something? :hehe:
I too am with Gail on the semicolon, although I hate the thing and regard it as symptomatic of not looking after the language properly.
Also (this should be a separate post to help make up the 300, but I'm feeling lazy) I cry FOUL on Paul; the discussion was about CTEs, and WITH CHANGE_TRACKING_CONTEXT (0x) isn't a CTE at all. 😀
I was referring to the MERGE statement.
However, I know lots of people that would bet their house that it deletes some rows.
Depending on your ANSI NULLs setting, it might try.
SET ANSI_NULLS OFF;CREATE TABLE #T (
ID INT PRIMARY KEY);
INSERT INTO #T (ID)
VALUES (1),(2),(3);
SELECT * FROM #T;
MERGE #T AS A
USING (VALUES(NULL)) AS V(v) ON NULL = NULL
WHEN MATCHED THEN DELETE;
SELECT * FROM #T;
Try that. You might be surprised by the results.
Damn, you stole my evil QOTD :-D.
That would have been a major complaint generator 😉
September 20, 2011 at 9:37 am
Ninja's_RGR'us (9/20/2011)
Damn, you stole my evil QOTD :-D.That would have been a major complaint generator 😉
Uh! I'm trying to figure out what would SanDroid think of it...
-- Gianluca Sartori
September 20, 2011 at 9:41 am
ANSI_NULLS QotDs[/url] are sooooo last year!
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
September 20, 2011 at 9:43 am
Gianluca Sartori (9/20/2011)
Ninja's_RGR'us (9/20/2011)
Damn, you stole my evil QOTD :-D.That would have been a major complaint generator 😉
Uh! I'm trying to figure out what would SanDroid think of it...
He might actually be ok, aside from thinking it's totally useless in the field.
September 20, 2011 at 9:44 am
September 20, 2011 at 9:53 am
GSquared (9/20/2011)
Depending on your ANSI NULLs setting, it might try.
SET ANSI_NULLS OFF;CREATE TABLE #T (
ID INT PRIMARY KEY);
INSERT INTO #T (ID)
VALUES (1),(2),(3);
SELECT * FROM #T;
MERGE #T AS A
USING (VALUES(NULL)) AS V(v) ON NULL = NULL
WHEN MATCHED THEN DELETE;
SELECT * FROM #T;
Try that. You might be surprised by the results.
OK, so I guess now I owe you my house. :unsure:
-- Gianluca Sartori
September 20, 2011 at 9:54 am
Ninja's_RGR'us (9/20/2011)
What's up with the new signature Tom? It sure looks like french but I'm pretty sure it's not!
It's French. ADB = Adminstrateur de Base de Données, which was used by colleagues in Bull in the early 90s much as we would use DBA. I suppose the plural of ABD ought to be AsBD, not ADBs, but that looks wrong to me. "Le Blason" is a song (possibly not suitable for a family website like this one :rolleyes:) written between 40 and 50 years ago by Georges Brassens which 20 years ago was much loved by French computer people (and by me) - it was a standing joke that all developers (including the female ones, despite "masculins" in the sig) could sing it, even those who couldn't hold any other tune in a bucket.
It was of course a blason (ie an eulogy or a satire in verse form) on the subject of something not covered in Marot's collection Les Blasons Anatomiques Du Corps Féminin (early 16th century) or by Marot's own poem of that nature, which I don't think he included in the collection (but don't remember for sure - it's ages since looked at early modern French stuff). There were a few versions of it, but the words of the version everyone remembers can be found at http://pedagogie2.ac-reunion.fr/lyvergerp/francais/blason/Brassens.htm or if you prefer it with spelling and other errors on many other websites. I think there's a site with all Brassen's variations of the lyrics somewhere too, but not sure it's accuracy is reliable.
The subject of the song is never named in the song, but we are told that it has several names, all unacceptable, the worst of which is "un petit vocable de trois lettres pas plus familier coutumier", that "[il] porte le même nom qu'une foule de gens" and shame is cast upon whoever spitefully and venomously "dota du même terme en son fiel venimeux ce grand ami de l'homme et la cinglante injure". So it's pretty obvious what it is.:-D (unless your French is non-existent or nearly)
Tom
September 20, 2011 at 9:59 am
L' Eomot Inversé (9/20/2011)
Ninja's_RGR'us (9/20/2011)
What's up with the new signature Tom? It sure looks like french but I'm pretty sure it's not!The subject of the song is never named in the song, but we are told that it has several names, all unacceptable, the worst of which is "un petit vocable de trois lettres pas plus familier coutumier", that "[il] porte le même nom qu'une foule de gens" and shame is cast upon whoever spitefully and venomously "dota du même terme en son fiel venimeux ce grand ami de l'homme et la cinglante injure". So it's pretty obvious what it is.:-D (unless your French is non-existent or nearly)
I'm from Quebec so my french is far from non-existent!
September 20, 2011 at 10:03 am
Brandie Tarvin (9/20/2011)
Whoot! So, who wants to go to Curacoa?http://www.sqlsaturday.com/eventhome.aspx - SQL Saturday 103
Trying to work that into the plans. Maybe SQLCruise should coordinate something with Roy?
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
September 20, 2011 at 10:05 am
GilaMonster (9/20/2011)
Brandie Tarvin (9/20/2011)
CTEs (i.e. ;WIth () ... SELECT ) are single statements in this context, yes?<pedantic>
CTEs don't start with a ';', no more than an english sentence starts with a '.'.
Rather than using a ';', use a BEGIN...END.
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
September 20, 2011 at 10:05 am
Gianluca Sartori (9/20/2011)
L' Eomot Inversé (9/20/2011)
Gianluca Sartori (9/20/2011)
SQL Kiwi (9/20/2011)
Ninja's_RGR'us (9/20/2011)
Try doing ;with () Without any select after the with and you'll see if the engine thinks the statement is complete ;-).Ok:
WITH CHANGE_TRACKING_CONTEXT (0x)
MERGE master.dbo.spt_values AS A USING (VALUES(NULL)) AS V(v) ON NULL = NULL
WHEN MATCHED THEN DELETE;
No SELECT there. I'm with Gail on the semicolon by the way.
That was nasty! I know very few people that can read that query and guess what it does.
On the semicolon, I'm with Gail too.
You mean there are people who think it does something?
Or does not changing any data, not returning any rows, and not influencing what future calls of changetable might return count as doing something? :hehe:
I too am with Gail on the semicolon, although I hate the thing and regard it as symptomatic of not looking after the language properly.
Also (this should be a separate post to help make up the 300, but I'm feeling lazy) I cry FOUL on Paul; the discussion was about CTEs, and WITH CHANGE_TRACKING_CONTEXT (0x) isn't a CTE at all. 😀
I was referring to the MERGE statement.
However, I know lots of people that would bet their house that it deletes some rows.
If ansi nulls are off it can. So you know lots of people who allow code to run with ansi nulls off? That's scary! :sick:
Tom
Viewing 15 posts - 30,106 through 30,120 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply