Product: SQL Server 2008
Product: My SQL 5.1
'SELECT * from DBName.TableName ')
Any ideas how you could stuff that into a FUNCTION? That way I could use it on a Linked Server with about 300 DB that all have the same schema and pass two parms.
One parm the DB name and one parm the Table name and use a statement like Select * from mylinkedservername('DBName','tablename') to retrieve a MY SQL table from my linked server.
View Complete Post