Philip Hendry's Blog

Articles by tag : sql-server

Randomising data in a table using T-sql
Mar 8, 2011 • SQL Server, T-SQL • 1 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

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

Sproc Compile Locks
Sep 21, 2009 • SQL Server, 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

SQL Server Replication : Lesson 1
Mar 14, 2008 • SQL Server • 2 min read

Exclusive Queries in SQL Server
Mar 5, 2008 • SQL Server • Less than a minute read