Register the assembly udts can be deployed through the visual studio user interface in a database project , or by using the transact - sql create assembly statement , which copies the assembly containing the class or structure into a database 注册程序集udt可通过visual studio用户界面在数据库项目中部署,或者通过使用transact - sql create assembly语句(该语句将包含类或结构的程序集复制到数据库中)部署。
Because there might be clr functions , stored procedures , triggers , data types , and user - defined aggregate functions in the instance of sql server that are already defined against the assembly , the alter assembly statement rebinds them to the latest implementation of the assembly 由于sql server实例中可能存在已针对程序集定义的clr函数、存储过程、触发器、数据类型和用户定义的聚合函数,因此alter assembly语句将它们重新绑定到该程序集的最新实现。