Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

what is the main difference between constraints(like
primary key etc..)& joins?

Question Posted / amit

Answers were Sorted based on User's Feedback



what is the main difference between constraints(like primary key etc..)& joins?..

Answer / ravikiran

Constraints are the mechanisms used by the sql server to
control unwanted or invalid data flow into a table.

Joins are the queries used to combine the rows from two or
more tables.

Is This Answer Correct ?    2 Yes 0 No

what is the main difference between constraints(like primary key etc..)& joins?..

Answer / monal

Constraints are restrictions to make sure that data entered
in a table must meet certain crietria. You can put
constraint at either table level or column level. There are
5 types of constraints. Primary Key, Foregin Key, Unique,
Check and NOT NULL.

Joins are used to combine rows from one or more table. One
table using Self Join and More tables using inner join,
outer join, cross join.

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More SQL Server Interview Questions

Is resultset an interface?

0 Answers  

How can I check that whether automatic statistic update is enabled or not?

0 Answers  

How many types of local tables are there in sql server?

0 Answers  

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 Answers  

What to perform pattern match with the like operator?

0 Answers  

What is the difference between migration and upgradation in sql server?

0 Answers  

What is sql server agent and what are the two modes of authentication in sql server?

0 Answers  

What is the use of set nocount on/off statement?

0 Answers  

Does the order of columns in update statements matter?

0 Answers  

How to find the login name linked to a given user name?

0 Answers  

Write a query to delete duplicate records in SQL SERVER

36 Answers   Infosys,

Can a table have 2 foreign keys?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories