| |
|
|
|
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. |
| « read more about SQLRegEx: SQL Server Regular Expressions 1.0 |
|
|
RECOMMENDED DOWNLOADS IN THIS CATEGORY
|
|
|
|
| » SQLitePlus 3.0.8
|
| SQLitePlus is a powerful database manager/viewer program and a COM wrapper DLL for the well-known SQLite C database engine (www.sqlite.org). The SQLitePlus Admin tool allows you to open and view multiple databases simultaneously, examine table, view, tr ... |
|
| EzTools Software | 1552KB | Win 95/98/ME/NT/2000/XP | $150 | Downloads: 32 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » SP Manager 2004 Professional 2.0
|
| Are you tired of using Enterprise Manager to connect to remote SQL Server databases, and finding it is unbearably slow? Look no further!! SP Manager 2004 is the ideal product to create and manage your stored procedures, views, table triggers and also tab ... |
|
| Dotco Software Ltd. | 16825KB | Win NT/2000/XP | | Downloads: 17 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » United States ZIP Code Database - Lite Edition 2.00
|
| United States 5-Digit ZIP Code Database, Lite Edition. Basic United States city, state ZIP code data containing every valid United States ZIP code. Data is delivered in ASCII text CSV flat file format. Easily imports into Microsoft Excel, Access, SQL or a ... |
|
| Data Network Source | 271KB | Not Applicable | $19.95 | Downloads: 16 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » SQLExpress Pro (yearly support)
|
| This is a yearly support fee for SQLExpress Pro. It entitles you to receive continued technical support and software updates for one year. You must currently be be a registered SQLExpress Pro user with a valid registration password in order to qualify ... |
|
| SQLExpress.net | 0 | Win 95/NT/2000/XP/98/ME | $149 | Downloads: 25 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » TracePlus Win32 4.01.000
|
| TracePlus/Win32 shows you the interaction between your Win32 application and multiple Win32 APIs. Supported APIs that are displayed in realtime include ODBC, OLE, COM, TAPI, WININET, registry, DB-Library, and more. Integrated SQL capture window displa ... |
|
| SST Incorporated | 2616KB | Win 95/98/ME/NT/2000/XP | $199.95 | Downloads: 22 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Advanced SQL Code Collection 1.2.0
|
| Advanced SQL Code Collection (ASCC) is a powerful but easy to use tool for application programmers, database designers and database administrators who need to keep track of and reuse SQL source code fragments. With its intuitive user interface, ASCC del ... |
|
| MediaTwins s.r.o. | 637KB | Windows 95/98/NT/2000 | $57 | Downloads: 25 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » MSSQL-to-Access 1.6
|
| 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 engin ... |
|
| Intelligent Converters | 2268KB | Win 95/98/ME/NT/2000 | $39.85 | Downloads: 26 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » IC Studio V1.1.0
|
| IC Studio® is a comprehensive tool designed to help Oracle database application developers and DBAs to be more productive when working with database as they design, develop, test and support any client/server or web based applications. This easy to use Wi ... |
|
| IC Soft, Inc. | 7500KB | Win 95/98/ME/NT/2000/XP | $124.95 | Downloads: 23 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » IBAdmin 4.0
|
| This is most functional tool available to manage Interbase/Firebird servers and databases. IBAdmin provides many capabilities to help in your DB design and management. You can use `Database Designer` to visually design database structure or `Grant Manag ... |
|
| SQLLY Development | 3450KB | Win 95/98/ME/NT/2000/XP | $229 | Downloads: 38 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Stamp Organizer 3.6
|
| Stamp Organizer is a complete program that allows Stamp collectors, philatelists, hobbyists, dealers, and clubs to organize, catalog, and manage their collections on their PCs. Organizer is intuitive and easy to use for the beginner, at the same moment fe ... |
|
| Primasoft.com | 0 | Win 95/NT/2000/98/ME | $43 | Downloads: 21 |
| Date added: Sep 22, 2005 |
» Details |
|
|
|
|
| » RainDat PalmOS 2.0a
|
| For lawn sprinkler irrigation professionals. Right in your pocket, have access to all the performance data on popular Rain Bird® sprinkler nozzles: radius at various pressures, flow rate, etc. All spray, impact, rotor nozzles and Xerigation data Featur ... |
|
| Arkansoft | 108KB | Palm OS | $14.95 | Downloads: 23 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » dbfUtils Pro 2.1.2
|
| The ultimate Database Editor/Utility. dbfUtils is a convenient, full-featured utility for viewing, editing, modifying, converting and exporting DBF-format databases dbfUtils is a windows program that allows you to add, delete, recall, sort, zap, pack rec ... |
|
| GW Associates | 3069KB | Win 98/ME/NT/2000/XP | $59.95 | Downloads: 31 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » 4TOPS Data Analysis for MS Access 2000 3.0
|
| 4TOPS Data Analysis is a collection of addins for retrieving information in Microsoft Access. Use it for statistical analysis and presentation of the data in your Access database application. The addins in Data Analysis have a wizard user interface. The ... |
|
| 4TOPS | 1526KB | Windows 95/98/NT/2000 | $299 | Downloads: 34 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Trial Engine for FileMaker Developers 1.0.1
|
| The Trial Registration Manager provides an easy to setup authoring mechanism to quickly deliver a trial, as well as a full-licensed product Trial Registration manager. It is particularly designed to run under the FileMaker Pro 7 runtime. Here are some of ... |
|
| PuritySoft | 400KB | Win 98/NT/2000/XP | $49.99 | Downloads: 16 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » QueryODBC 3.3.9
|
| This intuitive program allows you to work with any ODBC compliant or OLE DB compatible database, as well as Microsoft services such as Microsoft Indexing Service and Microsoft Active Directory Service. With QueryODBC you can explore your database schema, ... |
|
| AgilePC Solutions | 3406KB | Win 95/98/ME/2000/XP | $30 | Downloads: 25 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » MsgConnect 1.55
|
| MsgConnect is indispensable if your application consists of more than one module. If you need to exchange information between modules, no matter within one system or across network, MsgConnect will solve this problem for you. You can use simple paradigm o ... |
|
| EldoS Corporation | 6420KB | Win 95/98/ME/NT/2000/XP/CE | $139 | Downloads: 24 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Database Commander 1.2
|
| The Database Commander is a unique tool for manipulation of data, contained within various types of databases. The Database Commander directly supports all major databases such as: ORACLE, Microsoft SQL Server, Sybase, Informix, DB2, Interbase, Paradox, M ... |
|
| Branislav Cobanov | 6801 KB | Windows 95/98/2000 | 89.95$ | Downloads: 28 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » SocksvrQ ActiveX Network Server SDK 3.0.0.6
|
| SocksvrQ is a high performance ActiveX/COM DLL designed exclusively for the purpose of creating high performance network server and client applications on Windows NT and 2000. As part of this design goal, SocksvrQ was built to scale multiple processors, a ... |
|
| DataWizard Technologies | 4590KB | Win NT/2000/XP | $595.00 | Downloads: 25 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Dts Documenter 1.0
|
| Dts Documenter is a powerful DTS documentation tool. It will create documentation in html and text formats. ... |
|
| Soft-R-Us Inc. | 1210KB | Win 95/98/NT/2000/XP | $15 | Downloads: 27 |
| Date added: Sep 22, 2005 |
» Details |
|
|
| » Force-Field 4.2.0
|
| The component accomplishes main tasks in building a security scheme for your application. It performs authentification and authorization of users: controls access of certain users to some system objects. The core advantages · Reducing of development cost ... |
|
| BYTE-force | 356KB | Win 98/ME/NT/2000/XP | $199 | Downloads: 45 |
| Date added: Sep 22, 2005 |
» Details |
|
|
|
|
| |
|