Category: Dev

SQL Server meta-development (with regular expressions and more)

Post author By Jen McCown
Post date October 13, 2021
Categories In Advanced, Applied SQL, Dev, Intermediate, Random helpfulness, RegEx, sql server, sqlserverpedia-syndication, SSC, Tech and Learning, TSQL

Yesterday, I had about 30 existing queries (and some multi-query processes) that I needed to turn into individual stored procedures. I could, of course, go through the entire list of queries manually, crafting CREATE PROC statements and so on. But what’s the fun in that? As much as possible, I like to use scripts on […]

Three big reasons T-SQL still beats the GUI – a MinionWare snippet

Post author By Jen McCown
Post date May 27, 2020
Categories In All Things MidnightDBA, Beginner, Dev, Intermediate, sql server, sqlserverpedia-syndication, SSC, Tech and Learning, TSQL

We like code better than mouse clicks for three basic reasons: T-SQL lets you do more. T-SQL lets you share your process. T-SQL lets you keep a record.

T-SQL: How many bananas tall are you?

Post author By Jen McCown
Post date September 6, 2018
Categories In Beginner, Dev, Fluffy Stuff, Random helpfulness, sqlserverpedia-syndication, SSC, Tech and Learning
4 Comments on T-SQL: How many bananas tall are you?

So today, this happened: Now I suddenly want to know how many bananas tall I am… https://t.co/7geupBzXDj — MidnightDBA (@MidnightDBA) September 6, 2018 And I realized it would be really easy to find that out, via a calculator, or – more amusingly – with SQL: DECLARE @feet FLOAT = 5.0, @inches FLOAT = 5.0, @bananaIN […]