title: What is the purpose of ASSEMBLIES in SQL Server?
body: <p>I am working on a Third Party Software build on SQL Server database. Noticed they have user defined / developed assemblies under the ASSEMBLIES Folder.</p>
  
  <p>Default is <code>Microsoft.SqlServer.Types</code></p>
  
  <p>What is the purpose of SQL Server assemblies? How do we read it? It is possible to call an assembly as <code>SELECT * FROM ASSEMBLYNAME</code> ( Something like that ).</p>