Lab Sql

I currently have a 'Filter' object which corresponds to a business object. This object has… Read more Alternative To Executing Dynamic Sql

I have below query running fine independently, but showing many issues inside a postgres function C… Read more How To Return Temp Table From Postgres Function?

Getting error Invalid column name '@ColumnNames'. in the last line (insert clause), any ide… Read more Selecting Column Name Dynamically In An Insert Query

Hi i have this example DECLARE @XML1 xml, @XPath nvarchar(200), @EncodedXPath nvarchar(200),… Read more Save Result Of Exec Sp_excutequery Using Xpath

Using Microsoft SQL Server 2008, let's say there is a table1 that keeps the selected ids of pro… Read more Howto Build A Sql Statement With Using Ids That Might Not Be Available In The Table?

In PostgreSQL, I would like to create a safe-wrapping mechanism which returns empty result if an ex… Read more Elegant Way Of Handling Postgresql Exceptions?

I have a table with a list of tables in PostgreSQL: |id|table | |--|------| |1 |table1| |2 |table2|… Read more How To Union A List Of Tables Retrieved From Another Table With A Single Query?

I'm trying to Partition a Table by both Year and Month. The Column through which I'll parti… Read more How To Partition A Table By Month ("both" Year & Month) And Create Monthly Partitions Automatically?