Thursday , October 18 2018
Home / 2016 / March

Monthly Archives: March 2016

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 »

Visual Studio Shortcut Keys

Visual Studio ShortCut Keys

Visual Studio Shortcut Keys: All We Know By Using Visual Studio We can make different types of Applications By using Short cut keys we can complete our project in very fastly. Visual Studio Code lets you perform most tasks directly from the keyboard. This page lists out the Short Cut Keys …

Read More »

Create a Database In SQL Server

Create a Database In SQL Server Database:- A Database is a Systematic Collection of Data.It Contains Tables,Rows and Columns. Database Management System:-A Database Management System is a Collection of programs that enables you store,Modify and Extract Information from a Database.   In SQL Server Management Studio We can Create a …

Read More »

How to Connect SQL Server

How to Connect SQL Server: Once you Installed sql server Successfully  on your machine,You Should Follow Following Steps to Connect SQL Server:- 1.Go to Start Menu->All Programs ->Microsoft SQL Server 2008/2012 or any version  Folder -> Select  SQL Server Management Studio. Next We Will Get Like This:       …

Read More »