pointdefault.sql

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

DECLARE @pt Point
SET @pt = CONVERT(Point, '0,0')
SET @pt.X = 1
SET @pt.Y = 2
PRINT @pt.ToString()
PRINT ''

SET @pt = CONVERT(Point, '2.5,3.6')
PRINT @pt.X
PRINT @pt.Y
PRINT @pt.ToString()
PRINT ''

SET @pt.X = 2
SET @pt.Y = 2
PRINT @pt.ToString()
PRINT ''

PRINT @pt.DistanceTo(CONVERT(Point, '1,1'))
PRINT ''

SET NOCOUNT ON

PRINT 'Binary Serialization'
SELECT * FROM PointsUDT
PRINT ''

PRINT 'String Representation'
SELECT PointID, PointUDT.ToString() AS PointUDT FROM PointsUDT