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

What is it unwise to create wide clustered index keys?

0 Answers  

How do you identify a foreign key?

0 Answers  

How to start and end transact-sql statements?

0 Answers  

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

0 Answers  

Give main differences between "Truncate" and "Delete".

0 Answers   HCL,

Explain DBCC?

0 Answers   QuestPond,

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

0 Answers  

difference between Clustered index and non clustered index ?

0 Answers   Infosys,

what are user defined datatypes and when you should go for them? : Sql server database administration

0 Answers  

What are the different Authentication modes in SQL Server and how can you change authentication mode?

0 Answers  

Which institute is best for SQL Server 2005 Training?

6 Answers  

What is query processing?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories