Creating a Stored Procedure

Question

Post reply

Creating a Stored Procedure

Steve Jones - SSC Editor

SSC Guru

Points: 734434
More actions
March 6, 2019 at 8:07 pm

#77212

Comments posted to this topic are about the item Creating a Stored Procedure

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

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

HappyGeek SSCoach Points: 18726 More actions · Answer 1

HappyGeek

SSCoach

Points: 18726

March 6, 2019 at 11:17 pm

#2023759

Nice question thanks Steve.

...

Stewart "Arturius" Campbell SSC Guru Points: 72497 More actions · Answer 2

Nice easy one, thanks Steve

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Victor Kirkpatrick Hall of Fame Points: 3672 More actions · Answer 3

One of the absolute worst features ever of SQL Server. At the very least, there should be an option to turn this off and make it optional. Let's make everyone think the procedure is fine and dandy, only to be burned later at run time.

Steve Jones - SSC Editor SSC Guru Points: 734434 More actions · Answer 4

I agree. I'm only doing these questions so people are aware if they run into the strange situation.

Jeff Moden SSC Guru Points: 1003859 More actions · Answer 5

Steve Jones - SSC Editor - Thursday, March 7, 2019 7:11 AM
I agree. I'm only doing these questions so people are aware if they run into the strange situation.

Understood. It's also pretty tough on the dependency lists (IIRC). Might make another good QOD on the subject.

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 6

Used to be, iirc, that SQL Server would warn you when the object was created that there was a missing dependency.

Sean Lange SSC Guru Points: 286573 More actions · Answer 7

Great question and love the red herrings. They all sound like feasible options.

_______________________________________________________________

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/

Steve Jones - SSC Editor SSC Guru Points: 734434 More actions · Answer 8

Jeff Moden - Thursday, March 7, 2019 7:18 AM
Understood. It's also pretty tough on the dependency lists (IIRC). Might make another good QOD on the subject.

If you want to write some questions...

HappyGeek SSCoach Points: 18726 More actions · Answer 9

Steve Jones - SSC Editor - Thursday, March 7, 2019 9:39 AM
If you want to write some questions...

.... They would be insightful and informative, no doubt!

...

Jeff Moden SSC Guru Points: 1003859 More actions · Answer 10

Steve Jones - SSC Editor - Thursday, March 7, 2019 9:39 AM
Jeff Moden - Thursday, March 7, 2019 7:18 AM
Understood. It's also pretty tough on the dependency lists (IIRC). Might make another good QOD on the subject.
If you want to write some questions...

It's funny how paths of things seem to merge... there are a couple of things that I've been considering to submit. You typically won't find the answers in Books Online, though. It that ok?

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

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

BTW... I've said it in the past and I have to say it again... Thank you, Mr. Jones, for all that you've done and continue to do for the denizens of this site. Going a full day without reading something that you've written causes withdrawal symptoms.

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

David Burrows SSC Guru Points: 65138 More actions · Answer 12

Jeff Moden - Thursday, March 7, 2019 4:25 PM
BTW... I've said it in the past and I have to say it again... Thank you, Mr. Jones, for all that you've done and continue to do for the denizens of this site. Going a full day without reading something that you've written causes withdrawal symptoms.

And the same goes for you as well Jeff 😀

Far away is close at hand in the images of elsewhere.
Anon.

Steve Jones - SSC Editor SSC Guru Points: 734434 More actions · Answer 13

Jeff Moden - Thursday, March 7, 2019 4:23 PM
It's funny how paths of things seem to merge... there are a couple of things that I've been considering to submit. You typically won't find the answers in Books Online, though. It that ok?

Yes, or submit a question and a PR for BOL (or I can)

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

David Burrows - Friday, March 8, 2019 1:59 AM
Jeff Moden - Thursday, March 7, 2019 4:25 PM
BTW... I've said it in the past and I have to say it again... Thank you, Mr. Jones, for all that you've done and continue to do for the denizens of this site. Going a full day without reading something that you've written causes withdrawal symptoms.
And the same goes for you as well Jeff 😀

Heh... thanks, David. I guess I need to put my shoulder to the wheel and start writing again.

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