#temporary table

[banker-hacker]

#plpgSQL function can't just run a query; you have to put the results somewhere.

http://stackoverflow.com/a/16688055/1964078

but you can’t also RETURN QUERY on an anonymous function. so answer is to create a temp table:

http://www.ienablemuch.com/2010/12/return-results-from-anonymous-code.html

[duniailkom]

Tutorial Belajar MySQL: Cara Membuat Temporary Table MySQL

Tutorial Belajar MySQL: Cara Membuat Temporary Table MySQL

Kali ini kita akan membahas salah satu fitur yang disediakan MySQL (dan juga beberapa RDBMS lain seperti SQL Server atau Oracle), yakni tentang temporary table. Kita akan membahas pengertian, fungsi dan cara pembuatan temporary table MySQL.

Pengertian Temporary Table

Sesuai dengan namanya, temporary tabledigunakan untuk membuat tabel sementara di dalam MySQL. Tabel ini hanya ada untuk sementara…

View On WordPress

[seniordba]

Temporary Stored Procedures in SQL Server

Temporary Stored Procedures in SQL Server

You are probably familiar with table variables, local temp tables, and global temp tables but what some people don’t think about is that stored procedures and functions can also utilize the tempdb. As you might imagine, it can be difficult for you to think of a use for temporary stored procedures. It is almost always better to create a permanent stored procedure, but if you are a person that…

View On WordPress