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...

Search for an expression in the body of programmable objects

Sometimes you want to modify an object (like a stored procedure, Function, trigger and view) and you can not remember the name of that object, but you remember some words of the comments that you placed in the body of that object. If this is your case, you can use the following procedures depending on […]

What will this code return? (MyTable.MyChar = "ZY")

update mytable
...

What will be the output of this piece...