Description Usage Arguments Note Examples
This function allows user to drop table, delete rows in table or create new table on SQL Server.
1 | send_SQL_task(connectionString, sqltask)
|
connectionString |
Connection string to SQL server. |
sqltask |
SQL query for retrieving data from SQL server. |
How to set up SQL Server connection string see set_connString.
1 2 3 4 5 6 | ## Not run:
send_SQL_task(connectionString, "CREATE TABLE dbo.TableName (ID int not null, Name varchar(100))")
send_SQL_task(connectionString, "DELETE FROM dbo.TableName WHERE ColumnName = 'SomeValue'")
send_SQL_task(connectionString, "DROP TABLE dbo.TableName")
## End(Not run)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.