Yukon UDT - Case Sensitive
While preparing for a talk on Yukon for the Montreal SQL Server UG, I found something interesting. I used Peter W. DeBetta code from his MSDN Magazine February article on UDTs.
The Point class has two properties (x and y) in lowercase. And this DML code has not:
DECLARE @endPoint Point
SET @endPoint::X = 5
SET @endPoint::Y = 3
The code didn't run until I used the correct syntax (lowercase) was used.
SET @endPoint::x = 5
SET @endPoint::y = 3