Tags » Cursors

Find the database when table name is known


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


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 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

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


Metal Themed Cursors

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