?
Solved

What's the differnce between xtype and xusertype in systypes

Posted on 2008-09-29
4
Medium Priority
?
1,692 Views
Last Modified: 2010-04-21
What's the differnce between xtype and xusertype in systypes?
It seems that they are the same for all types except "sysname"
0
Comment
Question by:treehouse2008
  • 2
  • 2
4 Comments
 
LVL 11

Expert Comment

by:aaronakin
ID: 22597551
Here's is a description of the two from microsoft.  http://msdn.microsoft.com/en-us/library/ms175109(SQL.90).aspx
0
 

Author Comment

by:treehouse2008
ID: 22597893
I read that before.  I do not understand what's "Physical storage type" and "Extended user type". And how xtype and xusertype are used in differnt situations?
0
 
LVL 11

Accepted Solution

by:
aaronakin earned 750 total points
ID: 22600733
If you have any user-defined datatypes, they all have an underlying system type tied to them.  For instance, the user type PhoneNumber could have a system type of char(10).  In this case, the xtype value would be the id for the varchar type, and the xusertype value would be the id for the PhoneNumber type.
0
 

Author Closing Comment

by:treehouse2008
ID: 31501228
Thanks
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Suggested Courses

579 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question