How many characters can be stored in a...

Deduping Data in SQL Server 2005

One of the neatest T-SQL enhancements in SQL Server 2005 is the ROW_NUMBER() function. New author Charles Hawkins brings us an explanation of how you can use this function along with a Common Table Expression to remove duplicate data.

User-Defined string Functions SQLCLR MS SQL 2005

User-Defined string Functions MS SQL Server 2005 Transact-SQL SQLCLR (VB. Net, C#.Net, C++. Net) Ladies and Gentlemen, I am pleased to offer, free of charge, the following string functions MS SQL Server 2005 Transact-SQL SQLCLR (VB. Net, C#.Net, C++. Net): AT(): Returns the beginning numeric position of the nth occurrence of a character expression within […]

What does this return?


declare @p int, @r int
select...

Will this work in SQL Server 2000?

select 1;create...

What does this return?


declare @p int, @r int
select...

You are mentoring a junior DBA and trying...

What is the difference between PATINDEX and CHARINDEX?

Row_Number() function in SQL Server 2005

As we all know, SQL Server 2005 has new features when compared to SQL Server 2000. One of the features that we are going to discuss in this article is the Row_Number() function. SQL Server Database administrators and developers have been longing for this function for a long time--now the wait is over.

You are using SQL Server 2005 and want...