• ExecuteSQL *

This function allows for the execution of an arbitrary SQL query, probably most useful for calling from a rowset action.

This routine would be a useful starting point for developing a custom rowset action.
  • ExecuteSQL( connection string , SQL ) *
The first parameter is the connection string to be used, any OLEDB provider can be used, the second parameter is the text of the SQL query.

A user can execute any SQL statement for that their SQL login would normally have the rights to execute.

NOTE: This code has been placed in a separate assembly and it should be deployed with the default option of impersonating the current user. If you deploy with the option of impersonating the Service Account there is a risk that the SQL statements could be executed with elevated privileges depending on the rights that have been given to the service account.

call SQLQuery.ExecuteSql(
    "provider=sqlncli;server=localhost;database=AdventureWorksDW;trusted_connection=yes"
    ,"Create TABLE myTable (id int)");
GO
call SQLQuery.ExecuteSql(
    "provider=sqlncli;server=localhost;database=AdventureWorksDW;trusted_connection=yes"
    ,"INSERT INTO myTable VALUES(1)");
GO
call SQLQuery.ExecuteSql(
    "provider=sqlncli;server=localhost;database=AdventureWorksDW;trusted_connection=yes"
    ,"SELECT * FROM myTable");
GO
call SQLQuery.ExecuteSql(
    "provider=sqlncli;server=localhost;database=AdventureWorksDW;trusted_connection=yes"
    ,"DROP TABLE myTable");

Last edited Dec 31, 2011 at 8:15 AM by dgosbell, version 5