Found this article:
http://www.codeproject.com/KB/database/migrate-mysql-to-mssql.aspx
which has saved me a bunch of hairpulling. I was trying to get data
from a MySQL DB into SQL Server 2005 and kept spinning my wheels with
MS' built-in DTS stuff. This solution took all of 5 minutes.
Just
From: Rick Root [mailto:[EMAIL PROTECTED]
Munson, Jacob wrote:
You might also consider investigating the use of the
ISNULL() function
FYI, IsNull() is an MS proprietary function, while
Coalesce() is ANSI
SQL standard. It does the same thing, but using coalesce makes your
code
You might also consider investigating the use of the ISNULL() function
FYI, IsNull() is an MS proprietary function, while Coalesce() is ANSI
SQL standard. It does the same thing, but using coalesce makes your
code more portable.
--
This transmission may contain information that is
Munson, Jacob wrote:
You might also consider investigating the use of the ISNULL() function
FYI, IsNull() is an MS proprietary function, while Coalesce() is ANSI
SQL standard. It does the same thing, but using coalesce makes your
code more portable.
True, and I had never heard of Coalesce,
Thanks Rick, that's handy. I'll burn it into my memory real quick,
as that's one I been customizing for whatever DB i'm using at
the time, for ages. Funny thing is, I used it before, why did I stop?
Ah. the null in the name! Dang it.
etching on brainpan,
:deN
Woot for monday! I must've sent 20
I have a MySQL query that works great, but the IF statement I can't get to work
in MS SQL ... anyone dare to help out
SELECT s.speciesID, s.speciesName,
IF(sf.speciesFusionID IS NULL, 0, 1)
FROM uoaSpecies s
LEFT JOIN uoaSpeciesFusion sf
ON (s.speciesID = sf.speciesID AND
I have a MySQL query that works great, but the IF statement I
can't get to work in MS SQL ... anyone dare to help out
SELECT s.speciesID, s.speciesName,
IF(sf.speciesFusionID IS NULL, 0, 1)
FROM uoaSpecies s
LEFT JOIN uoaSpeciesFusion sf
ON (s.speciesID = sf.speciesID
Thanks folks, that worked perfectly!
Paul Giesenhagen
QuillDesign
417-885-1375
http://www.quilldesign.com
- Original Message -
From: Munson, Jacob [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, June 02, 2006 5:24 PM
Subject: RE: MySQL - MS SQL
I usually use
You might also consider investigating the use of the ISNULL() function
It won't return 0 or 1... it'll return 0 or the value...
ie
SELECT s.speciesID, s.speciesName,
ISNULL(sf.speciesFusionID, 0) as speciesFusionID
FROM uoaSpecies s
LEFT JOIN uoaSpeciesFusion sf
ON
This is a bit off topic.
I am looking for an objective review of the different SQL servers out there.
We are currently getting involved in a project where a department (name
withheld to protect the guilty) is having built an online application using
MySQL, Perl and Apache server. We are being
In my experience, MySQL has been a great server... very fast, very stable.
However, it is missing functions that many rely on with when using MS SQL,
etc. To be fair, the MySQL developers are very up front about what is
missing and when each feature might be implemented, they are very responsive
11 matches
Mail list logo