Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Data type precedency ntext and hierarchyid Expand / Collapse
Author
Message
Posted Tuesday, December 25, 2012 7:08 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Saturday, December 28, 2013 5:45 PM
Points: 94, Visits: 96
Tinyint and bit have a higher precedence than ntext. Why is this? Couldn't ntext we complex alphanumeric values? Tinyint and bit are limited and simple.

What precedence does hieararchyid data type have? I looked here but didn't see anything: http://msdn.microsoft.com/en-us/library/ms190309.aspx
Post #1400118
Posted Wednesday, December 26, 2012 8:11 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:24 PM
Points: 11,990, Visits: 11,007
Golfer22 (12/25/2012)
Tinyint and bit have a higher precedence than ntext. Why is this? Couldn't ntext we complex alphanumeric values? Tinyint and bit are limited and simple.

What precedence does hieararchyid data type have? I looked here but didn't see anything: http://msdn.microsoft.com/en-us/library/ms190309.aspx


You kind of have 2 or 3 questions here.

Why is tinyint a higher precedence than ntext? First of all ntext is deprecated so you shouldn't be using it at all. Your argument of it could be complex alphanumeric values is exactly why it fall on the precedence list where it is. You can't do math on alphanumeric values. They have to be numeric to perform calculations. The more relevant reason is that you have crossed the line from something that can be used in a mathematical equation to something that can't (well maybe it can IF the data can be converted).

Your second question is about the precedence of HierarchyID. My question would be, does it really matter? Are you going to be implicitly converting to/from the hierarchyID datatype?


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1400257
Posted Saturday, December 29, 2012 11:48 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Saturday, December 28, 2013 5:45 PM
Points: 94, Visits: 96
I probably won't be converting to or from HierarchyId. I'm just curious. If someone wants to answer this thread for the theoretical fun, please do.
Post #1401197
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse