Archive for November, 2013

Pulling data from MYSQL using OPENQUERY

November 7, 2013
SELECT * FROM OPENQUERY([LINKEDSERVER], ‘SELECT * FROM datbase.table where timestamp > ”20131105” limit 10’)
  
Example query – note that date in format ‘2013-NOV-13’ are not supported, the least confusing format I could find is 20131113 (yyyymmdd)
 
Advertisements