You can unit test stored procedures. For example, with T-SQL can use the open source unit testing framework tSQLt:

http://tsqlt.org/

tSQLt is used by the commercial SQL Test product from Red Gate if you wanted a more polished user experience:

https://www.red-gate.com/products/sql-development/sql-test/i...