Unlimited Text

SQL STRING_AGG Function Use and Examples

The STRING_AGG function concatenates strings separated by a specified separator. This was introduced with SQL Server 2017.

SQL ASCII Function Use and Examples

The ASCII function is used to return the ASCII value for the first character in a string.

Evaluating the Randomness of SQL Server Random Number Functions

Microsoft provides T-SQL developers with three functions (rand, newid, and crypt_gen_random) for generating random numbers. Each of these functions is effective at returning random values, but feature sets associated with each function make them best suited to different use cases. This tip’s Solution section presents an overview of common use cases for random numbers in SQL Server along with references to learn more about random numbers in SQL Server.

Date and Time Calculations Made Easy with EOMONTH, DATEDIFF, and DATEADD

Learn how to work with dates and calculate particular dates or elapsed time periods with some of the functions available in SQL Server.

The TEXTSIZE Default

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?