July 27, 2011 8:14 pm
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
Just Have to use SQL Help Feature
exec sp_help int
We will get the Details in following formats
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
Copyright © 2011 – 2012 Vishal Pawar
Posted by Vishal Pawar
Tags:
Mobile Site | Full Site
Get a free blog at WordPress.com Theme: WordPress Mobile Edition by Alex King.
[…] BISQL # 30 :How Should I Find Information about Data Type […]
By List of monthly post of MS BI and SQL blog–July 2011 « SQL Server Mentalist on July 31, 2011 at 10:11 pm
[…] BISQL # 30 :How Should I Find Information about Data Type […]
By List of monthly post of MS BI and SQL blog–July 2011 « (B)usiness (I)ntelligence Mentalist on July 31, 2011 at 10:19 pm
[…] BISQL # 30 :How Should I Find Information about Data Type […]
By List of monthly post of MS BI and SQL blog–July 2011 « Dactylonomy of Web Resource on July 31, 2011 at 10:30 pm
[…] BISQL # 30 :How Should I Find Information about Data Type […]
By Link Resource # 20 : Aug 26 – Aug 28 « Dactylonomy of Web Resource on August 27, 2011 at 2:26 pm