I think the "It depends" plays on the level of correlation between the two data sources. That is - if there is a HIGH level of correlation, then the...

Jeff Moden (12/26/2008)

---

Just bought a nice new Calypso Cruiser (bicycle)... 7 speeds... nice super...

ExecuteReader is a little funky when dealing with output parameters. The output parameters are available only AFTER the recordset is used and closed. From MSDN:

Using a DataReader to...

I fully agree with Grant. It's a matter of choice and personal taste. I would add that there are a few jobs that end up with a balance...

The only issue I see with most of the suggestions above is that if you combine 2005 and 2008, you will not be able to move the 2005's out in...

Andrew la Grange (10/26/2007)

---

I've got to agree with Jereme. I'm currently working on a legacy system which is FULL of OUTPUT Parameters (which sadly more often than not contain nothing...

gedlar (12/23/2008)

---

Yes

If you don't have primary keys set...

Agreed....

By the way - here's an example of TYPE being used as a T-SQL keyword:

select * from MyTable

where MyID=1234

for XML path('testing'), TYPE

Not sure why that didn't make the reserved list.

Considering...

Personally - I'd put the server name in the web.Config (or some include file allowed by ColdFusion) instead of hard-coding it everywhere. When you need to connect to the...

TYPE is also used in some FOR XML statements.

UID was ubiquitous in most of the system views in 2000 (sysobjects, sysusers, permisssions, etc....), is a keyword in ado connection strings...

If you're trying to delete "from the user interface" - you mean deleting rows from the Access interface in linked tables?

If you don't have primary keys set up (or didn't...

You can't use an IP address as the alias, and especially not the loopback address (127.0.0.1). The loopback address is a TCP/IP reserved address meaning "this machine I am...

Jeff Moden (12/22/2008)

---

Kit Brandner (12/22/2008)

---

Try a 23-character long alphanumeric PIN code with certain characters excluded for legibility that can't be repeated in the database. So Jeff's solution wouldn't work. I...

I've used BCP to do just that in the past. I forget the actual command line switches, but go with ASCII, no delimiters, and dump it right into a...