About 1,074,050 results (2,666 milliseconds)
stored procedures and ROR
https://groups.google.com/g/rubyonrails-talk/c/TB1xKMK6hq4 Jun 21, 2010 ... Delete. You do not have ... while row = MySQL::fetch_array(stmt) records ... using stored procedures in Ruby on Rails and you will get a lot of
Go MySql - out parameter
https://groups.google.com/g/golang-nuts/c/5AJyGW9d9Wg Does anyone know how to execute mysql stored procedure with output parameters? ... row\rows in my case ... Stored procedures might return multiple results ...
execute() with stored procedures that don't return a ResultSet
https://groups.google.com/g/h2-database/c/VLbCEJoGXdA This is the function I'm using to test it. ... (MySQL, Derby, MSSQL, Sybase). CALL should only ... I guess those are essentially non-functioning in H2 since there is ...
Use MySQL database auditing | Cloud SQL for MySQL | Google Cloud
https://cloud.google.com/sql/docs/mysql/use-db-audit When I create, update, or delete an audit rule using stored procedures, I see the following error. The MySQL server is running with the read-only option so it ...
Delete all rows in BigQuery and other DML statements to add ...
https://cloud.google.com/blog/topics/developers-practitioners/bigquery-explained-data-manipulation-dml Nov 13, 2020 ... In the example below, values to be inserted are computed using a subquery that performs JOIN operation with multiple tables. Loading...
MySQL FOUND_ROWS() when using LIMIT
https://groups.google.com/g/railo/c/XiG1v1ILUFs LIMIT, the record count is 20. I used SQL_CALC_FOUND_ROWS after my select statement and then both: SET @rows = FOUND_ROWS();. and. SELECT FOUND_ROWS();. after ...
A general way to batch SQL queries in Django
https://groups.google.com/g/django-developers/c/3Lk-HEF16iI Feb 27, 2015 ... Stored procedures, at least with MSSQL, provide another way of returning multiple result sets with a single SQL statement. The queries will be ...
JDBC: getMoreResults() versus rs.next() & autoGeneratedKeys
https://groups.google.com/g/comp.lang.java.programmer/c/SpyJVtDWHgM > IIRC multiple ResultSet[s] can be returned from a stored procedure, in > this case you would need to iterate over the ResultSet[s] using the > method ...
use stored proc that return multiple columns in a query
https://groups.google.com/g/comp.databases.informix/c/EVN0BEEcEJo Oct 6, 2008 ... Using isql/dbacces running the following: execute procedure get_product_info(1) ;. 684: Function (informix.get_product_info) returns too many ...
Is there a SQL Server CDC connector for Kafka Connect?
https://groups.google.com/g/confluent-platform/c/UXTojFZoZfk Jun 3, 2016 ... We are trying to replicate a MSSQL database into Kafka with Connect. I've seen MySQL BinLog and Postgres connectors, but haven't found one ...
Threads blocking on database connection pool
https://groups.google.com/g/railo/c/8bud4ZI26rk getNext() is returning a row from an in memory query, do Work() is calling a couple of stored procedures on a remote mysql database, typically taking around ...
Re: Best approach for temp table creation, population, invocation of ...
https://groups.google.com/g/mybatis-user/c/8f7QwKpudi0 Jan 7, 2013 ... ... stored procedure, all within same session ... If you're using a connection pool and have multiple ... delete the rows with that UUID. All that ...
Optimize query computation | BigQuery | Google Cloud
https://cloud.google.com/bigquery/docs/best-practices-performance-compute Database replication using change data capture ... stored procedures to perform the computations ... You can automatically delete a large destination table by using ...
Can SQLAlchemy execute multiple select statements in a single ...
https://groups.google.com/g/sqlalchemy/c/-8dIb-VX1tI May 23, 2013 ... DBAPI does have specified support for multiple result sets, as when a stored procedure returns multiple result sets; SQLAlchemy has a long ...
How to do...well...anything...in DB2 SQL
https://groups.google.com/g/comp.databases.ibm-db2/c/x44pihQz158 Returning rows from a stored procedure. SQL Server ... or should i be using VALUES along the lines of: ... Extending this syntax to generate multiple rows like so:.
stored proc, sqlcode = 100
https://groups.google.com/g/sybase.public.powerbuilder.general/c/qfe-jTKCvt4 Feb 11, 2004 ... I have a stored procedure that updates a table in the database. How come SQLCA.SQLCode returns 100? The row in
Please share your thoughts on how to replace JPA/Hibernate by ...
https://groups.google.com/g/jooq-user/c/26Bd8wnwJgQ Jul 27, 2013 ... ... stored procedures but sometimes it's the best way to handle bulk operations. It's a bit like comparing DOM and SAX, you use one when you can ...
Turbogears now based on Pylons!
https://groups.google.com/g/pylons-discuss/c/Wx7dkH23KsE provided you don't have huge databases or stored procedures. The "huge database" part is outside your control, but the stored procedure part is. Tying ...
Work with SQL stored procedures | BigQuery | Google Cloud
https://cloud.google.com/bigquery/docs/procedures You name and store a procedure in a BigQuery dataset. A stored procedure can access or modify data across multiple datasets by multiple users. It can also ...
MyBatis + Spring + Batch Inserts
https://groups.google.com/g/mybatis-user/c/UOIpYE6kDh0 Has anyone had any success getting MyBatis to do batch inserts with. Spring? If so, could you share some sample code? I'm currently using the work ...