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

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

0 Answers  

What is scalar user-defined function?

0 Answers  

What is trigger and different types of Triggers?

0 Answers   QuestPond,

What is 1nf 2nf?

0 Answers  

What is a transaction and what are ACID properties?

14 Answers   Config Systems, IBM, TCS, Virtusa,

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

0 Answers  

How to end a stored procedure properly in ms sql server?

0 Answers  

How many types of keys are there?

0 Answers  

How do I port a number to sql server?

0 Answers  

What are scalar functions?

0 Answers  

Why use “in” clause in sql server?

0 Answers  

Can you explain different types of joins?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories