Database Development

For #tsql2sday, sometimes the best dynamic SQL code you can write is the code that was dynamically generated for you from your tables or views. The dynamic SQL stored procedure named dbo.PersonSearch below was generated with the free open-source stored procedure named sp_CRUDgen.…

How to Sort (Order By) columns with the search stored procedure in sp_CRUDGen. The generated search stored procedure allows for multicolumn sorting by passing in JSON to the @OrderColumns parameter. If can be a basic column name or multiple table…

You can time travel search with the dynamically generated search stored procedure with sp_CRUDGen. If you have a system-versioned temporal table included in the search stored procedure, you will have parameters that will allow you to time travel and view…

Database Views are now supported with sp_CRUDGen. You might have a need for a more complex table join so a view can be your best option to generate a search stored procedure (Kitchen Sink). You might just not want to…

Your Table Per Type (TPT) inherited tables are now supported with sp_CRUDGen. When your tables are built with Table Per Type (TPT) polymorphic association, sp_CRUDGen will add them to the dynamic search stored procedure. Watch the demo video below. https://youtu.be/_l1TLEjPVTQ…

I just uploaded an overview video explaining how the SQL Server stored procedure I created named sp_CRUDGen can create a search (optional parameters, kitchen sink, Swiss army knife, catch-all queries) stored procedure plus 10 others. Check out the video below.…