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 RELATED DOWNLOADS
DBConvert for Access & MSSQL 2.0.0
DBConvert for Access & MSSQL is a database migration tool for data conversion from MS Access database (MDB file) to MS SQL Server and from MSSQL to Microsoft Access.You can convert databases simply by configuring several options through Wizard interface ...
Migrate MSSQL To MySQL 2.0.1.5
MSSQL to MySQL database converter software powerfully and automatically converts entire database records or individual tables from MSSQL server to MySQL server. MSSQL to MySQL database converter tool can convert whole database or selected table records ...
Access-to-MSSQL 2.3
Access-to-MSSQL is a program to move MS Access databases to MSSQL server. Key features: (1) all MS Access data types and attributes are supported (2) converts indexes with all necessary attributes (3) command line support(4) converts password protected ...
DB Elephant MSSQL to MySQL Converter 1.1
Most accurate MSSQL to MySQL Converter to convert whole database or its part. MSSQL to MySQL Converter is a most accurate MSSQL to MySQL Converter to convert the whole MySQL database or any of its parts. It supports different data types and attributes. MSSQL to MySQL Converter is good at converting foreign keys as well as individual ...
DBEXform 1.1
Easy database form designer for mssql server or access files. Could acceess multible tables using single form. Simple usable form could build even in minutes. Does not require any knowledge of SQL. Dbex Database Explorer builds relations between tables ...
MySQL To MS SQL Conversion Program 2.0.1.5
MySQL to MS SQL conversion program provides beneficial application to convert large database record or selected tables from MySQL db to MSSQL server. Database transformation software is helpful to convert source database records including tables, rows ...
MSSQL-to-Access 2.3
MSSQL-to-Access is a program to convert MS SQL databases into MS Access format. Key features: (1) all MS SQL data types and attributes are supported (2) converts indexes with all necessary attributes (3) command line support(4) fast conversion engine ...
MSSQL-to-Excel 1.5
MSSQL-to-Excel is a program to convert MS SQL databases into MS Excel spreadsheet. Key features:(1) all MS SQL data types are supported(2) fast conversion engine (20MB MS SQL database - in 1 minute on average P-III system)(3) converts individual tables(4) ...
MS SQL Server Append Two Tables Software 7.0
Vertically merge (combine, match, insert) one MS SQL Server table into another. The tables can be located in the same MSSQL database or two different databases. No complicated options. No SQL knowledge required. ...
SiteMech Database Manager 1.1.2
SiteMech Database Manager is a part of SiteMech Web Development Framework. This is a small and useful tool for backup and exchange data between Microsoft SQL Server and MySQL databases. It allows to export entire database or particular tables to XML file ...
