I have a value that I want to do delete everything from a table that contains this value in a field. Also, each one of those that I delete has an ID that is a foreign key value in another table.

SQL Server allows you to define cascading referential ... a relationship between the SalesHistory and the Products tables. If a delete statement affects rows in a foreign key table, those values ...

Despite these minor drawbacks, I definitely recommend exploring the table parameter feature when SQL Server 2008 comes out. Tim Chapman is a SQL Server database administrator who works for a bank ...

Connect to your SQL Server instance, then in the object explorer pane drill down and highlight a container, such as Tables ... your query then it’s easy to delete ones you don’t require.