Tags » Cursors

Generate insert scripts from a result set of SQLserver table

Requirement:
We have a table called employee which contains two columns eno, esal. The table contains ten records.
We are supposed to create a similar table with the same values in other server/database. 200 more words

Software

Metal Themed Cursors

All the cursors got a rework expect the ones from dominion 103 more words

Interface

MySQL/MariaDB cursors and temp tables

In MariaDB and MySQL, cursors create a temporary table.

Does this statement deserve a whole blog post? Apparently not. However, in some cases one does not expect a temporary table to be created: 195 more words

SQL

The Power of the Oracle Trace Files

Although I had different topics planned for my first blog, but I just received this client issue this morning, and I decided to share it with you to explain how to take advantage of the powerful information contained in the oracle trace files. 1,268 more words

Database

Advanced SQL - Temporary Tables, Cursors, Creating and Using Stored Procedures, Designing and Using Triggers, Using SELECT Commands with UPDATE and DELETE, Embedded SQL, Programming with SQL

http://www.knowsh.com

Temporary Tables, Cursors, Creating and Using Stored Procedures, Designing and Using Triggers, Using SELECT Commands with UPDATE and DELETE, Embedded SQL, Programming with SQL… 13 more words

Knowsh