Philip Hendry's Blog

Articles by tag : t-sql

Create SQL Scripts for Data in a table
Apr 8, 2011 • T-SQL • 2 min read

Randomising data in a table using T-sql
Mar 8, 2011 • SQL Server, T-SQL • 1 min read

Grouping Multiple Consecutive Days using T-sql
Feb 21, 2011 • T-SQL • 3 min read

Persisting Object Graphs/Collections to one or more SQL Server Tables in one Stored Procedure Call
Oct 12, 2010 • SQL Server, T-SQL • 3 min read

Calling SQL Server Stored Procedure Synonym fails with parameter error
Sep 2, 2010 • Problem, SQL Server, T-SQL • Less than a minute read

Numbering XML Elements in T-SQL
Jan 5, 2010 • T-SQL • 1 min read

Dynamic Order By in T-SQL
Dec 1, 2009 • SQL Server, T-SQL • 2 min read

Generating a list of numbers in T-SQL
Sep 29, 2009 • SQL Server, T-SQL, Tip • Less than a minute read

Importing from Excel into SQL Server
Sep 15, 2009 • SQL Server, T-SQL • 1 min read

Conditional Aggregate Totals in SQL
Sep 11, 2009 • SQL Server, T-SQL, Tip • 1 min read

Selecting a result set from a stored procedure in SQL Server
Sep 2, 2009 • SQL Server, T-SQL, Tip • Less than a minute read

String Concatenation in T-SQL and Importing from Excel
Jul 31, 2009 • SQL Server, T-SQL • 1 min read

Generating random numbers in a SQL Update
Sep 5, 2008 • SQL Server, T-SQL • Less than a minute read