SQLStackEngine - simulate a character stack

SQLStackEngine - simulate a character stack using a string.  This script was developed specifically to support the operator stack in SQLCalcEngine(also on this site).  However, the implementation is complete enough to stand on its own.There are several functions in the package that correspond to the common stack functions of Push, Pop, Peek, and so on.In […]

2006-12-12 (first published: )

128 reads

SQLCalcEngine - evaluate numeric expression

SQLCalcEngine - evaluate numeric expression similar to the VB eval function.The basic concept is to pass a string containing a numeric expression such as ((2+3)*(4/9)) and receive a numeric value back. The algorithm is based loosely on material found at http://www.arstdesign.com/articles/expression_evaluation.html, as well as material found in the book "Writing Compilers and Interpreters" by Ronald […]

2005-03-31 (first published: )

304 reads

XML Encode UDF

I routinely need to retrieve and package query result sets in an XML package.  The built in functions supported by SQL Server 2000 are effective, but are often more of a pain than a help.  This routine can be used in a simple select statement to XML encode the contents of a column during the […]

2003-10-14

210 reads

Blogs

Weekly reading #26

By

Good morning! It was a tough weekend as we supposed to be in Goteborg...

Delete an Azure DevOps Project

By

Not something you’ll do too often, but you might find yourself doing this if...

Ways to access data in ADLS Gen2

By

With data lakes becoming popular, and Azure Data Lake Store (ADLS) Gen2 being used...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

“Included columns” for non-clustered indexes explained

By Michael Salzmann

Comments posted to this topic are about the item “Included columns” for non-clustered indexes...

Reindexing a database

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Reindexing a database

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers