Adrian Lynch on databases and SQL

Results 1 - 10 of around 2 in sql

Splitting a string with PATINDEX

In ColdFusion we have a bunch of list functions, but what about SQL?

http://www.adrianlynch.co.uk/post.cfm?postID=31 - Monday 7 April 2008 at 15:10 - Full post - Comments(0)

Queries across linked servers in SQL Server 2005

I wanted to do some quick queries with references to both a dev and staging server. To allow this I add the staging server as a linked server. Here's how.

http://www.adrianlynch.co.uk/post.cfm?postID=29 - Thursday 27 March 2008 at 14:29 - Full post - Comments(1)

SQL Server stored procedure template

Whenever I need to create an SP, this is the file I start with.

http://www.adrianlynch.co.uk/post.cfm?postID=16 - Saturday 15 December 2007 at 21:29 - Full post - Comments(0)

Plugging the gaps in a position column

When you delete one or more rows from a table you'll have gaps in a sequential position column. Here's one solution.

http://www.adrianlynch.co.uk/post.cfm?postID=12 - Tuesday 11 December 2007 at 15:37 - Full post - Comments(0)

Reordering rows with a position column in SQL (and a little bit of CF)

One take on reordering data. Given an ID and a direction, we want to reorder rows by updating a position column.

http://www.adrianlynch.co.uk/post.cfm?postID=10 - Tuesday 11 December 2007 at 13:02 - Full post - Comments(1)