Home > Query, SQL > BISQL # 30 :How Should I Find Information about Data Type

BISQL # 30 :How Should I Find Information about Data Type

July 27, 2011 Leave a comment Go to comments

 

Hi Friends,

Some guys always ask me What should I do when I want Details about Data type Instantly

Its like finding Data about Data type

When we are doing rapid development having Very less time to Google the problem we can use following query

Its Very Simple Smile

Just Have to use SQL Help Feature

exec sp_help int

We will get the Details in following formats

image

Go n play out with each Data type

exec sp_help varbinary
exec sp_help Money
exec sp_help decimal
exec sp_help smallint
exec sp_help bigint
exec sp_help char
exec sp_help varchar
exec sp_help nvarchar
exec sp_help nchar
exec sp_help binary

You can also Visit to todays Link Resource Website : Link Resource # 7 July 27 « Dactylonomy of Web Resource 

Hope this helps !!!

For more interesting information on SQL we can also look into similar topics such as

· BISQL # 31 : How To Create Folder from SSMS

· BISQL # 32 : How To find Parent Child Relationship Between Tables

· BISQL # 33 : Lets Understand Stored Procedure

· BISQL # 34 : What is Identity IN SQL {Identity Part–I}

· BISQL # 35 : Deep dive into Identity Functions in SQL {Identity Part–II}

 

Hope you will like this post on Information about Data type.

If you really like reading my blog and understood at least few thing then please don’t forget to subscribe my blog.

If you want daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog: Link Resource Website

             For More information related to BI World visit my Mentalist Blog

                            Link Resource Blog >> Daily Interesting links

                            SQL Server Mentalist >> SQL Learning Blog

                            Business Intelligence Mentalist >> BI World

                                         Connect With me on

             | FaceBook |Twitter | LinkedIn| Google+ | WordPress | RSS |

                                     Copyright © 2011 – 2012 Vishal Pawar

Advertisement
Categories: Query, SQL

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

%d bloggers like this: