sql%bulk_exceptions

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

Handle bulk binding exceptions in PL/SQL

The downside to bulk binding in PL/SQL is that if any of the data values result in an invalid UPDATE, the entire set of iterations is rolled back. Bob Watkins explains how you can get around this issue. Bulk binding in PL/SQL is an important technique for efficient...

Tags: Oracle Corp., PL/SQL, SQL%BULK_EXCEPTIONS, Listing C, Databases, Bob Watkins, Programming languages, FORALL, SAVE EXCEPTIONS, Oracle Tips Newsletter, Downside, UPDATE, Listing D, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Technical articles 2006-08-21

Additional Resources

How to Upgrade SQL Server 6.5 and 7.0 to SQL Server 2000

This white paper details the steps involved in upgrading from SQL Server 6.5 and SQL Server 7.0 to SQL Server 2000. Microsoft SQL Server 2000 improves on the performance, reliability, scalability, quality, and ease of use of its predecessors, SQL Server 7.0 and SQL Server 6.5. SQL Server 2000 offers...

Tags: Microsoft SQL Server, Microsoft SQL Server 2000, Microsoft SQL Server 6.5, Databases, Enterprise Software, Software, Data Management

White papers 2001-07-19

SQL PathFinder for Oracle (msi)

SQL Pathfinder is for Oracle SQL programmers who live in an environment where multiple versions of SQL scripts and multiple SQL execution environments exist. Pathfinder determines the SQL path that SQL Plus will use, and traces and displays all of the script dependencies for your SQL script. The dependencies are...

Tags: Oracle Corp., SQL, SQL PathFinder, Pathfinder, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2006-11-21

Cache Monitor (zip)

Cache Monitor is the SQL development tool designed for InterSystems database Cache. It supports developers with features, like advanced SQL Query Editor with foreign key join suggestion, Cache-SQL Syntax highlighting, SQL Code completion, SQL History buffer for executed SQL commands, SQL Code formatting, Graphical SQL execution plan. Version 0.34 is...

Tags: Monitor, SQL, Cache Monitor, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2007-05-11

What is the difference between Oracle, SQL and PL/SQL?

Recently, Sudhat read my Introductionto Basic SQL and had this to say:The article is very interesting. Too Good!And also please describe what is the difference between SQL and Oracle and PL/SQL.Sudhat, thanks for the comments. Ilove to hear feedback.And your question is a common one so Ithought I would...

Tags: Oracle Corp., PL/SQL, SQL

Blog posts 2006-05-30

Some resources on SQL Server 2005

Here are some helpful resources on SQL Server 2005 for those who are evaluating it and/or preparing for it: Microsoft's SQL Server TechCenter MSDN's SQL Server Development Center  SQL Server 2005 downloads SQL Server 2005 Express Edition the free version of SQL Server Free Virtual...

Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management, Jason Hiner

Blog posts 2005-11-11

Transferring SQL Server logins between servers or instances

I recently discussed how to restore a SQL Server to a new server. After the article published, I had some questions on the best way to move SQL Server logins from one SQL Server 2005 instance to another SQL Server 2005 instance. [poll=11] I...

Tags: Microsoft SQL Server, Server, Databases, Enterprise Software, Software, Data Management, Steven Warren

Blog posts 2007-09-25

EMS SQL Manager 2008 for SQL Server (zip)

EMS SQL Manager for SQL Server is a powerful graphical tool for SQL Server administration and development. SQL Manager 2005 works with any SQL Server versions from 7 to 2005 and supports all of the latest SQL Server features including new SQL Server 2005 permission system, assemblies, DDL triggers, XML...

Tags: Microsoft SQL Server, Server, SQL, SQL Manager 2005, Databases, Enterprise Software, Programming Languages, Software, Data Management, Software Development, Software/Web Development

Software downloads 2007-12-20

EMS SQL Manager 2008 Lite for SQL Server (zip)

EMS SQL Manager Lite for SQL Server is a light and easy-to-use freeware graphical tool for MS SQL/MSDE administration. It has minimal required set of instruments for those users who are new to MS SQL server and need only it's basic functionality. EMS SQL Manager Lite for SQL Server is...

Tags: Microsoft SQL Server, Server, SQL, Databases, Programming Languages, Enterprise Software, Software, Data Management, Software Development, Software/Web Development

Software downloads 2007-12-20

BlackBall SQL Agent (exe)

