createudts.sql

来自「wrox出版社的另一套经典的VB2005数据库编程学习书籍,收集了书中源码,郑重」· SQL 代码 · 共 11 行

--DROP TYPE [Point];
--DROP TYPE [PointClass];
--DROP TYPE [Address];
--DROP TYPE [AddressBasic];
--DROP ASSEMBLY [UserDefinedTypesCLR];
--Change the path below to correspond to your sample projects installation folder
CREATE ASSEMBLY [UserDefinedTypesCLR] FROM '\InstallPath\Chapter11\UserDefinedTypesCLR\bin\UserDefinedTypesCLR.dll';
CREATE TYPE [Point] EXTERNAL NAME [UserDefinedTypesCLR].[UserDefinedTypesCLR.Point];
CREATE TYPE [PointClass] EXTERNAL NAME [UserDefinedTypesCLR].[UserDefinedTypesCLR.PointClass]; 
CREATE TYPE [Address] EXTERNAL NAME [UserDefinedTypesCLR].[UserDefinedTypesCLR.Address]; 
CREATE TYPE [AddressBasic] EXTERNAL NAME [UserDefinedTypesCLR].[UserDefinedTypesCLR.AddressBasic];