MagnusArias

SBO | CLR 2 SQL

Jan 11th, 2020
273
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.33 KB | None | 0 0
  1. DROP TYPE Punkt
  2. GO
  3. DROP ASSEMBLY [Punkt_a]
  4. GO
  5. CREATE ASSEMBLY [Punkt_a]
  6. AUTHORIZATION [dbo]
  7. FROM 'C:\e740\repos\Funkcje\CLR_Struct\CLR_Struct\bin\Debug\CLR_Struct.dll'
  8. WITH PERMISSION_SET = SAFE
  9. GO
  10. CREATE TYPE dbo.Punkt
  11. EXTERNAL NAME Punkt_a.Punkt;
  12.  
  13. DECLARE @a Punkt;
  14. SET @a = CAST('1.2, 3.6' AS Punkt)
  15. SELECT @a, @a.ToString()
Add Comment
Please, Sign In to add comment