X
Software Functionality Revealed in Detail
We’ve opened the hood on every major category of enterprise software. Learn about thousands of features and functions, and how enterprise software really works.
Get free sample report

Compare Software Solutions
Visit the TEC store to compare leading software solutions by funtionality, so that you can make accurate and informed software purchasing decisions.
Compare Now
 

 sql if statements


What’s New in Microsoft SQL Server 2000
SQL Server 2000, the next major release of SQL Server 7, is Microsoft’s SQL 7 release of its database both re-architected and re-written. Microsoft has high

sql if statements  have multiple installations of SQL Server on the same machine. This was previously impossible due to the way NT registry entries were made. This inability in prior versions was a serious problem, since many customers wanted to be able to run a test and a production instance on the same (typically very expensive) machine. Database Maintenance Database Programmability Enhancements: Cascading Referential Integrity: In previous releases of major databases, if an attempt was made to delete or update a key

Read More


Software Functionality Revealed in Detail

We’ve opened the hood on every major category of enterprise software. Learn about thousands of features and functions, and how enterprise software really works.

Get free sample report
Compare Software Solutions

Visit the TEC store to compare leading software by functionality, so that you can make accurate and informed software purchasing decisions.

Compare Now

Documents related to » sql if statements

Can Technology Make CFO's and Controller's Jobs More Strategic? (Part 2)


Part 1 of this blog series established that by offloading non-essential and non-value-adding routine tasks to third-party business process outsourcing (BPO) specialists, many human resource (HR) and payroll managers are now able to focus more on strategic and more important tasks of managing talent and human capital of the company. The discussion then went into the possible liberation of chief

sql if statements   Read More

FRx Poised to Permeate Many More General Ledgers Part Two: Market Impact


Since FRx already has integrations built to over forty leading general ledgers (and now a scalable tool kit available to accommodate virtually all others), the idea was for users to leverage the investment they have already made in their GL and to add increased functionality as their needs become more sophisticated.

sql if statements   Read More

Is There Much More (Pro)Clarity In Microsoft’s BI Strategy Now? - Part 2


Part 1 of this blog series presented Microsoft’s official position on its recent notable change in business intelligence (BI) product strategy, whereby the company is breaking apart the business performance management (BPM) family of products. To that end, Microsoft will include the monitoring and analytic functionality within Microsoft Office SharePoint Server (MOSS) 2007, while seriously

sql if statements   Read More

One Year Later at Deltek: More of the Same (And Then Some More) - Part I


Time and again during my decade or so of covering the enterprise applications market as an industry analyst I have witnessed what difference a year can make. And boy, would 2008 be such a year! A year ago or so, I concluded an in-depth four-part series on Deltek (NASDAQ: PROJ), whose executives were recently happy to tell me that 2008 was not that terrible a year for the company. Quite the

sql if statements   Read More

What Good Is Information If Nobody Sees It?


Keeping detailed historical information is a great idea in theory, but how can it be merged with current data to enable split-second decisions? Two companies partner to solve a significant problem in e-commerce.

sql if statements   Read More

Infor ION-izes its Open SOA Strategy - Part 1


2010 has certainly been an interesting (if not a crossroads) year for Infor. Namely, after a number of new high-profile hires at the beginning of the year, which signalled Infor’s intention to be taken seriously, the vendor then entered an eerily quieter period of several months. Except for the ongoing vocal marketing campaign entitled “Down with Big ERP” with witty

sql if statements   Read More

User Recommendations for the Food and Beverage Industry


Software systems must be able to handle your business basics. A focus on the details is essential. Look meticulously for the fatal flaws. If you don't select a system that meets your detailed needs, it can be fatal.

sql if statements   Read More

If There's One Thing CRM Tells Us: Don't Do PLM the Same Way


Product lifecycle management (PLM) doesn't work, but it should. Industry's general approach and attitude to PLM mimics the early days of customer relationship management (CRM) adoption, and lessons from that experience should help when tackling the "ifs" and "hows" of PLM investment.

sql if statements   Read More

How to Protect Your SQL Server Database


SQL Server deployments can be large and complex. However, Auto-Snapshot Manager simplifies data management tasks and offers a comprehensive approach to SQL Server protection by providing both local and remote database protection, allowing for quick data recovery in case of data loss or site failure. Find out more about how Auto-Snapshot Manager can provide you with the safety net you need for effective disaster recovery.

sql if statements   Read More

Your Next IT Software Selection: Risk, Bottomless Money Pit or Opportunity


Every corporation needs to make decisions about the selection and implementation if new IT solutions on a regular basis. However, an industrial manufacturer or retailer cannot see this as being one of their core competencies. In most cases such a selection process is seen as a necessary evil rather than a challenge that uncovers new potentials within the company. Only the ones that are able to fully understand and control this process in conjunction with all internally and externally involved parties will be more successful then others. The implementation of new IT solutions can be a chance to increase efficiency, but only if the right goals are defined, the right solutions and partners selected, and results are being monitored on a continual basis. This white paper was designed to deliver you many hints on what to consider and help you reach your goals in your IT selection process faster.

sql if statements   Read More