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

I'm using JsqlParser 0.8.0. I have the following string: String sql = 'SELECT table alias F… Read more How To Get Select Clause's Body With Jsqlparser

I have a stored procedure in an old SQL 2000 database that takes a comment column that is formatted… Read more How Do I Tryparse In Sql 2000?

I am in need of a java API to parse a SQL statement. For example, I have a SQL query SELECT PRO… Read more Need Java Api To Parse Sql Statements

I have a sql file which has a lot of insert statements (over 3000+). E.g. insert into `pubs_for_cli… Read more Parse Sql File To Separate Columns

I've inherited a large application that has many hundreds of stored procedures, many of which u… Read more Parsing Out Complete Dynamic Sql Expressions From Hundreds Of Stored Procedures

I'm reading from a dataset that I unfortunately don't have the access to modify. It has con… Read more Querying Substrings Against A List Of Values

I'm currently working on a project which is responsible to generate database model based on its… Read more Parsing Sql Server Database's Script

So, my first post is less a question and more a statement! Sorry. I needed to convert delimited str… Read more Tsql/sql Server - Table Function To Parse/split Delimited String To Multiple/separate Columns

I have a .sql file which may contain DDL definitions of several stored procedures, alter statements… Read more Regex To Parse Stored Procedure And Object Names From Ddl In A .sql File C#

I've inherited a database of user profile information which has a column for personal interests… Read more Parsing A Sql Field In A Query

I am using the Parser that is part of Microsoft.SqlServer.Management.SqlParser.Parser namespace in … Read more The Type Or Namespace Name 'management' Does Not Exist In The Namespace 'microsoft.sqlserver' - Sqlparser And Vsts Automated Builds

I have an XML file that looks like this: Solution 1: The following query will retrieve various dat… Read more Parse Xml File Using Sql Into Specific Columns