Monday , December 11 2017
Home / 2016 / April

Monthly Archives: April 2016

Create Not Null Constraint in sql Server

Create Not Null Constraint in sql Server: Not Null: If it is imposed on a column that column will not allow Null Values into it; this can be imposed on any no of columns. Syntax:- [crayon-5a2e838f46127946566977/] Example:- [crayon-5a2e838f46132651519479/] Explanation:-  The above Example Explains you the Empid Column Not allowed Null …

Read More »

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-5a2e838f46904793413026/]     Example: [crayon-5a2e838f4690b506428838/] Explanation: The Above Example Explains you the Employee salary Should be more than 1000 .If …

Read More »

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 …

Read More »

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 …

Read More »

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 …

Read More »

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 …

Read More »

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 …

Read More »

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 …

Read More »

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 …

Read More »

Lesson 6: Boxing and UnBoxing in C#

Boxing and UnBoxing in C#: Previously we have seen TypeCasting Now We Will see Boxing and UnBoxing in this Article. Boxing: Boxing is the process of converting a value type to the type object. Or The operation of Converting a Value Type to a Reference Type is called Boxing and the reverse operation is …

Read More »
Page 1 of 2
1 2