Tuesday, May 7, 2013

calling mysql stored procedures in ssrs 2012?

Probably having a linked server to MySQL is better one



EXEC('CALL ClientSelectExtract
(''2009-10-07'',''2009-10-07'');') AT MySQLSERVER;




Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/



MS SQL optimization: MS SQL Development and Optimization

MS SQL Blog: Large scale of database and data cleansing

Remote DBA Services: Improves MS SQL Database Performance


No comments:

Post a Comment