Exercise to practise SQL

Question

Exercise to practise SQL

Viewing 14 posts - 31 through 43 (of 43 total)

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

Jeff Moden SSC Guru Points: 1004409 More actions · Answer 1

I'm still looking forward to the sky writing...

--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)

Steve Jones - SSC Editor SSC Guru Points: 736494 More actions · Answer 2

Apparently it's not working: http://146.176.166.22/~andrew/s2/execsql.pl Suffered: 500 Internal Server Error

Those interactive ones are ripe for SQL Injection attacks.

mohamed.babydoctors SSC Journeyman Points: 87 More actions · Answer 3

can you please send me the book to email: mohamed.babydoctors@gmail.com

GeorgeCopeland SSCertifiable Points: 6997 More actions · Answer 4

yes and please, after emailing, please skywrite your book over Dallas. http://www.dallascityhall.com/

tehanar SSC Journeyman Points: 93 More actions · Answer 5

Hi..Joe..can you send that book to my email adress?..Thanks in advance..

My email: Tehanar@mail.ru

diegocroitoru SSC Enthusiast Points: 131 More actions · Answer 6

Hello,

I have been using http://www.sql-ex.ru/.

Great site. Full of excersises with varying difficulty.

Joe,

I 'll buy your book. Thanks for your note.

And, I strongly disagree asking Joe for the scripts and text. I don't believe we are being respectful enough.

Pawan Kumar Khowal Old Hand Points: 371 More actions · Answer 7

You can find some good puzzles @

http://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/

Regards,
Pawan Kumar Khowal
MSBISkills.com

Pawan Kumar Khowal Old Hand Points: 371 More actions · Answer 8

Check out puzzles @

http://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/

Regards,
Pawan Kumar Khowal
MSBISkills.com

Jeff Moden SSC Guru Points: 1004409 More actions · Answer 9

pawankkmr 41145 (4/30/2015)

Check out puzzles @

http://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/%5B/quote%5D

That's pretty cool. One recommendation would be that if anyone wants to use XML to do a split, you might not want to work for them. 😀

My other recommendation would be that it would really be helpful to neophytes if you provided code to generate, say, a million rows of sample data so that people can also learn about how to make such things fast.

--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)

svrtechnologies.com Grasshopper Points: 13 More actions · Answer 10

Hi,
Can you please give us the name , author, ISBN of the book so that we can buy it.

Thanks.

Transact-SQL Training

Jeff Moden SSC Guru Points: 1004409 More actions · Answer 11

svrtechnologies.com - Wednesday, April 4, 2018 10:51 PM
Hi,
Can you please give us the name , author, ISBN of the book so that we can buy it.
Thanks.
(link deleted)

This is just spam and has been marked as such.

--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)

ManicStar SSCoach Points: 17992 More actions · Answer 12

ManicStar

SSCoach

Points: 17992

April 5, 2018 at 7:11 am

#1985657

brraaainnns... (zombie thread)

Jeff Moden SSC Guru Points: 1004409 More actions · Answer 13

ManicStar - Thursday, April 5, 2018 7:11 AM
brraaainnns... (zombie thread)

Yep... and adding spam to the brains only makes them taste worse. 😀

--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)

Sean Lange SSC Guru Points: 286590 More actions · Answer 14

Jeff Moden - Thursday, April 5, 2018 8:38 AM
ManicStar - Thursday, April 5, 2018 7:11 AM
brraaainnns... (zombie thread)
Yep... and adding spam to the brains only makes them taste worse. 😀

No kidding. It totally ruins otherwise perfectly good spam. 😉

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/