Monday , December 11 2017

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 »

Lesson 5: TypeCasting or Type-Conversion in C#

TypeCasting or Type-Conversion in C#: Programming in any language will involve manipulation data. For Accessing Memory we use variables. We can create specific type of variable to access some data. C# allows us to create variables of many types but, being a statically typed language, it does not allow us …

Read More »

Lesson 4: DataTypes in C#

DataTypes in C#:  C# is a strongly typed and rich language; therefore every variable in C# is associated with a Data type. Data types specify the type of values that can be stored in a variable. C# provides all the data types that are available in Java, and adds support …

Read More »
Page 10 of 11
1 8 9 10 11