Monday , December 11 2017
Home / Uncategorized

Uncategorized

sql server Startup Options in SSMS

sqlserver_startupoptions

Normally, after opening up SSMS and once logged in we will Open up a new query window manually to write our scripts but by configuring SSMS startup options we can open new query window or object explorer etc after logged into SSMS immediately Under the Options -> Startup -> At …

Read More »

Lesson 8: Object In C#

studyclues_c_object

c# object: A class and an object are different things. A class defines a type of object, but it is not an object itself. An object is a concrete entity based on a class, and is sometimes referred to as an instance of a class. Objects can be created by using …

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 »

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 »