63 reputation
5
bio website
location Atlanta, GA
age 44
visits member for 2 years, 5 months
seen Aug 7 '12 at 19:02

Jul
9
awarded  Popular Question
May
2
accepted In a CASE Statement, which is faster: “WHEN [field] in (0)” or “WHEN [field] = 0”?
May
2
asked In a CASE Statement, which is faster: “WHEN [field] in (0)” or “WHEN [field] = 0”?
Mar
21
awarded  Supporter
Mar
19
comment Update existing data with excel import
The update statement would look the same, you can just treat the excel worksheet like a table using openrowset. Here's another link that may show you in more detail: beyondrelational.com/quiz/sqlserver/tsql/2011/questions/…
Mar
16
awarded  Teacher
Mar
16
comment Correct SQL Server linked server connection settings to MySQL that will allow inserts
Is there a 64-bit 5.0 ODBC Driver? I installed the 32-bit version that I found but when I start to add a new DSN I only see the 5.1 driver in the list of drivers available. Do I need to uninstall the 5.1 driver? Reboot the server?
Mar
16
comment Correct SQL Server linked server connection settings to MySQL that will allow inserts
The MySQL server is a hosted server at GoDaddy.com so I'll have a go at downgrading the ODBC Driver.
Mar
16
answered Update existing data with excel import
Mar
15
awarded  Student
Mar
15
awarded  Scholar
Mar
15
asked Correct SQL Server linked server connection settings to MySQL that will allow inserts
Dec
30
asked SQL 2005: logical consistency-based I/O error: incorrect checksum