Sign in
|
Help
Home
Blogs
Media
All Tags
»
Xml
»
datatype
(
RSS
)
Recent Posts
How do I find the data types such as xml or text or image of a specified table?
Tags
.NET
Advisories / Bulletins
ASP.NET
C#
Community
Digital Media
Exchange
General
General Security News
Media Center
Microsoft
News
OpsMgr 2007
Rants
Security
Sharepoint
SPPS03_Tips
SQL Server
System Center
Tools
VB
Vista
Windows 7
Windows OS
Windows Server
Browse Blog Posts by Tags
Showing related tags and posts for the
Blogs
application. See
all tags in the site
image
lob
tables
tsql
How do I find the data types such as xml or text or image of a specified table?
USE <database_name>; GO SELECT name AS column_name ,column_id ,TYPE_NAME(user_type_id) AS type_name ,max_length ,CASE WHEN max_length = -1 AND TYPE_NAME(user_type_id) <> 'xml' THEN 1 ELSE 0 END AS [(max)] FROM sys.columns WHERE object_id...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Wed, Jul 18 2007
Filed under:
Filed under:
xml
,
datatype
,
tsql
,
tables
,
image
,
lob
Page 1 of 1 (1 items)