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.
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 https://github.com/jamiekt/TSQLCodeLibrary.
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:
