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
What is sql collation?
Define inner join in sql server joins?
When is the use of update_statistics command?
What is linked report?
How to test odbc dsn connection settings?
What is use of except clause? How does it differ from not in clause?
what are the three command line utilities and what are their primary functions?
Do you know exporting and importing utility?
Explain tablesample?
What is similarity and difference between truncate and delete in sql?
What is triggers and its types?
What are various limitations of the views?
What command is used to delete a table from the database in the sql server and how?
What is the difference between functions and scalar functions?
Why use “nolock” in sql server?