Someone earlier asked a good question - does Oracle support the newer syntax?  (I might have to extract data from an Oracle system soon - would hate to have to...

I took great interest in this thread as I am faced with a similar situation - or at least I have been avoiding it and was wondering if I was...

Good info.  There won't be a problem having two DBs containing a file with same logical filename (although I think that within a DB itself you need unique logical filenames).

I...

If you expect to do a wildcard for numbers like

"all numbers beginning with 199", then you will need to cast the numbers to a varchar and feed this into a...

I've always used the newer syntax as it made things obvious and clear to me...  I suppose if I had grown up using the old syntax I might think differently...

Some questions / comments.

Is there any flag in the legacy system to let you know when rows have changed?  This could even be a "last updated" column against the row. ...

If your app is offline and you really do need ALL transactions to fail or succeed, why not

a) Backup the DB before the data insert

b) Perform the insert in small...

The BLOBs in SQL Server work very well - provides some benefits that the file system doesn't offer - but that's another story and not the point of the question...

Or, if you are lucky enough to develop against 2005 exclusively (I'm not in that category yet   ), you could use the new...

I have used param types on stored procs such as image & text - ntext is no different...  That's why if you post code we can perhaps see what you...

Can you plz post code?

Also, if this code is coming to SQL from your client application / web application, you should read about "SQL Injection attacks" and how to prevent them...  Do a search...

After having performed some data extraction work yesterday on a Paradox DB that made use of MUCK tables, I definitely am not in favour of them - at least not...

I suspect the note about nested triggers in the article is stating that one trigger cannot refer to another trigger - it is implicit by performing an action against another...

I see both sides of the argument, except where people claim a MUCK table will make their GUI easier...  I tend to dislike direct mapping of controls such as Grids...