Hi,

I want to create a procedure to delete Production.Product table by ProductID in AdvetureWorks Database.

How to do it? Because Table Product's too many relationship :(

THANKS!

If there are FK's enforced, then you have to make sure you first delete all child records, before you can delete the product.

I've tried your way but don't delete data. As I know, must use Cascade Delete.

So you may not be doing it correctly. Here is a link to an explanation from someone who has already asked similar question on another forum. I can't explain better than that...

I tried but still not done.

Because Product table of the database Adventure Works has too many relationships!

Has anyone done this yet?

Database system: SQL SERVER 2008

Hi,

I want to create a procedure to delete Production.Product table by ProductID in AdvetureWorks Database.

How to do it? Because Table Product's too many relationship :(

THANKS!