Monetory or Currency Types and Bit (Boolean Type) in sql server

Monetory or Currency Types

A data types that represent monetory or currency values

      Data Type                  Range                       Storage
     -----------            ----------------------         ----------------------

     Money               -922,337,203,685,477.5808           8 bytes
                         to 922,337,203,685,477.5807                   
       
   SamllMoney            -214,748.3648 to 214,748.3647       4 bytes


Bit (Boolean Type)

An integer type that can take a value of 1, 0 ,NULL

The string values TRUE and FALSE can be converted to bit values

  TRUE is converted to 1
  FALSE is converted to 0

Converting to bit promotes any nonzero value to 1
About Author: author 4 + years of Information Technology experience in understanding and analyzing the software and hardware engineering requirements, onsite and offshore management of product development. Expert work on design and development for windows,web,mobile Expert knowledge of C#,ADO.NET, ASP.Net MVC, ENTITY FRAMEWORK, LINQ,COLLECTIONS, JAVASCRIPT,AngularJs 1.0,Angular2, Jquery,Jquery-Ajax, SQL SERVER, XAML,Windows phone 8.1 Good knowledge of WCF-Restful services,WCF, WEB API-Services ,Web- Services,MIcrosoft-Azure,JUICE UI,HTML,CSS,AJAX Read More...

Join him on Google+ | Facebook | Linkedin

No comments