All Articles -> SQL Server Queries

Using Dynamic SQL in Stored Procedures ( 7 March 2011 - Bill Graziano - 20 Comments)

Joining to the Next Sequential Row ( 2 April 2008 - Paul Alcon - 21 Comments)

Writing Outer Joins in T-SQL ( 11 February 2008 - Kathi Kellenberger - 14 Comments)

Aggregating Correlated Sub-Queries ( 23 October 2007 - Jeff Smith - 2 Comments)

How to Use GROUP BY with Distinct Aggregates and Derived tables ( 31 July 2007 - Jeff Smith - 5 Comments)

How to Use GROUP BY in SQL Server ( 30 July 2007 - Jeff Smith - 7 Comments)

Returning Complex Data from User-Defined Functions with CROSS APPLY ( 11 June 2007 - Jeff Smith - 4 Comments)

Returning a week number for any given date and starting fiscal month ( 2 May 2007 - Paul Alcon - 8 Comments)

Common Table Expressions ( 15 August 2006 - Bill Graziano - 0 Comments)

Using CROSS APPLY in SQL Server 2005 ( 4 May 2005 - Bill Graziano - 18 Comments)

Regular Expressions in T-SQL ( 24 June 2003 - Guest Authors - 45 Comments)

Spotting breaks in data sequences ( 16 July 2002 - Bill Graziano - 11 Comments)

Case sensitive queries ( 21 June 2002 - Bill Graziano - 0 Comments)

Statistics in SQL (Sample Chapter) ( 27 May 2002 - Bill Graziano - 3 Comments)

Generating ADO Parameters with Information Schema Views ( 10 December 2001 - Garth Wells - 8 Comments)

Displaying Images that Reside in a Database ( 13 November 2001 - Bill Graziano - 0 Comments)

Cursor Performance ( 17 September 2001 - Bill Graziano - 13 Comments)

Using Len() in a Select Statement ( 1 August 2001 - Damian Maclennen - 15 Comments)

Trees in SQL ( 7 June 2001 - Bill Graziano - 0 Comments)

Answering a SQL Query Question from a Recruiter ( 28 March 2001 - Bill Graziano - 7 Comments)

OLE DB Connectivity ( 22 March 2001 - Bill Graziano - 0 Comments)

More Recordset Paging ( 9 March 2001 - Rob Volk - 0 Comments)

Another Recruiter Asks a SQL Question ( 7 March 2001 - Bill Graziano - 14 Comments)

Quoted Identifiers in SQL Server 2000 ( 11 December 2000 - Brent Huscher - 2 Comments)

Returning a Row Number in a Query ( 5 December 2000 - Bill Graziano - 28 Comments)

String Functions: Incrementing a Number in a Char ( 27 November 2000 - Bill Graziano - 9 Comments)

Let SQL Server Write SQL Statements ( 10 November 2000 - Bill Graziano - 6 Comments)

SQL Query asked by a recruiter ( 7 November 2000 - Bill Graziano - 15 Comments)

Group By using Weeks ( 2 October 2000 - Bill Graziano - 16 Comments)

Cursors: An Overview ( 30 August 2000 - Bill Graziano - 2 Comments)

Using ISNULL ( 25 August 2000 - Bill Graziano - 5 Comments)

Keeping Data in Temp Tables ( 21 August 2000 - Bill Graziano - 2 Comments)

Comparing Dates ( 21 August 2000 - Bill Graziano - 4 Comments)

Converting Multiple Rows into a CSV String ( 15 August 2000 - Chris Miller - 9 Comments)

Computed Columns ( 10 August 2000 - Bill Graziano - 1 Comment)

SQL Subqueries from ASP ( 9 August 2000 - Bill Graziano - 0 Comments)

Using VBScript to make a new SQL Server Database ( 2 August 2000 - Bill Graziano - 0 Comments)

Dates in SQL Server ( 1 August 2000 - Bill Graziano - 7 Comments)

Dynamic SQL or How do I SELECT TOP @var records? ( 1 August 2000 - Bill Graziano - 12 Comments)

Writing dyanmic SQL in an ASP page ( 29 July 2000 - Bill Graziano - 3 Comments)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -