Which query will give an error?

Question

Post reply

Which query will give an error?

Vimal Lohani

SSCommitted

Points: 1650
More actions
August 14, 2014 at 11:04 pm

#298112

Comments posted to this topic are about the item Which query will give an error?
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
August 15, 2014 at 2:52 am

This was removed by the editor as SPAM

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

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

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

Good Knowledge base question. Thanks for sharing 🙂

Ed Wagner SSC Guru Points: 287024 More actions · Answer 2

Thanks for the question and have a nice weekend.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 3

Thank you for the post, Vimal, good one.

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

LearnModeOn SSC Enthusiast Points: 154 More actions · Answer 4

LearnModeOn

SSC Enthusiast

Points: 154

August 15, 2014 at 6:57 am

#1738383

i guessed correctly

select this!!

sestell1 SSChampion Points: 10230 More actions · Answer 5

sestell1

SSChampion

Points: 10230

August 15, 2014 at 7:04 am

#1738386

XML... yuck. :sick: :laugh:

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

sestell1 (8/15/2014)
XML... yuck. :sick: :laugh:

+1

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

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 7

SQLRNNR (8/15/2014)
sestell1 (8/15/2014)
XML... yuck. :sick: :laugh:
+1

hmmm... interesting...

I know the feeling of "yuck"... but never used with "xml"... so out of curiosity anybody care to shed some light by providing in-depth details? 🙂

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

Revenant SSC-Forever Points: 42467 More actions · Answer 8

I have to produce XML quite often whether I like it or not.

Thanks, Vimal!

TomThomson SSC Guru Points: 104773 More actions · Answer 9

Nice straightforward question (although the subject matter - XML - is not nice).

By choice use I never use XML, so it's only the odd QotD that keeps me from forgetting everything about it.

Tom

Hany Helmy SSChampion Points: 13921 More actions · Answer 10

sestell1 (8/15/2014)
XML... yuck. :sick: :laugh:

Definitly yuck 🙂

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 11

Thank you for the timely question Vimal, XML is a topic that definitely needs more coverage, especially when the current SQL Server's capabilities provide some of the best tools for the job;-)

😎

Hany Helmy SSChampion Points: 13921 More actions · Answer 12

Had to try this as I have no hands-on experience on XML part in SQL Server.

This question reminds me of the 70-461 exam questions 🙂

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 13

Hany Helmy (8/17/2014)
Had to try this as I have no hands-on experience on XML part in SQL Server.
This question reminds me of the 70-461 exam questions 🙂

We all have to start somewhere:-)

Must admit that few of the comments remind me of the early years of mobile phones, "who will ever need one?"

😎