?
Solved

large CLR types on SQL Server

Posted on 2013-11-21
3
Medium Priority
?
202 Views
Last Modified: 2013-11-25
Can someone name the large CLR types for me? Are nvarchar(max), varchar(max) etc. considered large CLR types?
0
Comment
Question by:YZlat
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 27

Expert Comment

by:Zberteoc
ID: 39667342
I think only XML, and spatial data types, geometry and geography, are implemented as CLR in SQL server. All the others are native SQL. The thing with varchar and nvarchar (max) is that they are now used instead of the deprecated image, text and ntext types.
0
 
LVL 35

Author Comment

by:YZlat
ID: 39670046
What i need is the names for those types so I could query sys tables for them
0
 
LVL 27

Accepted Solution

by:
Zberteoc earned 450 total points
ID: 39670149
xml, geometry, geography
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

777 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