Tags » Cursors

Find the database when table name is known

Requirement:

We have a table name or at least a part of it with us. We want to know the database to which it belongs. Manually searching is not possible/ difficult as there are many databases having many more tables. 320 more words

Software

FOREACH in MySQL/MariaDB stored procedures

One of the annoying limitations of MySQL/MariaDB stored procedures is the lack of a FOREACH construct, which loops on each row returned by a query. 694 more words

SQL

SQL Server *Worst* Practices

Here’s a link to a great article I read recently that summarized in a concise package things not to do when using SQL Server as a data-persistence solution, which is almost more important than what to do. 181 more words

SQL Server

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