Data types in SQL Server : A Quick Read

-

A data type is an attribute that specifies the type of data that the object can hold for example integer data, character data, date and time data, binary strings, and so on.
SQL Server supplies a set of system data types that define all the types of data that can be used with SQL Server plus you can define your own data types in Transact-SQL or the Microsoft .NET Framework.

Data types in SQL Server are organized into the following categories:
1 - Exact numerics

bigint
numeric
bit
smallint
decimal
smallmoney
int
tinyint
money

2 - Approximate numerics

float
real

3 - Character strings

char
varchar
text

4- Unicode character strings

nchar
nvarchar
ntext


5 - Binary strings

binary
varbinary
image


6 - Date and time

date
datetimeoffset
datetime2
smalldatetime
datetime
time


7 - Other data types

cursor
timestamp
hierarchyid
uniqueidentifier
sql_variant
xml
table

Comments

Post a Comment

Popular posts from this blog

23 Tips to Speed Up your Windows XP Performance

-
Given below are the 23 tricks that will enhance the performance and reliability of your Windows XP OS. Best of all, most of them will cost you nothing. 1-To decrease a system's boot time and increase system performance, use the money you save by not buying defragmentation software -- the built-in Windows defragmenter works just fine -- and instead equip the computer with an Ultra-133 or Serial ATA hard drive with 8-MB cache buffer. 2- If a PC has less than 512 MB of RAM, add more memory. This is a relatively inexpensive and easy upgrade that can dramatically improve system performance. 3- Ensure that Windows XP is utilizing the NTFS file system. If you're not sure, here's how to check: First, double-click the My Computer icon, right-click on the C: Drive, then select Properties. Next, examine the File System type; if it says FAT32, then back-up any important data. Next, click Start, click Run, type CMD, and then click OK. At the prompt, type CONVERT C: /FS:NTFS and press
Read more

How to uninstall McAfee Security Center from your System

-
If you want to uninstall McAfee Security Center, follow these steps. 1 - Access McAfee's files in your program files folder in Explorer. Look for C:\program files\mcafee.com\agent\app. 2 - Delete all files contained in the folder. If you can’t find the McAfee application, enter "mcafee" in the Search feature on your Explorer toolbar. 3 - Go to the "Add and Remove Programs" in the Control Panel. Highlight "McAfee Security Center" and click on "Remove."
Read more

What is a balanced scorecard?

-
The balanced scorecard methodology, an outgrowth of prior measurement and management methodologies like total quality management (TQM), has existed for decades, but it was formalised in the early 1990s by Robert Kaplan and David Norton. Kaplan and Norton not only gave it a formal name but also put structure around the way organisations can measure how well they are functioning and how to predict future performance. Basically, it's a way to map and translate complex business information into something that's understandable to everyone. The methodology starts with targets defined by the organisation, followed by scorecard measures. These usually include both corporate targets and business unit targets, which are then honed into individual measures and targets. It's a very flexible approach, designed to be adapted to any organisation's needs. And virtually anything can be measured.
Read more