The BlackBall SQL Agent fills the gap that Microsoft Express Edition 2005 left with its ommission of a SQL Server Agent. Use the BlackBall SQL Agent to automatically backup your SQL Server database at periodic intervals, or run other arbitrary SQL commands such as executing stored procedures.Also includes email notifications...

Tags: Microsoft SQL Server, SQL, BlackBall SQL Agent, E-mail, Databases, Enterprise Software, Programming Languages, Online Communications, Software, Data Management, Software Development, Software/Web Development

Software downloads 2007-06-29

Towards an Industrial Strength SQL/XML Infrastructure

XML has become an attractive data processing model for applications. SQL/XML is a SQL standard that integrates XML with SQL. It introduces the XML datatype as a native SQL datatype and defines XML generation functions in the SQL/XML 2003 standard. The goal for the next version of SQL/XML is integrating...

Tags: SQL, XML, Programming Languages, Databases, Software/Web Development, Web Development, Software Development, Enterprise Software, Software, Data Management

White papers 2004-07-21

Fast Track DBA

I am looking for a "Boot Camp" for SQL DBA. I have some knowledge of it but I am trying to gain more experience and it helps that my company is going to pay for it. I am looking for something that is a 2 day Session ...any IdeasSQL ServerI...

Tags: Programming languages, Databases, jabney@..., SQL, server

Discussion threads 2005-06-14

SQL Tools Make Fast Work

The purpose of any interactive SQL tool is to let the user enter SQL statements and get results back. The term SQL statements includes PL/SQL blocks and now, in Oracle Database 10g Release 2, XML queries. SQL*Plus has long been the tool of choice for executing ad hoc SQL statements,...

Tags: Oracle Corp., SQL, Tool, SQL*Plus, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

White papers 2006-01-01

How do I... Configure transactional replication between two SQL Server 2005 systems?

Replication between sql 2000 and sql 2005This article was good for basic knowledge. Is it possible to use sql 2005 as a distributor and sql 2000 as a publisher. Subscriber could be any.ORsql 2000 as publisher and distributor but subscribers as sql 2005.Please point me if there is any reference...

Tags: Programming languages, Databases, Microsoft SQL Server 2005, alalani@..., Microsoft SQL Server, SQL

Discussion threads 2007-09-12

Apex SQL Report (exe)

Apex SQL Tools has released new version of Apex SQL Report. Apex SQL Report is a Web solution crafted for SQL developers. Apex SQL Report is a SQL tool that generates HTML and graphical reports. New Apex SQL Report includes fusion charts, multi column sorting, grouping & filtering using Janus...

Tags: SQL, Apex SQL Tools, Apex SQL Report, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2007-01-30

Teratrax Performance Monitor (msi)

Monitor SQL Server performance on all enterprise servers from a single interface. Analyze and chart real-time and historical execution of SQL code across users and applications. Isolate SQL Server hardware utilization and correlate it with SQL statements and SPs. Be the first to know about slow and failed SQL Server...

Tags: Microsoft SQL Server, SQL, Databases, Enterprise Software, Software, Data Management

Software downloads 2006-06-16

General SQL Parser .NET version (zip)

General SQL Parser is developed to help people who want to check syntax of SQL statements, pretty print out SQL statements, and parse SQL statements into parse tree in their program. It can also provides more detail information about a SQL statement such as statement types (Select, insert, update, delete...

Tags: Microsoft .NET, Statement, SQL, General SQL Parser, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2006-12-07

SQL Server Survival Guide for Network Administrators

Microsoft's SQL Server can be a scary place, especially if you don't have much database experience. So we put together this resource to help guide you through some of the basic SQL functions. We divided it into two sections: SQL Server Basics covers common tasks you may be called upon...

Tags: Microsoft SQL Server Transact-SQL, TechRepublic Inc., Microsoft SQL Server, Server, Databases, Enterprise Software, Software, Data Management

Download resources 2005-01-05

Brand New to SQL

I am looking for the best books or resources for a beginner in SQL. Any tips?DaveAnything by...Susan Sales Harkinsor evensams publishing.they have several good books on several sql servers in the teach yourself in 24 hours / days series.Also"SQL in a Nutshell", an O'Reilly Press book is an excellent...

Tags: ddevans888@..., server, software, SQL

Discussion threads 2005-04-07

SQLWriter (rar)

SQLWriter is a powerful SQL script editor for Windows System. It can: Be used for multiple database such as SQL server, Oracle, DB2, Access, My SQL. Identify the key words of SQL script. Show the objects of the database for you. Execute multiple SQL scripts at the same time and...

Tags: SQL, SQLWriter, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2007-12-13