Dynamic Search Conditions

ow to write a stored procedure that permits users to select among many search conditions, using both dynamic and static SQL.

Calculate Easter Date

A function to calculate the date for Easter Sunday for a given year

Using the CASE expression instead of dynamic SQL

I have a lot of SQL update queries where I need to make IF/ELSE types of decisions. I am using a cursor in some cases but looping through thousands of rows for update takes a long time. I also use some dynamic SQL to handle some query parameter decision making. Is there a better alternative?

Operators

Linking to the Previous Row

One common problem in querying is to reference the previous row in a data set as part of a calculation. David McKinney brings us an interesting solution using SQL Server 2005.

Precedence

Arrays and Lists in SQL Server

Several methods on how to pass an array of values from a client to SQL Server, and performance data about the methods.

Why Object Qualification is important.

You have all read about why object qualification is important. You also must have heard of why stored Proc should not have sp_ as prefix to the name. Now let us proove if this is all true.

Best Way to Calculate Age

Calendar Display with Language Specific Day/Month names

A stored procedure which takes a year and language as parameters and creates a calendar display for these parameters.