T-SQL Tuesday #155 –The Dynamic Code Invitation

Posted on October 6, 2022 by way0utwest

tsqltuesdayApologies for the late invitation. A minor snafu has me hosting again.

This is the monthly blog party where someone hosts and you all write a response. I’d like to think this is one where lots of you have a story or a situation that worked out. Write a post on 11 Oct and post a comment here.

The Invitation

I saw a post recently where someone noted they used Excel to help build dynamic SQL for their job. I thought that was a) creative, and b) similar to something I’ve done. In fact, that will be my post for this month.

However, while many of the experts decry dynamic SQL as a poor way of solving problems, it is not going away. In fact, it works really well for many situations and problems, albeit not necessarily a high volumes of data. There also are security concerns.

My invitation this month is to write about producing SQL dynamically in some way. Let us know about any of these things:

  • a problem you solved
  • a creative use of technology to build SQL
  • security concerns
  • a place where dynamic SQL failed you
  • a way to convert dynamic SQL to something cleaner
  • anything else that relates to code producing code

The Rules

Only a few rules.

  • publish on 11 Oct 2022 sometime.
  • use the logo above and link back to this post
  • leave a comment or trackback/pingback here
  • Use the #tsql2sday hashtag to tag your post on Twitter, LinkedIn, etc.
  • Encourage others to blog

That’s it. Have fun and I look forward to reading your responses.

If you want to host, ping me on twitter (@way0utwest) or LinkedIn or email or anything really.

About way0utwest

Editor, SQLServerCentral
This entry was posted in Blog and tagged , . Bookmark the permalink.

29 Responses to T-SQL Tuesday #155 –The Dynamic Code Invitation

  1. Pingback: T-SQL Tuesday #155 – The Dynamic Code Invitation – T-SQL Tuesday

  3. Pingback: T-SQL Tuesday #155 – The Dynamic Code Invitation – Andy Brownsword

  5. Richard Swinbank says:
    October 11, 2022 at 3:09 am

    Hey Steve, thanks for hosting this month – my contribution’s at https://richardswinbank.net/blog/metadata-driven-sql-code-generation. Richard

    Like

  6. Pingback: T-SQL Tuesday: Dynamic SQL, The Data Type – Erik Darling Data

  7. Pingback: Get Core SQLServer Health Metrics using Dynamic SQL - Ajay Dwivedi's SQL Server Blog

  8. Pingback: T-SQL Tuesday #155–Using Dynamic SQL for SQLCMD | Voice of the DBA

  9. Ajay Dwivedi says:
    October 11, 2022 at 7:55 am

    Hi Steve! This is how I am using dynamic sql to collect remote SQL Server Health Metrics.
    https://ajaydwivedi.com/performance-tuning/get-core-sqlserver-health-metrics-using-dynamic-sql/?swcfpc=1

    Like

  10. Pingback: T-SQL Tuesday #155 –The Dynamic Code Invitation – SQLDoubleG

  13. Pingback: T-SQL Tuesday 155, Dynamic SQL – Reitse's blog

  16. josh says:
    October 11, 2022 at 3:18 pm

    Thanks for hosting: I clearly had something to get out of my system…

    https://accitentionaldba.com/posts/2022/10/tsqltuesday155/

    Like

  17. Pingback: T-SQL Tuesday #155 – Write to Read, Not to Run – No Column Name

  18. Gerard Jaryczewski says:
    October 11, 2022 at 3:38 pm

    What a wonderful topic for telling stories… https://sqlrebel.blogspot.com/2022/10/show-me-everything.html

    Like

  20. Pingback: Generating Code to Run Across All Databases via Dynamic SQL – Curated SQL

  21. Nigel Foulkes-Nock says:
    October 15, 2022 at 8:11 am

    Thanks for hosting – the time difference in Wales is getting worse! https://www.nigeldba.com/t-sql-tuesday-155-the-dynamic-code-invitation

    Like

  22. Pingback: T-SQL Tuesday #155 –The Dynamic Code Invitation – nigelDBA

  23. Pingback: #tsql2sday: Dynamic SQL You Don’t Have to Write – Kevin Martin

  24. Pingback: #tsql2sday: Dynamic SQL You Don’t Have to Write – Kevin Martin

Comments are closed.