Avoid dynamic SQL

Question

Avoid dynamic SQL

Viewing 15 posts - 46 through 60 (of 79 total)

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

Paul White SSC Guru Points: 150467 More actions · Answer 1

Michael Valentine Jones (2/27/2010)
Cutting off your head to avoid the pain is another possible solution. Again, most would consider it suboptimal.

I am just a mess of giggles here...:laugh: :laugh: :laugh: :laugh: :laugh:

"Again, most would consider it suboptimal."

snigger

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

,,,

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

...

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Kingston Dhasian SSCoach Points: 19799 More actions · Answer 4

People that wear hats are all hat & no cow & they have no hair; they are bold!!

Before commenting on other's profile have a look at your's buddy. And please have a spell check before you post..

Kingston Dhasian

How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/

Paul White SSC Guru Points: 150467 More actions · Answer 5

Welsh Corgi
I regret if I came across as negative but the forum members that are crying that I am being a dick should closley examine themselves

I said "don't be a dick", and that advice stands.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 6

...

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 7

I did not mean to get personal or offend anyone.

No excuse for being a dick... I have not been myself.

I'm going through the toughest time in my life since I lost my little sister due to a negligent doctor.

I do not expect any of you to forgive me but I will pray to God and ask for forgiveness. 🙁

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

Welsh Corgi (2/27/2010)
I did not mean to get personal or offend anyone.
No excuse for being a dick... I have not been myself.
I'm going through the toughest time in my life since I lost my little sister due to a negligent doctor.
I do not expect any of you to forgive me but I will pray to God and ask for forgiveness. 🙁

Unfortunate about your sister.

As for the community, most here will forgive. Don't take criticism or suggestions about using one solution over another or suggestions that information you have given is incorrect. Verify sources and answers and learn while doing it. If no offense is intended, then don't take any offense.

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

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 9

Unfortunately I exercised very poor judgement.

I reexamined the post this morning in detail and I wish that I had accepted the suggestions provided to me.

Regrets 🙁

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

No Name 4 U (2/27/2010)
Unfortunately I exercised very poor judgement.
I reexamined the post this morning in detail and I wish that I had accepted the suggestions provided to me.
Regrets 🙁

I would hope that changing your avatar and community pen-name is not related to this thread. The best thing to do is to know that a mistake was made, and then to learn from it. That is how the community grows, we learn from our mistakes, apologize where necessary, and fess up to a mistake. That will gain more respect. That will also show a greater intestinal fortitude on your part.

Edit: Fixed wording

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

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 11

I'm sorry, I did not understand what you meant by the following:

-----------------------------------------------------------------------------------

I would hope that changing your avatar and community pen-name in relation to this

-----------------------------------------------------------------------------------

WHat are you saying that I should or should not do?

Regards.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Paul White SSC Guru Points: 150467 More actions · Answer 12

Welsh Corgi (2/27/2010)
I did not mean to get personal or offend anyone.

Well you did, but I for one won't hold it against you. Let's move on.

Welsh Corgi (2/27/2010)
No excuse for being a dick... I have not been myself.

So perhaps now is not the best time to be posting? Take a break and come back when you are yourself again. You will be welcome.

Paul

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

RBarryYoung SSC Guru Points: 143329 More actions · Answer 13

Welsh, et. al.:

I have been out the last day or so, and I sure am sorry that I missed this golden opportunity for self-promotion (:-)), as I have actually written quite a bit on this subject. Here are some links, for those who are still interested:

Recent thread with some extended explanations and links by me:

http://www.sqlservercentral.com/Forums/FindPost868539.aspx

List of Dynamic SQL and SQL Injection atricles at my blog:

http://movingsql.com/dnn/Home/tabid/125/BlogID/261/Default.aspx

Presentation & Code Kit on using dynamic SQL without Injection:

http://movingsql.com/dnn/LinkClick.aspx?fileticket=pa1HXFdJ5Bs%3d&tabid=125&mid=911

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Paul White SSC Guru Points: 150467 More actions · Answer 14

Glad to hear you are feeling better Barry!

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 15

Jeff Moden (2/26/2010)
Heh... poor ol' dynamic SQL... nobody loves it anymore.

Not true!! I am actually a great fan of it and use it where appropriate, which is far more often than most people would expect. 😎

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service