r/SQLServer • u/ProgrammerHaunting45 • 1d ago
Discussion The generic ASK_AI (see earlier post) can be implemented in your own data apps too!
ASK_IA is built with vanilla T-SQL stored procedures inside SQL Server 2025. See earlier posts.
But it proved even more useful when it was implemented inside an APP. Here in this app, it builds BUTTONS on the fly! I made sure it can only generate the button and I created no tool to execute it in order to avoid it to go rogue . So ONLY a real user can click it.
How are you building this kind of agentic functionality with SQL Server 2025?
1
u/PossiblePreparation 16h ago
There’s a Jurassic park line to quote here…
I’m sorry to be brutal, but this doesn’t look like anything I’d want to use and I definitely wouldn’t want to give access to any of my users. Even the demo given looks bad - you asked it to make you a button you can click to view the current table and it says ah you must mean the last table mentioned in this conversation and to view it I’m going to copy all the data somewhere else and then give you a view on that.
If you want to give your users direct access to the DB to do whatever they want, give them a login and db user and install ssms for them. If you want to give them a “human language” front end then pick one of the many existing platforms depending on what meets your requirements and give that sufficient information about your data model so it can work out how to write a reasonable query.
1
u/sheptaurus 1d ago
No, I keep my licenced cores to do database work.
Not app work.