Creating a deep hierarchy with FOR XML
I have two tables in an application that I support. One is called [Report], and the other is [ReportParameter].
--SAMPLE...
2011-01-27
18,962 reads
Using the MERGE statement
I love MERGE. You know all those awful IF BEGIN END ELSE BEGIN END blocks you need to write for...
2011-01-17
4,068 reads
Wiring up a common click event handler in an ASP.NET page
I was just refactoring a server-side control and ran into some horrible code. Basicaly there was a big listbox that...
2010-12-30
3,105 reads
How to tell if a property exists by name
I recently was working on a library to manage reports in an application (probably a good candidate for an open source project)...
2010-12-29
670 reads
Blogs
T-SQL Tuesday #186–Agent Jobs
By Steve Jones
It’s that time of the month again, when the T-SQL Tuesday blog party takes...
T-SQL Tuesday #186 - Agent Job History Visualization
By alevyinroc
I’m hosting T-SQL Tuesday this month and our topic is Managing SQL Agent Jobs....
KDA: Echoes of Deception - Case 2
By Zikato
The people of Digitown are being targeted by phishermen, and they need my help...
Forums
Execution Plan Operators
Comments posted to this topic are about the item Execution Plan Operators
Just To Talk – Your Safe Space for Online Therapy
Welcome to Just To Talk, your trusted platform for compassionate, confidential online therapy. At...
Merge spans with Dates Logic
--for a given member if the startdate and endate is continous we need to...
Question of the Day
Execution Plan Operators
When looking at an execution plan in SSMS, what types of operators are shown?
See possible answers