Скачать или смотреть sp_CRUDGen - Sorting Order By with the Search Stored Procedure AKA (Kitchen Sink)

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 and/or column names either ascending or descending. Watch the demo video below.

sp_CRUDGen is a free open-source SQL Server stored procedure that generates stored procedures for you based on your tables and metadata like foreign keys and data types. The generated stored procedure code utilizes the SQL Server community best practices.

You can use sp_CRUDGen to generate 11 different stored procedures from basic your Create, Read, Update, Delete, Upsert stored procedures to extremely advanced safe dynamic search stored procedures otherwise known as optional parameters, kitchen sink, Swiss army knife, catch-all queries.

YouTube Playlist:
   • sp_CRUDGen - SQL Server SQL Server Stored ...  

Blog Articles:
http://spcrudgen.org

GitHub Repository Project:
https://github.com/kevinmartintech/sp...