-
Recent Posts
Recent Comments
Archives
- November 2013
- October 2013
- August 2013
- July 2013
- June 2013
- March 2013
- January 2013
- December 2012
- November 2012
- October 2012
- June 2012
- January 2012
- April 2011
- March 2011
- April 2009
- March 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- April 2008
- March 2008
Categories
Meta
Monthly Archives: June 2008
SQL – Using COALESCE to Build Comma-Delimited String
I had a query that returned one column with multiple records. I wanted only one record with all the values to be comma separated. I could do this with a cursor, but that throws a big warning sign. So i … Continue reading
Posted in SQL Server
Leave a comment
How to find SQL Relationship and Dependencies (Dependency)
SQL SERVER – Query to display Foreign Key relationships and name of the constraint for each table in Database. I tested the query at the following website and it seems to work. In the response section someone claims … Continue reading
Posted in SQL Server
Leave a comment