On 30 June 2014 02:44, Ira Sharenow <irasharenow...@yahoo.com> wrote:
> I wish to query tables that are NOT in the default SQL Server 2012 database.
> Now for the problem. I also want to read in the table dbo.sports. That
> table is in the database sportsDB. I did not see any way to do so from
> within R.

Can you not use sportsDB.dbo.sports to reference the table?

In general, table reference syntax is [ [ [ serverName '.' ]
databaseName '.' ] [schema ] '.' ] tableName, where the names need
only be surrounded by [...] if they are not valid SQL Server
identifiers.  Many people may suggest you reference
[sportsDB].[dbo].[sports]; this is unnecessary verbiage.

Cheers,

- Peter

______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Reply via email to