Attention: We have retired the ASP.NET Community Blogs. Learn more >

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

 

2 Comments

Comments have been disabled for this content.