Getting Started With SQL Data Type and Operator

Information about Microsoft SQL Server

  • Microsoft SQL Server is a one-type database
  • Microsoft SQL Server was created by Microsoft for Web and Desktop application data management
  • For any database created the main concept is for security; in this the create-member-level security is for data access in any data application

SQL Operations

Here we see how to work with SQL Database basic operations such as print data, addition(+), subtraction (-), multiplication (*), division (/) and so on.

We will now see some SQL operations.

Print

The print command is used to print in the SQL editor.

Command

  1. Print ’write something’  
Press F5 to execute.



Unary Operator

Unary operators are one type mathematical operator.

Two type unary operators.

A unary operator assigns to a value positive or negative at zero (0).
For example, a positive value +1 and a negative value -1.
This means that this is assigned to in a mathematical series value as in -2, -1, 0, 1, 2…



Binary Operation

Binary operation is a very useful concept in SQL databases.

The following are one-by-one binary operations.
  1. Addition (+)

    This operation is uses with a numeric value or string type data.
    For example:



    This operator is used for number addition and to join two words.

  2. Subtraction (-)

    This is used to subtract two number values.



  3. Multiplication (*)

    This is used to multily two number values.



  4. Division(/)

    This is used to divide two number values.



    In this see a SQL database follows all mathematical rules. Any numeric value can never be divided by Zero (0).

  5. Modulo (%)

    It's very useful in numeric calculation.



  6. Bracket ) (

    It's used in every computer language and database.



  7. Bit Operation (~)

    Our computer language by default works with bit values 0 and 1. We see here some binary operations with SQL. How do they work? Bit operations work with the ~ symbol.

    Command: ~ number data

    Bitwise NOT Operator

    It's a not unary operation. It defines any numeric data on the left side.

    Command : ~ number

    print ~ 12
    get -13

    Bitwise AND operator (&)

    It's for a two-value comparison.

    Command : value1 & value2

    print ~12 & ~13
    get -14

    Bitwise OR operator ( | )

    It's one more comparison operator.

    Command : value1 | value2

    print ~12 | ~13
    get -13

    Bitwise Exclusive OR operator ( ^ )

    It's also a comparison operator.

    Command : value1 ^ value2

    print 127^130


SQL Variables And Datatypes

In this, see how to declare programmatically SQL variables and data types. Data types are a very important part of any database.

Declare Variable

The Declare keyword is used to declare a variable.

For example:

DECALRE value datatype

  1. declare @12 int  
  2. declare @Rakesh char  
  3. declare @17052015 date  
Variable Initialize

We declare a variable after it;s initialized.

In this use must @ mark initialize for any variable and also use the SELECT or SET keyword.

Many types of variables are available in databases, let's see one-by-one some variables.
  • Boolean Variable

    The Boolean data type uses bit type operators, true/false, yes/no, 1/0 and so on.



  • Number variable

    Any number variable is declared using int, smalltype, bigint data types.



  • Decimal Type

    It's used for decimal numeric value declaration.



  • Float type

    Used for factorial data type declaration. It is also known as a Real numbers.



  • Money

    It's used for currency value declaration.



  • Character and String

    It's used for character and string value data. In character data there is only word characters and in a string are words. Both types of declarations use a single quote.



  • String

    In SQL any string data value uses varchar and nvarchar data types.



  • Time

    it's for time data in a database.



  • Date

    It's for date data types in SQL.



This is some information about SQL database data types and how to declare and hold SQL data in a SQL database.