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?