what is the main difference between constraints(like
primary key etc..)& joins?
Answer Posted / 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 |
Post New Answer View All Answers
Give an example of SQL injection attack ?
What is sql service broker?
How to use "begin ... End" statement structures in ms sql server?
Tell me what do you understand by a view? What does the with check option clause for a view do?
Can you explain different types of locks in sql server?
What is a functions and types in sql server?
What is change data capture (cdc) in sql server 2008?
What are magic tables in sql server?
What is full outer join in sql server joins?
What is difference in performance between insert top (n) into table and using top with insert?
Which are new data types introduced in sql server 2008?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
What is sql server english query?
How can we delete a table in sql server?
What is delete query?