Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- MBCS Lease Maker (exe)
- The Lease Maker provides an easy to use interface for the day to day printing of leases as well as complete lease document management which includes a dedicated word processor. Leases can be fashioned from simple, stand-alone documents or from cut and paste clauses. In addition, separate rider documents can...
- Tags: Lease, Clause, Word-processor, Word Processors, Software
- Software downloads 2007-11-13
- Compute the percentage of a total with Oracle's RATIO_TO_REPORT
- Many reports include a percentage of the report total on each line, in addition to the detail data being reported. For example, what percentage does each customer contribute to all of the orders placed in a month, or what percentage does each sales rep contribute to the total sales?The traditional...
- Tags: oracle, databases
- Blog posts 2007-07-17
- Three ways to avoid Case Not Found errors in PL/SQL
- Unlike some languages, PL/SQL's CASE statement generates an error if none of the cases are matched. Bob Watkins presents three ways to code around this error. PL/SQL has a rich CASE functionality. The selector CASE statement lets you test the value of an expression (much as the DECODE...
- Tags: Oracle Corp., PL/SQL, Databases, Bob Watkins, Programming languages, PL/SQL CASE, CASE statement, clause, Oracle Tips Newsletter, Solution, Statement, Listing B, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Technical articles 2007-05-01
- Should I stay or should I go?
- I'm an IT dept.Manager with 9 techs and a PhD. I work for a medium sized company and have been there quite a while. I'm on a first name basis with the owner and it's the kind of company where employees and their family problems are important. We're pretty successful...
- Tags: Strategy, Benefits, Jack-M, old company, clause, information technology
- Discussion threads 2007-06-08
- Exploring the window functions in SQL Server 2005
- SQL Server 2005's window functions allow you to look at different levels of aggregation all at one time. Here's how to use the OVER(…) clause to gather a collection of statistics. Window functions in SQL Server 2005 have nothing to do with Microsoft Windows; rather, they create data...
- Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Construction, Databases, Arthur Fuller, SQL Server window, window, clause, Window Function, SQL Server Newsletter, TechRepublic Inc., Enterprise Software, Software, Data Management
- Technical articles 2007-03-19
- Use the GROUP BY clause to write SQL queries that group and aggregate data
- Introduction to SQL, long the definitive SQL tutorial for database professionals, has been updated to reflect the latest SQL standards and newest versions of today's leading RDBMSs: Oracle, Microsoft SQL Server, DB2, and MySQL. Throughout, case study examples and hands-on exercises illuminate key SQL concepts, techniques, and statements....
- Tags: Clause, SQL, Addison-Wesley, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Book chapters 2007-01-03
- Delete rows during updates using Oracle 10g's MERGE statement
- In Oracle 10g Release 1, the MERGE statement gained the ability to delete rows, as well as update and insert them. This Oracle tip shows you how it works. The MERGE statement, introduced in Oracle 9i Release 2, is often called an "upsert" because it can both...
- Tags: Oracle Corp., Oracle Application Server 10g, Storage, Databases, Bob Watkins, Listing B, clause, Oracle Tips Newsletter, Transaction, Statement, MERGE, UPDATE, INSERT, Application Servers, Business Intelligence, Enterprise Software, Software, Data Management, Hardware
- Technical articles 2007-02-20
- Calculate columns and averages with SQL Server's HAVING clause
- Arthur Fuller gives a brief overview of SQL Server's HAVING clause and provides code examples that demonstrate how to use it. For instance, he shows how to use HAVING to test aggregates based on a child table. As an instructor of database language and usage, I find some ...
- Tags: Microsoft SQL Server, Databases, Arthur Fuller, clause, server, SQL Server Newsletter, Enterprise Software, Software, Data Management
- Technical articles 2007-01-22
- How to order SIBLINGS in Oracle hierarchy queries
- Developers can use the ORDER SIBLINGS BY feature of Oracle 10g and later to sort the records in a hierarchy created by the START WITH and CONNECT BY clauses in a SELECT statement. Oracle's START WITH and CONNECT BY clauses in the SELECT statement automatically traverse a hierarchy....
- Tags: Oracle Corp., Bob Watkins, hierarchy, clause, ORDER SIBLINGS, Oracle Tips Newsletter, Syntax, Listing B, Application Servers, Enterprise Software, Software
- Technical articles 2006-12-19
- Process non-consecutive array items in FORALL
- Prior to Oracle 10g, the FORALL statement only accepted a consecutive range of index values for processing. Starting with Oracle 10g, the INDICES OF and VALUES OF clauses can be added to support non-consecutive processing of elements in a collection. Executing Data Manipulation Language DML statements within a...
- Tags: Oracle Corp., FORALL, Databases, Bob Watkins, Programming languages, clause, Oracle Tips Newsletter, TechRepublic Inc., Statement, Oracle Application Server 10g, Application Servers, Enterprise Software, Software, Software Development, Software/Web Development, Data Management
- Technical articles 2006-10-31
- Optimize database code to boost performance
- Tony Patton offers .NET developers a few guidelines for developing efficient database code. For instance, he explains when to use the WHERE clause and reveals what code to avoid. As .NET developers, we often find ourselves waist deep in SQL Server queries and stored procedures. A good example...
- Tags: Microsoft SQL Server Transact-SQL, Microsoft SQL Server, Databases, Tony Patton, Performance management, .NET, clause, Having Clause, database, performance, .NET Newsletter, Microsoft .NET, Query, Problem, Server, Creation, TOP Operator, Storage, Human Resources, Workforce Management, Enterprise Software, Software, Data Management, Hardware
- Technical articles 2006-09-26
- Abstract Pro (zip)
- Abstract Pro is an economical MS Excel based program that keeps all your lease information in one place allowing you to access and monitor your rents, critical dates, and lease clauses. It is ideal for small to medium sized portfolios (from several to more than 100 leases) for tenants, property...
- Tags: Clause, Abstract Pro, Real Estate, Business Operations
- Software downloads 2005-09-14
- 10 tips for sorting, grouping, and summarizing SQL data
- This article is also available as a PDF download.Arranging data in a manner that'smeaningful can be a challenge. Sometimes all you need is a simple sort. Often,you need more--you need groups you can analyze and summarize. Fortunately, SQLoffers a number of clauses and operators for sorting, grouping, andsummarizing. The following...
- Tags: clause, Group-By, SELECT ZIP, SQL, Susan Harkins, ZIP
- Technical articles 2006-11-06
- Optimize database code to boost performance
- As .NET developers, we often find ourselves waist deep inSQL Server queries and stored procedures. A good example is an ASP.NETapplication I recently developed and delivered to the client for testing. Theapplication utilized an existing SQL Server database with most of the T-SQLcontained in pre-existing stored procedures (aka, I didn't...
- Tags: clause, database, Having Clause, Microsoft SQL Server, Microsoft SQL Server Transact-SQL, performance, Tony Patton
- Technical articles 2006-09-26
- Understand the ambiguities of compound JOINs in SQL
- Arthur Fuller explains why he wants developers to think about this general principle: Compound JOINs become nonsensical when one of the clauses references only one of the tables. This article begins with a test. Look at the SQL below and determine, without using your computer, what the ...
- Tags: SQL, Arthur Fuller, dbo.Orders.OrderID, dbo.Orders.CustomerID, Databases, SELECT dbo.Customers.CustomerID, NULL CustomerID, OUTER JOIN dbo.Orders, dbo.Customers, SQL Server Newsletter, TechRepublic Inc., Clause, Row, dbo.Customers.CustomerID, Programming Languages, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Technical articles 2005-07-25
- Filtering (WHERE) and Sorting Data (ORDER BY) in Oracle 9i
- This paper covers filtering of rows using the WHERE clause and sorting of retrieved data using the ORDER BY clause. The WHERE clause applies to both queries and most DML commands; the ORDER BY clause applies to queries only. The WHERE clause extends the syntax of the SELECT statement, allowing...
- Tags: Oracle Corp., Clause, Oracle9i, Databases, Enterprise Software, Software, Data Management
- White papers 2004-11-05
- Learn the ins and outs of filtering data in MySQL with the WHERE clause
- This sample chapter, taken from MySQL Crash Course, teaches you how to use the SELECT statementÂ’sWHERE clause to specify search conditions, such as quality, nonequality, greater than and less than, value ranges, and NULL values.Title: MySQL Crash CourseISBN: 0672327120Published: December 2005Author: Ben FortaChapter: Chapter 6: Filtering DataPublished by Sams
- Tags: MySQL, MySQL Crash Course, clause, Published, Value at Risk
- Download resources 2006-03-14
- cannot work in the same industry for one year after resignation?
- Hello Forum,I finally decided to resign gracefully and professionally from my current employer. But I found a clause in my contract signed three years ago. It said that I cannot work for the same domain for one year after my termination except I am fired. I wasn't told exactly at...
- Tags: clause, industry, jiansec, networking, resign
- Discussion threads 2006-02-06
- resign legal issue
- Hello Forum,I finally decided to resign gracefully and professionally from my current employer. But I found a clause in my contract signed three years ago. It said that I cannot work for the same domain for one year after my termination except I am fired. I wasn't told exactly at...
- Tags: clause, domain, IT DEPENDS
- Discussion threads 2006-02-06
- Understand the ambiguities of compound JOINs in SQL
- good use of on clauseActually, I do use elements of the on clause that only reference one table to good effect. I use it when the table I'm joining with has a lot of records in it that I would like to filter out before joining, (e.g. a description lookup...
- Tags: clause, dbo.Customers.CustomerID, dbo.Orders.CustomerID, dominic@..., join, joins, software, SQL, sql server
- Discussion threads 2005-11-15
Harnessing the power of waves
Planting solar gardens
Fill your car for $1.10 a gallon?