Nice question, but the explanation doesn't mention why the order of casting vs order by changes. (because of adding the T alias in the second statement)

Easy one, thanks.

sqlbuddy123 (3/3/2014)

---

yashuvp (2/3/2014)

---

Hello,

I am importing data from SQL server into Oracle Database and it's taking too much time. I tried both Native OLD DB and Oracle DB but non of...

Maybe you need to prefix the schema to the table?

Thank...

With project deployment, you cannot use the MSDB database and the SSIS service.

You need to install a database engine and enable the SSIS catalog (which creates the SSISDB database).

You can...

SELECT Child_ID,Age (months),Height(cm),sex

FROM MyTable

ORDER BY Child_ID;

Grant Fritchey (2/27/2014)

---

Koen Verbeeck (2/27/2014)

---

There's a new developer conference in Belgium: Techorama (which replaces two conferences: the Community Day, an organization of all the user groups, and TechDays, a scaled...

Did you install the Oracle Client and the ODAC components?

Did you configure TNSNAMES.ORA?

Are you using the package or project deployment model?

What is your locale?

If "2/27/2014 13:30" is interpreted like "dd/mm/yyyy", you have a problem.

Easy one, thanks.

Grant Fritchey (2/27/2014)

---

Koen Verbeeck (2/27/2014)

---

There's a new developer conference in Belgium: Techorama (which replaces two conferences: the Community Day, an organization of all the user groups, and TechDays, a scaled...

There's a new developer conference in Belgium: Techorama (which replaces two conferences: the Community Day, an organization of all the user groups, and TechDays, a scaled down TechEd-like MS event)....

That's why I started with "maybe"...