Description Usage Arguments Examples
View source: R/hrsampleCreateSQLServer.R
This function loads the hrsample tables to a Microsoft SQL Server database that the user has access to. It utilizes the odbc package . The parameters are based on the odbc parameters.
1 2 3 | hrsampleCreateSQLServer(driver = "ODBC Driver 13 for SQL Server",
dbname = "master", server = NULL, user = NULL, password = NULL,
port = 1433)
|
driver |
Driver that will be used to connect to SQL Server. Might be something like 'ODBC Driver 13 for SQL Server'. |
dbname |
The name of the database the tables will be stored to. Must be a preexisting database. Ideal name would be "hrsample". This function does not create a new database. |
server |
Name of the SQL server. If working with a remote database, may be something like "johnny.heliohost.org". If working with a database on your local machine it might be "localhost\\SQLEXPRESS". |
user |
Username to log into database |
password |
Password for user |
port |
port to be used |
1 |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.