Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Creative uses for COALESCE() in SQL Server
- Arthur Fuller shows you two unusual uses of the COALESCE function in SQL Server. For instance, you can generalize its use, as well optimize its performance and make its results constantly available. COALESCE accepts a series of values and a value to use in the event that all...
- Tags: Microsoft SQL Server, Listing B, Databases, Arthur Fuller, server, SELECT dbo.WholeName, SQL Server Newsletter, Problem, Column, COALESCE, Enterprise Software, Software, Data Management
- Technical articles 2007-05-14
- Using Oracle's COALESCE function as a quick CASE statement
- In this Oracle tip, Bob Watkins explains how you can use the COALESCE function in lieu of the more wordy CASE statement when testing for null results in multiple expressions. Database applications sometimes store information about multiple, related entities in the same table. For example, purchased parts and...
- Tags: Oracle Corp., Databases, Bob Watkins, Enterprise software, CASE statement, Oracle Tips Newsletter, Expression, CASE, COALESCE, NULL, Material_qty, Storage, Hardware, Software, Data Management
- Technical articles 2006-09-26
- Using Oracle's COALESCE function as a quick CASE statement
- DB2This functionality is not limited to Oracle, exists in DB2 SQL as well.....Quite rightThanks for commenting! You're quite right: it's part of the SQL standard. The title of the article was not meant to imply it was an Oracle-specific feature.BobWLooks like Decode to meThis looks almost exactly like Decode to...
- Tags: algorithm, COALESCE, Decode, Oracle Corp., ProblemSolverSolutionSeeker, software, sql, Value at Risk
- Discussion threads 2006-09-27
- Mini-Tip #5: Coalesce()
- I recently wrote about NVL2. A function much like NVL2 is coalesce. Coalesce is of the format COALESCE(expr1, expr2, exprN...)Coalesce returns the first non-null expression in the expression list.Coalesce is different from most SQL functions in that it allows a varying number of expressions.Coalesce is basically a...
- Tags: COALESCE, NVL2
- Blog posts 2006-08-30
Additional Resources
- Creative uses for coalescence in SQL Server
- ISNULL:?ISNULL(FirstName, '')orISNULL(HourlyPay, 0)...good pointThat's actually a really good point. All of the uses of COALESCE in this article could easily be substituted with ISNULL. The real power of COALESCE is when you a have a list of values and you want the first value that isn't NULL. ...
- Tags: Microsoft SQL Server, server, roko3, IsNull
- Discussion threads 2007-05-15
- Network Virtualization for the Campus
- As the demands placed on campus networks have grown in complexity, so has the need for scalable solutions to separate groups of network users and resources into logical partitions. Virtualization of the network provides multiple solutions for centralizing services and security policies while preserving the high-availability, manageability, security, and scalability...
- Tags: Network, Cisco Systems Inc., Virtualization, Storage Management, Utility Computing, Networking, Hardware, Storage
- White papers 2006-04-01
- APHIDS++: Evolution of a Programmable Hybrid Intrusion Detection System
- With the rapid growth of the Internet and the ever-increasing security problems associated with its popularity, the need for protection against unwanted intruders has become essential. Antivirus software, intrusion detection systems, spyware and malware detectors are some of the protection mechanisms available to users today. The diversity of these manifold...
- Tags: Agent, Intrusion Detection System, University Of British Columbia, Real Estate, Intrusion Detection, Spyware, Adware & Malware, Cyberthreats, Security, Network Security, Viruses And Worms, Business Operations, Networking
- White papers 2005-10-01
- Improving Energy Efficiency by Making DRAM Less Randomly Accessed
- Existing techniques manage power for the main memory by passively monitoring the memory traffic, and based on which, predict when to power down and into which low power state to transition. However, passively monitoring the memory traffic can be far from being effective as idle periods between consecutive memory accesses...
- Tags: Technique, DRAM, Association For Computing Machinery, Memory Traffic, Productivity
- White papers 2005-08-10
- Enterprise Project Management - IT Governance and the Program Management Office
- Organizations are challenged to track and measure the effectiveness of a large number of projects in various aspects of their work, and aligning Information Technology costs with business objectives is becoming increasingly important. Executives--especially those accountable for the success or failure of IT spending–would benefit from better ways to select...
- Tags: IT Governance, Information Technology, Microsoft Office, Software Spectrum, Microsoft Office Enterprise Project Management Solution, Project Management, Strategy, Tools & Techniques, It Operations, It service Management, Management
- White papers
- Differences between Jet's IsNull() and T-SQL's COALESCE() functions
- By Susan Sales Harkins and Doris ManningFailure to contemplate possible null values and handle them properly can lead to runtime errors, or even worse, bad data—and you really don't want your users and clients to experience either at your expense.Null values present a special problem for Access and SQL Server...
- Tags: Scripting languages, Databases, Microsoft SQL Server Transact-SQL, Guest Contributor, Iif, N/A, VBA
- Technical articles 2003-08-07
- Get more data comparison options in MySQL with operators you may not know
- This article is also available as a TechRepublic download.It's likely that if you've performed a SELECT or UPDATE query in therecent past, you've made use of one or more of MySQL'scomparison operators in constraining your query's output. Comparison is anintegral part of most SELECT queries, and MySQL comes withnumerous functions...
- Tags: Software engineering/development, MySQL, Contributor Melonfire
- Technical articles 2007-02-09
- Handling NULL values in SQL Server 2005
- In the simplest terms, a NULL value represents an unknown value. It's unknown in the sense that the value is: missing from the system, may not be applicable in the current situation, or might be added later. NULL values are different than any other value and are sometimes hard to compare...
- Tags: Function, Microsoft SQL Server, Column, Microsoft SQL Server 2005, Value, Tim Chapman
- Blog posts 2007-08-06
- Save time and prevent coding headaches with nullable types in C-sharp 2.0
- Oneheadache for C# developers before C#2.0 was the inability to assign a null value to certain types. Forinstance, if you declared an int, you could never set that variable to a null value. Thesame held true for DateTimeobjects. This limitation forced application developers to come up with their own solutionsand...
- Tags: GetValueOrDefault, HasValue, nullable type, Value at Risk, Zach Smith
- Technical articles 2006-08-03
- Decision Support: The goal of enterprise antispam programs
- By Joyce GraffThe goal of an enterprise antispam program is to sort out the "good guys" from the "bad guys" and empower the end users to control their own desktop environments. The bad guys of e-mail consist of:Pure trash spam (messages from senders that don't exist, confidence games).Chain letters, hoaxes,...
- Tags: anti-spam, bad guy, Brightmail Inc., decision support, Fighting Spam, Gartner , Postini Corp., spam
- Technical articles 2003-01-22
- Learn to use Oracle9i space management tools with tablespaces
- Locally managed tablespaces LMT and automatic segment space management ASSM provide a new way to manage freelists for individual objects in a database. Along with these ASSM features, Oracle9i provides several new DBMS PL/SQL packages for viewing and managing tablespaces with ASSM. These include:dbms_space.space_usagedbms_repair.rebuild_freelistsLet’s explore how some of these packages...
- Tags: Databases, Oracle9i, Donald Burleson, freelist, automatic segment space management, Oracle9
- Technical articles 2003-01-20
- SQL Server 2000 Grouping...?
- Tables Alias---------------------- --------------Employees eeSkills skEmp_skills eseEmployee fields (table for all employees, listing only relevance fields)Emp_id PKLast_nameFirst_nameEmp_deptSkill Fields (table for all skills, listing ony relevant fields)Skill_id PKSkill_descEmp_Skill fields table which assigned employees skills are maintainedSkill_idEmp_idThe employee table is your typical employee table. There are unique emp_id’s for all employees. This report will...
- Tags: #tmpTest VALUES, Cook Supervisor Barker, Mickey DFGHJjklm Prep Cook Frost, Microsoft SQL Server, Microsoft SQL Server 2000, parier, programming, tmpTest VALUES
- Q&A 2006-02-27
- Using pluggable look-and-feel in Java Swing APIs
- The Java Swing API provides a pluggable look-and-feel PLAF capability, which allows Swing GUI widgets to change appearance based on the programmer's customized look-and-feel setting. Almost all modern user interface frameworks coalesce the view and controller, whether they are based on SmallTalk, C++, or Java.Swing packages each component's view and...
- Tags: Programming, Java
- Blog posts 2007-06-27
- Team learning: More than group thinking
- Team learning is the second of Peter Senge’s group-centric disciplines outlined in his book The Fifth Discipline, and it's the final discipline we will cover in this series of articles. From the perspective of the nimble project manager, team learning has absolutely nothing to do with training. Team learning in...
- Tags: Team management, Donna Fitzgerald, Peter Senge, team
- Technical articles 2003-05-05
- Most of the time...
- Most of the time...my idea isn't to "convert" anyone...only to broaden.See, I notice a lot of the time people are overcompensating by exaggerating their view in a humourous way. That's fine and dandy...I get a joke.But other times, I see people on here who seem to have a narrow...
- Tags: posts
- Discussion threads 2005-09-21
- Thanks
- ThanksI stayed up all night writing this and probably missed a few things. But thanks for your comments.Net neutrality and politics don't mixarticle rootexcellentThat's a very clear overview of the situation and some of the problems with the debate in progress.There are of course more details to it, but...
- Tags: Blogging, Net Neutrality
- Discussion threads 2006-06-07
- << Previous
- page 1 of 1
- Next >>
