Posts

Showing posts with the label SQL Datatypes

SQL Database

What is SQL Database? In simple database is collection of objects which stores a specific set of structured data. Let us consider an example of Facebook. It needs to store, manipulate, and present data related to members, their friends, member activities, messages, advertisements, and a lot more. These all information is stored in different tables and collection of these tables are kept at one place.   How to CREATE SQL Database? To create a new database in a SQL server use CREATE DATABASE statement. Syntax: CREATE DATABASE DATABASENAME   How to ALTER existing SQL Database? If we want to change the database name or file locations or collations etc. then we use ALTER DATABASE statement. Syntax: ALTER DATABASE { database_name   | CURRENT }   {    MODIFY NAME = new_database_name      | COLLATE collation_name     | < file_and_filegroup_options >     | SET < option_spec ...
Post a Comment
Read more

SQL Datatypes

Data Types Data types are used to represent the nature of the data that can be stored in the database table. For example, in a particular column of a table, if we want to store a string type of data then we will have to declare a string data type of this column. Data types mainly classified into three categories for every database. String Data types Numeric Data types Date and time Data types Unicode Character String Data types Binary Data type Miscellaneous Data types SQL Numeric Data Types Datatype From To bit 0 1 tinyint 0 255 smallint -32,768 32,767 int -2,147,483,648 2,147,483,647 bigint -9,223,372,036, 854,775,808 9,223,372,036, 854,775,807 decimal 1E+38 10^38 -1 numeric 1E+38 10^38 -1 float -1.79E + 308 ...
Post a Comment
Read more