Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / naresh
If you specify this option, later when you delete a row in
the parent table, the database server also deletes any rows
associated with that row (foreign keys) in a child table.
The principal advantage to the cascading-deletes feature is
that it allows you to reduce the quantity of SQL statements
you need to perform delete actions.
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
Name 3 ways to get an accurate count of the number of records in a table?
Explain what are sparse columns?
What is a fill factor?
What happens on checkpoint?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
How to connect ms access to sql servers through odbc?
Explain the commands in sql server?
Explain datetime2 data type in sal server 2008?
What is a result set object returned by mssql_query()?
What is log shipping?
How many databases Microsoft SQL server provides?
What is optimistic concurrency?
Explain full-text query in sql server?
How to apply filtering criteria at group level with the having clause in ms sql server?
