Lab Sql

I have a string: @string='TEST RESULTS\TEST 1\RESULT 1 The string/text remains the same except … Read more How To Extract Numbers From A String Using Tsql

I have the following data (all of the table DDL and data DML is available on the fiddle here (SQL S… Read more Parsing A String In Both Postgresql And Micrsoft Sql Server

I need to create an SQL formatter in C#. Could anyone point me to some resources on the net? Do I n… Read more Sql Formatter Using C#

I would like to be able to parse an arbitrary SQL SELECT statement and retrieve the various compone… Read more Library To Parse Sql Statements

My current method takes ~40 minutes to parse all of this data : Current logic is: foreach (var file… Read more I Need To Parse 250 Files, Totalling At 1gb Of Data And Upload It To A Sql Server. Can I Get More Efficient Than This?

I am working on building a huge meta data dictionary and lookup application for workload automation… Read more Java Api For Parsing/recognition But Not Executing Sql Against A Db

Hello stackoverflowers, I've got a problem parsing T-SQL statements using TSql120Parser from Mi… Read more Error On Parsing T-sql Using Tsql120parser

Is there a simple way to parse QueryString parameters (e.g. foo=bar&temp=baz) in SQL Server? Wh… Read more Parse Querystring In Sql Server 2005