Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- 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
- 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
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
- Create an AutoLookup query in Microsoft Access
- Want more Access tips and tricks? Automatically sign up for our free Microsoft Office Suite newsletter, delivered each Wednesday! You can reduce typing time by basing your Access forms on AutoLookup queries. For example, let's say you need todevelop an Order form that includes fields from both the Customers table...
- Tags: AutoLookup, AutoLookup query, Customers table, Mary Ann Richardson, Microsoft Access, Microsoft Corp., Orders table
- Technical articles 2005-03-15
- Build molecular queries from atoms in SQL Server
- What is your preferred method of doing things? Arthur Fuller says his M.O. is what he calls molecular queries. This scalable technique allows him to re-use and re-combine the atoms as requirements demand. Every SQL Server developer has a preferred method of doing things; mine is what I...
- Tags: Microsoft SQL Server, CustomerID, Databases, Arthur Fuller, server, ExtendedAmount, Northwind_New, SQL Server Newsletter, TechRepublic Inc., Atom, Column, Productivity, Enterprise Software, Software, Data Management
- Technical articles 2006-09-01
- 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
- Building and using table UDFs in SQL Server
- Table UDFs (user-defined functions) are one of Arthur Fuller's favorite features of SQL Server 2000 and 2005. Find out why he says that, if you've never used them, you may be in for a surprise. Table UDFs (user-defined functions) are one of my favorite features of SQL Server...
- Tags: Microsoft SQL Server, UDF, Databases, Arthur Fuller, server, SQL Server Newsletter, TechRepublic Inc., Fun, Table, Enterprise Software, Software, Data Management
- Technical articles 2006-08-07
- 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
- Thinking SQL: Set-based logic can improve query performance
- You can't teach an old dog new tricks—atleast that's what the cliché says. Many developers intentionally try to be the "olddog" so they don't have to learn new tricks. Some developers, even thosewho have been developing client server, Web-based, and smart clientapplications, still approach problems with a procedural mindset. They...
- Tags: customer id, id, performance, Robert L. Bogue, SELECT Customers.ID, SQL
- Technical articles 2005-01-18
- 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
- Problem with SQL Query in Visual Basic
- The following query works if I remove the "tblLocations.PrimaryFlag=-1" from the WHERE statement. I wanted to see if anyone could tell me what I am doing wrong. I have also tried "tblLocations.[PrimaryFlag]='-1'" and "(((tblLocations.PrimaryFlag)=-1))". I need to be able to filter for records with a -1 result for...
- Tags: Microsoft Visual Basic, programming, SELECT tblCustomers.CustomerID, strSQL, tblLocations.PrimaryFlag, tblLocations.PrimaryFlag=-1, twhite@...
- Q&A 2005-09-14
- 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
- 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
- Build Your Skills: Join syntax construction
- Knowing the right join may keep you from making a left turn and taking your troubleshooting efforts way off track. In a previous article, "Build Your Skills: The underpinnings of SQL joins," we used what may be a new term to you—inner join. SQL supports a number of join types:...
- Tags: join, inner join
- Technical articles 2004-02-02
- One Stop Order Processing (exe)
- One Stop Order Processing allows you to manage all of your orders from Ebay, Amazon and Playtrade in the same place. Access your orders from anywhere on your Local Area Network. You can quickly and easily take all orders from being received to being despatched. Manage your Internet orders in...
- Tags: Order, Internet, LANs, Networking, Microsoft Office, Network Technology, Databases, Office Suites, Software, Enterprise Software, Data Management
- Software downloads 2007-12-26
- Thinking SQL: Set-based logic can improve query performance
- Personal Best QueryThinking in SQL can improve the performance of your database queries.However, knowing that fact and acting on it are two very different things. :D[b]What do you consider your personal best query; the query that makes you proud? Share it with the community and compare your SQL prowess...
- Tags: Mark W. Kaelin, performance, SQL
- Discussion threads 2005-01-18
- Understand the effects of NULLs on inner and outer JOINs
- In this SQL Server tip, Arthur Fuller explains the effects of NULLs, and the different results obtained by inner and outer JOINs. SQL Server developers must understand two things: the difference between inner and outer JOINs and the effect of NULLs upon these choices. This tip ...
- Tags: Human Resources, Row, Column, Databases, Arthur Fuller, Network technology, SQL Server Newsletter, Networking, Enterprise Software, Software, Data Management
- Technical articles 2006-11-28
- MBA for Avon Reps (exe)
- Avon Software for Avon Reps - Avon Software program for Customer Tracking, Sales Orders, Reports, Business Cards & Labels, Inventory, Automatically Create Sorted Purchase Orders, Upload Orders to Avon, Create & Adjust Delivery List (both Orders & Brochures), Expense Accounting.
- Tags: Software, MBA, Tools & Techniques, Sales Strategy, Management, Sales
- Software downloads 2006-08-28
- How Do I create a Name Code for a Invoice or receivers Document
- I'm a novice! I've developed a Purchase Orders database for my employer. In this database I've managed to create text whare the data type is specified as Number. Eg: the Products table (there is the PK[ProductID], and the FK SupplierID[Number], CompanyIDCustomerID[Number]these two FK appear as text in the datasheet. I'm...
- Tags: pilgrim001@...
- Discussion threads 2007-06-04
- BS1 Enterprise Accounting with Manufacturing (exe)
- Manufacturing, distribution, and accounting software: accounts payable, accounts receivable, general ledger, inventory, purchase orders, sales orders, quotes, manufacturing, and sales analysis. Sales orders may be entered as quotes and printed for customer approval, picking slips printed, orders confirmed, bills of lading printed, and backorders tracked. Manufacturing orders default to the...
- Tags: Accounting, Manufacturing, Sales Strategy, Sales
- Software downloads 2008-02-08
- << Previous
- page 1 of 1
- Next >>
