Wednesday , October 17 2018

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 »

Lesson 2:Dot Net FrameWork

Dot Net FrameWork: The Main hearth For the Visual Studio is FrameWork. The .NET Framework is set of technologies that form an integral part of the .NET Platform. It is Microsoft’s managed code programming model for building applications that have visually stunning user experiences, seamless and secure communication, and the ability …

Read More »

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 …

Read More »

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 …

Read More »

Constraints in SQL Server

Constraint are using to restricted the insertion of unwanted data in any columns. we can create constraints on single or multiple columns of any table. It maintain the data integrity of  the table. Constraints can be specified when the table is created (inside the CREATE TABLE statement) or after the …

Read More »

How to Create A Table

       Definition of Table:- A Table is an object Used to Store data in Rows and Columns Formate.A Single Table Stores information about a particular topic, Such as customers,products, or orders etc.      In Sql Server, Tables can be created graphically or using a query. 1.Graphically and 2.using …

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