MSSQL DataTYPE

  💓 Mssql Datatype can have int ,char ,varchar ,decimal ,bit ,money

   1)  Integer :Integer can store whole value like Id, Age  can take 4byte of data to store.              

                 tinyInt :- 1byte ,smallInt: 2byte ,mediumInt : 3 byte,Int :4byte,bigInt :5byte

   2)  Char : Char is a Fixed Length .char can store English character and  Number. Store 1byte of data

   3)  Varchar : Varchar  is a variable Length it store English char and number.

   4)  Decimal :Decimal can store the exact value in database.  decimal(P,D)

                   P = Precision , D = Digit

    5) Bit : Bit can store the value 0 and 1 0 = false ,1 = true.

    6)Money : Money can store the Currencly Value

         Also we have nChar and nVarchar

   nChar : nChar is a fixed length . it can store non-english or localize language like

               Hindi ,Marathi ,Gujrati . it take 2 byte

   nVarchar : nVarchar is variable length . it can store non-english or localize language like

               Hindi ,Marathi ,Gujrati . it take 2 byte

  💀    Different Between Char and Nchar

        Char :   Char is a Fixed Language and  can take English Character and Number .and its 1 byte

         nChar : nChar can take local-language or non-english language like   Hindi ,Marathi ,Gujrati . 

                     it take 2 byte

💀    Different Between Varchar and nVarchar

        Varchar :   Varchar is a Variable Language and can  take English Character and Number .and its 1                             byte

         nVarchar :   Varchar can take local-language or non-english language like  Hindi ,Marathi ,Gujrati                               it take 2 byte .                      

For EG :-

        




Comments

Post a Comment

Popular posts from this blog

 SQL PERFORMANCE TUINING :-    1) CLUSTER AND NON-CLUSTER INDEX :-       both can be used for searching purpose.        CLUSTER INDEX :          It can be used for searching purpose          Any column can have  Primary key or index then it will be a cluster index.        there will be only 1 cluster index in a table.      eg:-       select * from Appoinmnet where id=51;         1)soo cluster index 1st create B-tree n divide index value 1-50 and 51-100   (balance tree it can balancely divide the records agar 100 he to  50 ,  50  me divide krega)             2)then  index can check condition is 50<51 not so skip 1-50 and search on 51-100 index        3) it gate 51 index then it index have leaf node which provide him value   ...
Read more

STORE PROCEDURE AND FUNCTION

Image
 STORE PROCEDURE :-   Store Procedure is a reusability of code it can be invoke by using Exec.  so if i have any sql query that  i write over  and over again then i will save it to store procedure and just call it to execute it  HOW TO CREATE STORE PROCEDURE: first select your database then click on Programmability and in  Programmability we have Store Procedure.  so for creating a new Store Procedure just right click on Store procedure and select New Store Procedure SO here patientEFcore  is my database and inside it i have Programmability and in  Programmability i have Store Procedure. so in PatientEFcore i have tables here in tblPatient i am creating Store Procedure for Patientid .  soo this is my  new Store Procedure  CREATE PROCEDURE Sp_getpatientId       //Sp_getpatientId i named my store Procedure @Id int                          ...
Read more