If anyone used tools like Gee-Pee-Tee for writing T-SQL (MS SQL server)?

Question

If anyone used tools like Gee-Pee-Tee for writing T-SQL (MS SQL server)?

Viewing 7 posts - 16 through 21 (of 21 total)

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

VAI SSC Enthusiast Points: 185 More actions · Answer 1

Can you feed a DDL with a few tables and views to SQLPROMPT and then ask it to write a complex (or simple, for that matter, ) multi-join query using those tables according to your requirement that you can ALSO FEED INTO SQLPrompt?

Please, clarify.

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 2

It's not so much that you "feed" it, as Prompt is already looking at your data structures, so, yeah, that's what it does. It takes your data structures and uses that to generate multi-table queries based on what you tell it in english "give me a list of names in the state of oklahoma" or whatever.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

VAI SSC Enthusiast Points: 185 More actions · Answer 3

Sounds really good! I have never used SQL Prompt for this purpose but used it for other, mostly code formatting and best practices suggestions purposes.

QUESTION: is SQL PROMPT similar to

Copilot is now in Azure Data Studio ?

https://www.youtube.com/watch?v=lAlqWKDODDE

IS Redgate sql prompt a COPILOT, Too?

VAI SSC Enthusiast Points: 185 More actions · Answer 4

Thanks, Grant!

Good to hear from you. I have learned quite a few good things from your books and other presentations over the years.

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 5

VAI wrote:

Thanks, Grant!
Good to hear from you. I have learned quite a few good things from your books and other presentations over the years.

Thanks! Happy to help where I can.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 6

VAI wrote:

Sounds really good! I have never used SQL Prompt for this purpose but used it for other, mostly code formatting and best practices suggestions purposes.
QUESTION: is SQL PROMPT similar to
Copilot is now in Azure Data Studio ? https://www.youtube.com/watch?v=lAlqWKDODDE
IS Redgate sql prompt a COPILOT, Too?

Nope. Copilot is different.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 7

Grant Fritchey wrote:

VAI wrote:
Sounds really good! I have never used SQL Prompt for this purpose but used it for other, mostly code formatting and best practices suggestions purposes.
QUESTION: is SQL PROMPT similar to
Copilot is now in Azure Data Studio ? https://www.youtube.com/watch?v=lAlqWKDODDE
IS Redgate sql prompt a COPILOT, Too?
Nope. Copilot is different.

I've found, however, that, to date, they all have one thing in common when it comes to writing SQL beyond the basics and that is that they're all confidently incorrect. They can't help it because they've been trained by confidently incorrect things. They also don't "think". They're not actually a form of "Artificial Intelligence" when it comes to most things. In the world of SQL, they seem more like consensus grinders that are sorely lacking of any bullshit filters.

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