SQL Basic: SQL Data Types



SQL Data Type:

  • is an attribute that specifies type of data of any object. 
  • In each column, variable and expression has related data type in SQL.

 There is categories of data types in SQL Server as follows: 

Exact Numeric Data Types



Approximate Numeric Data Types


Date and Time Data Types


Char-Strings Data Types



Unicode Char-Strings Data Types


Binary Data Types


Misc Data Types



Popular posts from this blog

SQL Basic- SQL Syntax

Image
          SQL Syntax:            SQL Syntax Database Tables A database contains one or more tables. Each table is identified by a name (e.g. "Student" or "Product").  Tables contain records (rows) with data. Below is a selection from the " Student " table: StudentID             StudentName               Address                Country 1             Ajay               Noida                India 2             Ajeet               Bareilly                India 3             Shivam               Nagaland...
Read more

C# Fundamental: Data Types and Variable

Image
Data Types In C#, data types are used to store values in the memory. When data type is declared, it allocates a block of memory to hold the value. All the data types are directly or indirectly derived from the  System.object  class. Before moving, we need to understand the variables. Variables A variable is used to store the value (data). It is an address given to a memory location. Example: Take an example of a bag here bag is a variable we can put books into a bag and we can take them out again but we can put books according to bag size, a bigger bag can hold more books. Similarly, we can store and retrieve data from a variable. Here bag is the variable name the size of bag is the data type, an  int  can hold 32 bit value and  long  can hold 64 bit value. Different data types have different sizes we use them according to our requirement for example if we want to store only two values  true  or  false  we...
Read more

Type Declaration Instruction in C

Type Declaration Instruction This instruction is used to declare the type of variables being used in the program. Any variable used in the program must be declared before using it in any statement. The type declaration statement is written at the beginning of main( ) function. Ex.: int bas ; float rs, grosssal ; char name, code ; There are several subtle variations of the type declaration instruction. These are discussed below: While declaring the type of variable we can also initialize it as shown below. int i = 10, j = 25 ; float a = 1.5, b = 1.99 + 2.4 * 1.44 ; The order in which we define the variables is sometimes important sometimes not. For example, int i = 10, j = 25 ; is same as int j = 25, j = 10 ; However, float a = 1.5, b = a + 3.1 ; is alright, but float b = a + 3.1, a = 1.5 ;         is not. This is because here we are trying to use a even before defining it. The following statements would work int a, b, c, d ; a = b = ...
Read more