The script below is part of a large batch script to create shadow tables (same field names and datatypes)

with additional fields.  Embed part of this or similar code into a...

I have managed to create a simple database in SS2005 express.  I connected from C# esxpress beta1, opened a query and entered create database <dbname>.  I got an error message...

I have to correct myself. This is not a bug.  The update statement must fail on the row where F4 is null.  From the view's perpective this row does not...

I have spent a few nights this week installing SQL Server 2005 Express and C# Express. It took some time to prune my system drive sufficiently on my old spare...

Thanks for the URL, interesting article, doesn't mention speed implications tho'.  Maybe there is no difference.

Cheers,

Win

You can turn off recursive triggers which is global for a database or include some code at the start of a trigger to terminate the trigger if an instance of...

If you get the same error messages as before: ora-03113 followed by ora-12571 it means your packet did not arrive because you got kicked off the oracle instance. You...

The ora errors indicate that you are killing or diconnecting your session to the oracle instance. I assume you are executing a public procedure inside an oracle package from...

 A primary key uniquely identifies a row in a table by definition. In changing the value of it's unique identifier, you have created a new...

quote:

---

Again, however, you are trying to apply procedural logic to a set based system. Databases are not meant to be procedural....

My comments to cascading updates particular in a master-detail data model:

In SS the order of deleted and inserted rows (after statement) can get out of sync if the primary key...

I develop in both environemnts. Usually, I remain a couple of weeks in one environment to reduce the number of transition errors. It helps to look at problems...