I am using SQLALchemy to execute queries on Teradata. One of the queries I execute is a DDL statement to replace a stored procedure: REPLACE PROCEDURE DEV_MIGRATION_TOOL.UNIT_TEST_NEW_STORED_PROCE...

I am working on an existing SSIS package to add custom logging to it. I am trying to test it, and I have an Execute SQL Task that I didn't create that is getting the following error. Executing the...

I have a stored procedure which loads data into a target table and works fine when run in a session with my AD credentials. When I try to run it in a job (again with my AD details in the Run As op...

I am getting this error javax.servlet.ServletException: com.mysql.jdbc.NotUpdatable: Result Set not updatable. I know this error is regarding the primary key but for all my tables I initiall...

I have multiple EXECUTE IMMEDIATE commands within one oracle procedure. EXECUTE IMMEDIATE 'DELETE FROM tbl1'; EXECUTE IMMEDIATE 'INSERT INTO tbl1...'; COMMIT; EXECUTE IMMEDIATE 'DELETE FROM tbl3...

I have the follow code in a servlet - String loginID = request.getParameter("loginId").toString(); String loginPassword = request.getParameter("loginPassword").toString(); String strSQLcount =...

How can I execute the results of my select query. The query below gives me some SQL statements back as result. I want to execute does statements, how to do this? All this is executed in SQL Sever M...

I'm using a Linq DataContext.ExecuteQuery("some sql statement") to populate a list of objects var incomes = db.ExecuteQuery<IncomeAggregate>(sqlIncomeStatement(TimeUnit)); The IncomeAggre...

So, with the advent of the dynamic keyword in C# 4.0 I am hoping I can find a better solution to the problem of dealing with types returned by DataContext.ExecuteQuery when arbitrary columns are se...

I've written an app that I use as an agent to query data from a database and automatically load it into my distributed web cache. I do this by specifying an sql query and a type in a configuration...