Sponsored White Papers, Webcasts, and Downloads
Additional Resources
- table join
- Hey guys what is the best way to join a table like this let say I've got a table Towns with a pkID and TownName field. And I've got a table named Destination with a pkID, DepartureID, DestinationID. Now destination and departure obviosly refer to the towns pkID field.So how...
- Tags: pkID, SELECT
- Discussion threads 2005-05-17
- Sql Select from Databases on Multiple MSSql Servers
- Is there a way to include the server name in an sql select statement. (E.g select ([select columns] from server1.db1.dbo.table1 , server2.db2.dbo.table2 where [where statements])if not is there any other way to achieve thisLook up sp_addlinkedserverBeen a long time but yiou can then useselect * from Link.dbo.TableWhere link = server.database.Usually...
- Tags: Programming languages, Databases, awcrichton@..., SQL, database
- Discussion threads 2007-05-16
- 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
- Look up values in SQL Server using range joins
- Be careful when dealing with floating numberNice, but rather than altering MinWeight to 1.01 we should alter the join condition with x < 1 and x = dbo.ShippingRates.MinWeight AND dbo.Shipments.Weight < dbo.ShippingRates.MaxWeight)
- Tags: Look-up, MinWeight, sql, join, sanjaya.tio@..., software, Microsoft SQL Server, server
- Discussion threads 2006-05-16
- Success Story: Milwaukee Journal Sentinel
- Journal Communications Inc., the holding company of Journal Sentinel Inc., which publishes the Milwaukee Journal Sentinel, is one of America's leading independent media and communications companies. They needed an automated change and configuration solution to test and validate their IT general controls and report on changes. To provide the required...
- Tags: Ecora Software Corp., Information Technology, Sarbanes-Oxley, Strategy, Regulations, Government, Financial Accounting, Finance, Management
- Case studies
- 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
- MDSA Sentinel 2006 (zip)
- MDSA Sentinel logs keystrokes typed, windows opened, and Web sites visited. Also it captures desktop screenshots at a set interval. Blocks Web sites and chat room access. Logs can be sent to you by e-mail or FTP. MDSA Sentinel runs in total stealth. Program and uninstall access are password protected.
- Tags: Web, Web Site, Web Site Development, Web Technology, Channel Management, Desktops, Internet, Marketing, Hardware
- Software downloads 2005-11-10
- Help with SQL Query (Date ranges)
- I've been struggling with a SQL query and can't find a answer anywhere, although I've come kinda close. I need to pull a range of users by hire date BUT just the month and day. For example I want to pull all users who had a hire date...
- Tags: ADynes@..., DatePart
- Discussion threads 2007-07-11
- Date Format and correlated subquery
- I need to take a month and day field in a table, and update a new date field, based upon the month and year. I tried this query, which says it updates the records, but none of the date fields are updated. Can someone tell me what is...
- Tags: dateTime, FETCH NEXT, programming, Randy.L.Kemp@...
- Discussion threads 2004-11-05
- Zenith (zip)
- Based on The Sentinel, Zenith is a first-person action/puzzle/strategy game. The objective is to depose the Sentinel at the Zenith. You do this using the landscape's resources to gain energy and height, avoiding the deadly stare of the Sentinel and its assisting Sentries. Levels are randomly generated, making this game...
- Tags: Zenith, Games, Web Site Development, Personal Technology, Internet
- Software downloads 2007-05-25
- Sentinel (exe)
- Advanced file integrity checker that integrates seamlessly with your anti-virus/trojan applications. Sentinel audits your system folder (as well as upto 20 other folders) for the slightest file changes and/or additions. If any files fail the integrity check, your anti-virus/trojan program will be notified. Sentinel, has been critically acclaimed worldwide for...
- Tags: RuntimeWare, Sentinel, Sarbanes-Oxley, Regulatory Compliance, PCI, Asset Management, Regulations, Government, Financial Accounting, Finance, Human Resources, Policies And Procedures, Storage, Hardware, Operational Planning, Business Operations
- Software downloads 2008-06-18
- Alter every table in a SQL database
- Adding two columns to every table in a database that contains hundreds of tables is impractical to do by hand. Arthur Fuller describes how simple it is to create a query that performs this task. All developers make mistakes from time to time; sometimes this happens...
- Tags: SQL, Databases, Arthur Fuller, database, ALTER TABLE NorthwindTest.dbo, ADD LastUpdated TimeStamp NULL, LastUpdated TimeStamp, SQL Server Newsletter, TechRepublic Inc., Table, Storage, Hardware, Enterprise Software, Software, Data Management
- Technical articles 2005-07-22
- Finding the highest value in several SQL Server columns
- If your task is to return the maximum value contained on a row from n columns, you may want to program defensively, anticipating that some new columns might be added. See why Arthur Fuller says this approach can leave you with useful functions. You have a SQL Server table...
- Tags: Microsoft SQL Server, Databases, Arthur Fuller, server, supposition, SQL, SELECT dbo.Max2, MinMaxID, SQL Server Newsletter, Column, NULL, dbo.Max2, Enterprise Software, Software, Data Management
- Technical articles 2007-02-26
- Security Software Partner Boosts Data Management and Performance Capabilities
- More than 150 of the world's largest corporations, government organizations, and managed security service providers rely on e-Security's award-winning software. Sentinel 5 provides security and compliance teams with an enterprisewide view of their security and compliance posture and includes incident response management to automate and formalize the process of tracking...
- Tags: Performance, e-Security Inc., Microsoft Corp., Data Management, Security
- Case studies
- Hard Disk Sentinel (zip)
- Hard Disk Sentinel monitors hard disk status, health and performance including temperature and S.M.A.R.T. (Self-Monitoring, Analysis and Reporting Technology, built in most hard disks today) values for each hard disks. Also it measures the hard disk transfer speed in real time which can be used as a benchmark or to...
- Tags: Hard Drive, Backup, Professional Version
- Software downloads 2007-02-07
- Oversight System Sentinel (zip)
- A proactive real-time protection against spyware, adware, keyloggers, hidden dialers, malware, trojans, browser hijackers, and other malicious programs. System Sentinel defends your PC via a safety network of all System Sentinel's and updates spyware definitions daily with no annual fees. When new spyware is detected on one computer it automatically...
- Tags: Registry, Spyware, Spyware, Adware & Malware, Cyberthreats, Viruses And Worms, Security
- Software downloads 2007-07-18
- summarize by date in a sql statement
- I am trying to write a report in Excel, I am using 3 tables from a sql server database, one table has tech labor by invoice which I want to sum by date, the 2nd table is Tech name and id #,the 3rd table is time clock entry by date....
- Tags: Char, INSTHIST.DATESTAMP, INSTHIST.DATESTAMP,121, INSTHIST.LABOR_TIME, MECHANIC.MECHANIC_NAME, programming, sparkee16@..., SQL
- Q&A 2005-12-23
- MoneySentinel (zip)
- Money Sentinel is an application that monitors a basket of investments you select. The user enters each investment symbol and the purchase price, and the levels at which he or she wants to be alerted if the investment rises or falls. Alerts are sent to you in up to three...
- Tags: Pager, Money Sentinel, User
- Software downloads 2006-03-16
- Security and Compliance Monitoring: An Automated Solution
- This paper describes the product architecture of Sentinel 5, the Novell market-leading security information-management and continuous compliance-monitoring solution. The contents of this paper are the culmination of more than six years of research and development in the area of high-performance event capture and analysis. During this period of time, Novell...
- Tags: Security, Novell Inc., Compliance, Sentinel 5, Leadership, Management
- White papers 2006-08-30
- << Previous
- page 1 of 1
- Next >>
