Wednesday , September 19 2018
Home / Samba (page 3)

Samba

April, 2016

  • 22 April

    Create Check Constraint in Sql Server

    Create Check Constraint in Sql Server Check Constraint: If we want to check the values present in a column to be according to a specified value we use this constraint. Syntax: [crayon-5ba20e7520b1c362675848/]     Example: [crayon-5ba20e7520b26771481352/] Explanation: The Above Example Explains you the Employee salary Should be more than 1000 .If …

  • 22 April

    Create Default Constraint in Sql Server

    Create Default Constraint in Sql Server Default Constraint:-It is useful to provide default value into a column when user will not provide any value while inserting the data into the table then default value will be arranged. Column Level Definition: In this case the constraint definition is immediately followed after …

  • 22 April

    Create Unique Constraint In Sql Server

    Create Unique Constraint In Sql Server Unique Constraint:-  When  we  place UNIQUE constraint on any column ,It will not allow duplicate values but it allows single null value. Unique  Key Constraints can be imposed in two different ways: 1.Column Level Definition 2.Table Level Definition Column Level Definition: In this case …

  • 20 April

    TRANSACTIONS CONTROL LANGUAGE(TCL) In Sql Server:

    TRANSACTIONS CONTROL LANGUAGE (TCL):  Transaction is nothing but a unit of work. We can control these transactions using the following statements ROLLBACK Statement COMMIT Statement SAVE TRAN [SACTION] 1.ROLLBACK Statement: ROLLBACK statement is used to cancel a particular performed transaction. 2. COMMIT Statement: COMMIT statement makes a transaction permanent. It …

  • 20 April

    DATA CONTROL LANGUAGE(DCL) In Sql Server

    DATA CONTROL LANGUAGE(DCL)  In Sql Server DATA CONTROL LANGUAGE: By Using DCL We Can control the data between different user accounts. DCL Commands Includes GRANT Statement       2.REVOKE Statement   1.Grant Statement: By Using Grant Statement we can  grant the permissions (INSERT, SELECT, UPDATE, DELETE) on a specific table to …

  • 20 April

    DATA MANIPULATION LANGUAGE(DML) In Sql Server:

    DATA MANIPULATION LANGUAGE: INSERT Statement SELECT Statement UPDATE Statement DELETE Statement 1.INSERT Statement: By Using INSERT Statement   we can inserting the values into a specific table. 2.SELECT Statement: By Using SELECT Statement   we can retrieving the data from a specific table.  3.UPDATE Statement: By Using UPDATE Statement   we can modifying the data, which …

  • 20 April

    Data Definition Language(DDL) Commands In Sql Server:

    Data Definition Language(DDL) :- DDL Commands Includes CREATE Statement ALTER Statement DROP Statement TRUNCATE Statement   1. CREATE Statement: By using CREATE Statement we Can create Database Objects Like ( Tables, Views, Indexes,  User Defined Stored Procedures, User Defined Functions, Triggers, Rules,  Defaults) Syntax:-   2.ALTER Statement: By using ALTER Statement We Can modifying  the …

  • 10 April

    Data Types in SQL SERVER

    Data Types in SQL SERVER:    Data Type means the type of data which users provided to a specific column. In SQL Server 2 types of data types available which includes System Defined Data Types User Defined Data Types.       1.System Defined Data Types: SQL Server already contains …

March, 2016

  • 24 March

    Create Foreign key Constraint in Sql Server

    Definition:- it is a column or combination of columns that is used to establish and enforce a link between the data in two tables.Foreign Key can accept duplicate values and Null values.Foreign Key has to take the values from its corresponding Primary Key. Foreign Key  Constraint can be added to …

  • 17 March

    How to Drop a Primary Key Constraints in Sql Server

     In Sql Server, primary key can be created graphically or using a query . 1.Graphically and  2.using a query  1.Graphically :- Expand Databases -> Expand Database(What ever you created) -> Expand Tables->Select table Which Table You Want to  Drop a primary key-> Right Click on table Select Design->Find column Which column applied a primary …

  • Page 3 of 4
    1 2 3 4