Steve Stedman ask a great question “What is your naming convention?” in his blog article found here and is looking for feedback on our naming conventions. I work on the SQL Server team at a consulting company named Emergent Software. …
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. Find …
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. …