Search: [sql] - links.seigler.net

Common MySQL Queries http://www.artfulsoftware.com/infotree/queries.php

Fri Sep 13 13:13:24 2013

Get a comma separated list of values in SQL with FOR XML http://davidduffett.net/post/5334646215/get-a-comma-separated-list-of-values-in-sql-with-for

Fri Aug 9 12:01:37 2013

uses the STUFF function, more concise than using CASE

Visual_SQL_JOINS_orig.jpg (JPEG Image, 966x760 pixels) http://www.codeproject.com/KB/database/Visual_SQL_Joins/Visual_SQL_JOINS_orig.jpg

Tue Apr 19 16:42:22 2011

Creating XML in SQL Server — DatabaseJournal.com http://www.databasejournal.com/features/mssql/article.php/3885251/Creating-XML-in-SQL-Server.htm

Fri Jun 25 16:49:48 2010

SQL queries can be returned as XML - this article describes some of the formatting options. Of special interest is the use of XPath to control the structure of the XML.

T-SQL Programming Part 1 - Defining Variables, and IF...ELSE logic — DatabaseJournal.com http://www.databasejournal.com/features/mssql/article.php/3087431/T-SQL-Programming-Part-1---Defining-Variables-and-IFELSE-logic.htm

Fri Jun 25 15:13:34 2010

Foundational information about T-SQL

Links per page

Filters