SQL Server Cursor Example

I know SQL cursors exist, but I am not sure how or why to use them. Can you provide a SQL cursor example? Can you give any guidance on when to use a SQL Server cursor?

Return stored procedure parameter values to a calling stored procedure

In a previous topic we discussed how to pass parameters into a stored procedure, but another option is to pass parameter values back out from a stored procedure. One option for this may be that you call another stored procedure that does not return any data, but returns parameter values to be used by the calling stored procedure.

Getting the TEXTSIZE

Using the CASE expression instead of dynamic SQL in SQL Server

I have a lot of SQL update queries where I need to make IF/ELSE types of decisions. In some cases, I am using a cursor 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?

The Subtle Differences Between COALESCE and ISNULL

See how ISNULL and COALESCE behave in different situations and ensure you know which one to pick when.

Elements of the SQL Server Update Statement

Learn how to use the UPDATE statement, along with a few things to be aware of when changing data.

The Long String

Understanding UNION and UNION ALL in SQL Server

A short look at the differences in UNION and UNION ALL in a SELECT query.

Replacing a NULL II

Basic Regex Emulator for SQL Server

Regular expressions (REGEX) let you adaptively investigate, employ, and authenticate text data. This makes it easy to search for simple or complex string patters. There is no direct way to do this in SQL Server, but in this article we look at some SQL functions you can create to emulate regex like functionality.