Actually, in 2005, the solution would probably work if a VARCHAR(MAX) data type was used, which supports up to 2GB of data.

I agree with that.  We use cursors a lot, not for iterating through result sets and performing operations on the data with normal cursors, but for executing business rules.  Here...

Anyone know if SQL Server plans on designing triggers in the future to include the FOR EACH ROW clause like they do in Oracle that allows you to treat your...

In your situation, it sounds to me like management really meant, "that sounds like a great idea, but I have no idea what you are talking about".  It are those...

I 100% agree with the comment made by Duray AKAR.  The query listed will never retrieve the results "the students that has...

Great article.  - Tim Chapman