Chim Kalunta (10/1/2009)

---

Sure.

ALTER TABLE [dbo].[ForeignKeyTable] WITH CHECK ADD CONSTRAINT [FK_ForeignKeyTable_PrimaryKeyTable] FOREIGN KEY([col_fk])

REFERENCES [dbo].[PrimaryKeyTable] ([col_pk])

ON DELETE CASCADE

The key clause in the code above is the ON DELETE CASCADE. ...

would you be so kind to post an example.

Steve Jones - Editor (9/29/2009)

---

Yes, but be sure this is what you want. In a FK, you have to remove all children before you can remove a parent. Note that...

ok...so i have...

Steve Jones - Editor (9/29/2009)

---

This should work, providing that you have the proper columns linked. Note that you're writing an old style join, which is not recommended. You ought to...

igngua (9/29/2009)

---

igngua (9/29/2009)

---

igngua (9/29/2009)

---

GSquared (9/29/2009)

---

Before you jump in and try this on a production database, test it first on a copy of the data that you can replace if it...

igngua (9/29/2009)

---

igngua (9/29/2009)

---

GSquared (9/29/2009)

---

Before you jump in and try this on a production database, test it first on a copy of the data that you can replace if it gets...

igngua (9/29/2009)

---

GSquared (9/29/2009)

---

Before you jump in and try this on a production database, test it first on a copy of the data that you can replace if it gets messed...

thanks...

GSquared (9/29/2009)

---

Is "desprod" the column you want to change?

If so, try this first:

select replace(desprod,left(desprod,PATINDEX('%/%',desprod)),'')

from dbo.MyTable;

You'll need to use the actual table name, where I have "MyTable".

Does that give you a...

Thanks!

So the procedure looks like ;

PROCEDURE [dbo].[limpiar]

AS

BEGIN

declare @result varchar(20)

select @result = 'desprod'

select PATINDEX('%/%',@result)

select...

GSquared (9/28/2009)

---

Patindex finds the first place that the substring appears. It nests that in Left, which gets everything up to that point. Then it replaces that in the...

what should be @result value...that confused me ...

thanks !! i dont understand de meaning of this one ...

"select @result = 'testdb/sysdb'"

Grant Fritchey (9/25/2009)

---

Usually, delete the data in the referring tables first. Alternatively you could set up your foreign key constraints with cascading deletes. This is considered a dangerous approach, so...