Lloyd Harrison (9/26/2008)

---

Wait, I didnt think my chains overlapped.

Here:

ZIP>SCHOOL

ZIP>DISTRICT

My district tabel and school table have a reference to zip.

If I delete ZIP I want to delete both the school and...

That's because the chain of deletes points to the same table more than once IE :

A > B > C > A

If any letter comes in the delete sequence...

Ashwin M N (9/25/2008)

---

I have used a lot of queries in where I am searching for the existance of the certain data.Suppose I have table Users and I am searching...

Solves the problem... and you can check the script for quality control.

y not running it yourself?

That's a completly different topic.

Can you post the DDL along with the requirement of the system?

As anyone measured the cost of sending the whole list of parameters all the time on the network?

Also has anyone ever used a timestamp column to ensure that the row...

As anyone ever tested this thouroughly (the cost of passing all the parameters all the time, VS the cost of the nullif(isnull, Colname)) execution).

If you know that only 1 column...

Jeff Moden (9/18/2008)

---

Heh... not exactly true...

SELECT *

INTO #MyHead

FROM OPENROWSET('SQLOLEDB','Server=(local);Trusted_Connection=Yes;Database=Master',

...

Yes you need to create it first, including column definitions.

Can't be done, must be a temp table.

Also make sure you have enough HD space whereever you put the backups!!!

Here's the gist of the logic, it's in pseudo-code because I don't have a server to test it on ATM.

Make sure you test on dev server first!

SET ROWCOUNT 500000

DELETE FROM...

C'est sure que tu peux renommer des fichiers en .net, mais je connais pas le code qui fait ça.

En plus, si les DB sont online sur le server sql, tu...

Cool, thanks for letting us know!