SQLRegEx: SQL Server Regular Expressions Free Download

Version: 1.0   (version history)
Date: December 27, 2004

Free To Try

OS: Win 98/NT/2000/XP
Rating: Not rated
Popularity: Popularity 0/10
Author: Krell Software, Inc.

Download Sites:

SQLRegEx: SQL Server Regular Expressions Description

SQLRegEx: SQL Server Regular Expressions Free Download.

SQLRegEx adds regular expression capabilities to Microsoft SQL Server 2000. Regular expressions are extremely powerful compact expressions which can be used for complex matches, searches and replaces on character data using a technique called pattern-matching.

You can see a very simplistic example of pattern-matching in SQL Server's LIKE operator, or the PATINDEX function. These features allow you to perform matches of character data using % and _ as wildcard tokens. Regular expressions are many, many times more powerful than what you get out of the box with SQL Server.

With regular expressions, a person skilled in Transact-SQL can perform a vast number of data manipulation tasks which previously would have required complicated code using T-SQL string functions, or a formal programming language such as C/C++, Visual Basic, or Delphi, or with script languages such as VBScript or JavaScript.

* Accomplish tasks with SQL Server scripts which normally would require a formal programming language such as C/C++, Visual Basic, or Delphi.

* Streamline tasks and jobs by doing more in SQL scripts.

* Avoid the need for data processing through additional scripting languages such as VBScript or JavaScript.

* Improve task automation with more scripts, less programming code.

* Integrate advanced data handling directly in queries, stored procedures, and triggers.

* Avoid complex, buggy, and difficult-to-test manipulations with SQL Server's simplistic built-in string functions.

* Facilitate data imports, data conversion, and data migration without programming code.

* Delegate more tasks to team members with SQL skills.

SQLRegEx: SQL Server Regular Expressions keywords: sql server, regular expression, mssql, database

More Downloads

  • Regular Expression Laboratory

    Regular Expression Laboratory is a simple to use tool to help you learn and prepare regular expressions. If you are a developer or just do some text processing, Regular Expression Laboratory is what you need. Updates: silveragesoftware.com.

  • Data Extractor

    Do you have a group of files that contains important data that you can't get to? Using Data Extractor you can simply extract any information from any files on your computer or from webpages. Simply extract email addresses or URLs, or your own data.

  • Samaritan

    Samaritan is a full featured and easy to use semi-wisiwig Windows help file editor, that allows you to compose WinHelp help files in an intuitive manner. It features its own HTML-like meta-language as an abstraction of WInHelp 4.0 specifications.

  • RegexBuddy

    Perfect companion for working with regular expressions. Easily create and clearly understand regex patterns. Test any regex on sample strings and files. Use the regex with automatic source code snippets. Collect regex libraries for future use.

  • Visual Importer ETL Enterprise 32 Bit

    Visual Importer Enterprise automates loading data into ANY Database from ANY Database or file. Plus automation of business processes such as FTP, Email: POP3 and SMTP, File operations, SQL scripts, Zip and Unzip. Works directly with most Databases