OPENQUERY-2

Question

OPENQUERY-2

Carlo Romagnano

SSC-Insane

Points: 22680
More actions
March 23, 2014 at 12:40 pm

#305573

Comments posted to this topic are about the item OPENQUERY-2
March 24, 2014 at 2:26 am

This was removed by the editor as SPAM
March 24, 2014 at 3:08 am

This was removed by the editor as SPAM

Viewing 11 posts - 1 through 10 (of 10 total)

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

free_mascot One Orange Chip Points: 27169 More actions · Answer 1

Interesting question, thanks Carlo.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

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

Nice follow-up question, thanks.

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

Umer Akram SSC-Insane Points: 22209 More actions · Answer 3

Koen Verbeeck (3/24/2014)
Nice follow-up question, thanks.

+1, Thanks for sharing

Carlo Romagnano SSC-Insane Points: 22680 More actions · Answer 4

Stewart "Arturius" Campbell (3/24/2014)
Interesting question, thanks Carlo
thought the lack of a semi-colon between deleted.* and COMMIT would cause an error.
Goes to show...

The lack of a semi-colon causes or would cause an error?

sknox SSChampion Points: 12388 More actions · Answer 5

Stewart "Arturius" Campbell (3/24/2014)
Carlo Romagnano (3/24/2014)
Stewart "Arturius" Campbell (3/24/2014)
Interesting question, thanks Carlo
thought the lack of a semi-colon between deleted.* and COMMIT would cause an error.
Goes to show...
The lack of a semi-colon causes or would cause an error?
As stated, I thought it would cause an error, but it did not.

Oh, I thought you said "though", though you said "thought."

As far as I know, the only times when SQL Server requires a ; between statements is when there's a statement before a "WITH" CTE expression (to differentiate from the possible "WITH" clause for some statements) or at the end of a "MERGE" statement.

Hany Helmy SSChampion Points: 13921 More actions · Answer 6

You made it easy by making 'Commit' in bold and capital letters, but anyway thanks Carlo for the good 2 openquery questions.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 7

Interesting one, thank you for post, Carlo.

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

zerko SSCommitted Points: 1524 More actions · Answer 8

I had trouble getting my head around the "OPENQUERY-1" question a few days back, but found this question a little easier thanks to the research and discussion of that one.

... I notice, though, that similar to the first "OPENQUERY" QOD question, the answer '-1' gets 3% of the total answers for this QOD.

What I'm having trouble getting my head around now is - has anyone figured out what a return of -1 rows is going to look like? 😛