Jeffrey Williams (5/7/2009)

---

Not worried about whether or not I do it right (or you do it right), more concerned about the person who comes behind and does not realize the...

Jack Corbett (5/5/2009)

---

Jeffrey Williams (5/4/2009)

---

I generally use SET myself - mostly because it prevents issues where you can get the wrong value returned from a SELECT. When using SELECT...

Yes, linked reports have a problem. See the following two threads on methods to get around the problem and correct it.

http://www.sqlservercentral.com/Forums/FindPost661300.aspx

http://www.sqlservercentral.com/Forums/FindPost661381.aspx

We now set the page size properties when we...

Lynn Pettis (5/4/2009)

---

Hearing the differences between Oracle and SQL Server, although interesting, is getting a bit old.

Let's remember one crucial thing SQL Server Oracle.

Let's stop complaining about the differences...

Jeff Moden (4/29/2009)

---

JohnG (4/29/2009)

---

Should you wish to parse a string into an Oracle array, there is no real need for the tally table. It will work quite well with...

peter (5/4/2009)

---

JohnG (5/1/2009)In SQL Server have you ever wanted to conditionally consume (e.g., loop through) the result set returned by a stored procedure? For example, the output returned by...

If you do create a TALLY table, for whatever purpose, in Oracle my recommendations are:

1. Create it as an Indexed Organized Table (IOT) using the ORGANIZATION INDEX clause. This...

Or even a PowerShell script to iterate through the list of databases and run the T-SQL script using SQLCMD. See:

http://blogs.msdn.com/buckwoody/archive/2008/11/27/powershell-and-sql-server-use-a-text-file-to-drive-a-script.aspx

Use a batch script at a console prompt running SQLCMD against each database. You can put the names of the databases in a text file. That is how...

RBarryYoung (4/30/2009)

---

Could...

I could create what's called a nested table (a one-dimensional collection) and use that in an inner-join where the inventory Coil Id equals the nested table's coil id, but Oracle...

I have written "portable" stored procedures for both SQL Server and Oracle used by a .Net application.

To return a record set from Oracle to ADO.Net you use "REF" cursors. ...

rboggess (4/29/2009)

---

Why does it seem that everything is three to five times harder to do in Oracle than it is in SQL Server? I'm trying to figure out how...

Don't use OPENXML! Use XQuery. See the following SQL ServerCentral article:

http://www.sqlservercentral.com/blogs/michael_coles/archive/2008/01/20/stop-using-openxml-please.aspx

I agree with Hugo and others that the correct answer is missing from this QoD and yesterday's QoD. As a RDBMS developer for over 30 years (DB2, Oracle, SQL...