What is SQL? What are the main data types?

Asked By Michal dj 10 points N/A Posted on - 12/03/2012

Hello,

I am following a degree in computer science and I just started it. I want to know what is sql? , what are the main data types in SQL?

• Status: Open
• Question Views: 840
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by Howard william

Go To Solution

Answered By John major 0 points N/A #162530

What is SQL? What are the main data types?

Hello,

Sql stand for Structured Query Language and It is a programming language that use for manipulate data from Databases.

Main Data Types in Sql

1.   Char (8)- for characters, store text data

2.   Varchar(10) – for characters, store text data

3.   Int(10) – whole numbers

4.   Decimal (10,2) – for decimal numbers

Data type’s length can be different from one data type to another data type.

Hope this will help you,

Thank You

John Major.

About John major

Questions
1

Answers
106

Best Answers
47

• Vote Up 0 Vote Down

• Posted on - 12/03/2012
• Question Category: MS SQL Server

Best Answer

Best Answer

Answered By Howard william 0 points N/A #162531

What is SQL? What are the main data types?

HI,

SQL or structured query language is a kind of language which is used to manipulate data and table definitions in database. SQL statements are not case sensitive and it can be written on one or more line. A database can be accessed or modified by SQL.

 

The main data types used in SQL are:

 

1.   Int (30); for integer numbers

2.   Varchar(30); for characters and strings

3.   Numeric(20,2) for floating numbers

4.   Blob(5MB) for images, files uploads

5.   Date (YYYY-MM-DD HH:MM:SS)

 

 

About Howard william

Questions
3

Answers
52

Best Answers
16

• Vote Up 0 Vote Down

• Posted on - 12/03/2012
• Question Category: MS SQL Server