Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main difference between constraints(like
primary key etc..)& joins?
- 2 Answers
- 6304 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Tell me the use of keyword with encryption. Create a store procedure with encryption?
What are triggers in ms sql server?
How does stuff differ from the replace function?
How to Check if table exists in sql server?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
What is primary key, unique key, and foreign key?
What is normalization according to you and explain its different levels?
What are sp_configure commands and set commands?
Explain different types of lock modes in sql server 2000?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
Define constraints and give an example of their use?
What is BCNF? How is it better than 2NF & 3NF?
How to create new tables with "create table" statements in ms sql server?
What is dimension table? : sql server analysis services, ssas
Is foreign key a primary key?
