Correction to parsestring

The original function fails when a mistaken split char is being snet to the function.This can easly be corrected by adding an if to check the value of the @holdpos inside the loop before sending it to the substring functionif the value is 0 then break the loop

2005-02-23 (first published: )

104 reads

Blogs

Transaction log Information gathering

By

Here are the different ways to know the tlog file related information sys.dm_db_log_stats –...

What's New in SQL 2019? at BRSSUG

By

Thanks to everyone who joined the BRSSUG for a night all about SQL Server...

Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 3

By

This is the third post in a series about modern Data Lake Architecture where...

Read the latest Blogs

Forums

Using crypt_gen_random to generate unique Serial Numbers

By iviewtheworldthroughmylens

Trying to generate unique serial numbers with alphanumerics (A-Z,a-z,0-9) and no special characters.Used below...

OPENQUERY is not inserting identical rows

By Johnny D

Hi, Thanks in advance for any help. I am trying to insert into a...

Azure file copy creating a directory to hold the renamed file

By Irish-Toon

Hi All, I'm pretty new to azure and am hitting the following problem. I've...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers