Code from Redgate Streamed

I presented a session today at Redgate Streamed and did a number of demos. The code consists of a few flies, which I’ve made available here: BasicUnitTesttsqlt.zip.

This consists of:

  • 00_tsqlt.sql – Creates a database and adds the tsqlt framework.
  • 01_GetTesting_tsqlt_Setup.sql – adds objects you need.
  • 10_SQT_SQLCop_Demo.sql – The standards test demo
  • 20_SQT_RefactorArticles_MetaData.sql – Testing a table API
  • 30_SQT_RefactorArticles_IsolateProcedure – Test a function and procedure separately
  • 40_SQT_RefactorArticles_Exceptions.sql – Testing edge cases and bad data
  • 50_SQT_RefactorGrouping.sql – Sample test class breakdown
  • 99_SQT_Cleanup.sql – cleans things up

You do need to have the SQLCLR enabled, and you will enable TRUSTWORTHY for this test database.

Any question, let me know.

About way0utwest

Editor, SQLServerCentral
This entry was posted in Blog and tagged , , . Bookmark the permalink.