Initial Release

@jamiekt jamiekt released this Jan 12, 2014 · 19 commits to master since this release

First release of my TSQL Code Library on github. It currently contains 9 objects, execute:

select schema_name,object_name,object_type,CodeLibraryDescription
from jt.[vwCodeLibraryDescriptions]
to see a list of them along with descriptions.
20140112tsqlcodelibraryv0 1_objects

The code library is a collection of views, stored procedures and functions. If you would prefer to simply view the code without having to go through the rigmarole of downloading, creating a database etc... simply view the latest code at

If you actually want to use any of the objects in my code library then I recommend installing it, this involves creating a SQL Server database to contain all of those objects.

The code library is distributed as a dacpac file. To install the code library download the two binaries:

  • master.dacpac
  • TSQLCodeLibrary.dacpac

and store them together in a folder. Open a command prompt at that folder and type:

"%ProgramFiles(x86)%\Microsoft SQL Server\110 \DAC\bin\SqlPackage.exe" /action:Publish /SourceFile:TSQLCodeLibrary.dacpac /TargetServerName:"your_server_name" /TargetDatabaseName:your_prefered_db_name

(replacing your_server_name with the name of the SQL Server instance where you want to create the code library and your_prefered_db_name with whatever you want the database to be called).

This will create a SQL Server database containing my code library:
20140112deployedtsqlcodelibraryv0 1