3 Resources for

orderid

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

Filtering data with SQL Server: In SQL Server, data analysis begins with the GROUP BY statement. This powerful SQL feature filters data to return the exact information you need.Relational data is typically stored in a normalized format, which means that you repeat as little data as possible; typically just keys that tie one table to...; Tags: Databases, NorthWind database, Relational Data, Craig Utley, server, Microsoft SQL Server, Group-By, SELECT o.OrderID, OrderID, Order Details; Technical articles 2002-07-30
SQL Server & XML integration: XML has emerged as the standard for data. Learn how to utilize XML when working with SQL Server databases, focusing on the FOR XML clause.By Jonathan Lurie & Timothy StockstillThe newcomer to the ranks of data storage solutions is XML, short for eXtensible Markup Language. XML gives Web developers greater...; Tags: Microsoft SQL Server, server, Guest Contributor, XML, ProductID, OrderID; Technical articles 2002-06-05
Return to the record you were working on when you reopen an Access form: If you get interrupted while working on a record in an Access form, finding your way back to it can be time-consuming. Here are two ways to bookmark the current record so that you can hop straight to it when you reopen the form. by Susan Harkins; Tags: Microsoft Access, Command Button, Record, Form, varID, OrderID, vbOKOnly, Sub, Susan Sales Harkins, Databases, Microsoft Office, Storage, Enterprise Software, Software, Data Management, Office Suites, Hardware, Susan Harkins; Blog posts 2008-08-28

Additional Resources

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
How do I... Generate a running total in an Access query?: This article is also available as a PDF download.Displaying subtotals, grand totals, and otherwisesummarizing data is a common report feature. You can display a running total ina report simply by setting a property. A runningtotal is a cumulative sum that evaluates the previous rows and the currentrow. In other words,...; Tags: Displaying, Microsoft Access, SQL, Susan Harkins, Value at Risk; Technical articles 2006-12-04

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
SQL query (MS Access): Hi,I am trying to learn how to use SQL and am completely stuck atm. Any help at all would be most welcomely received. I have stared at this for so long that it isn't even funny any more :) [Apologies for being a total noob].I have created a database which...; Tags: Databases, Microsoft Access, Microsoft Corp., AUTH.Author_ID, CUSTORDPROD, SELECT CUSORDS.Order_ID; Discussion threads 2008-03-19
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
How do I... return a unique list in Excel?: This information is also available as a PDF download.Lists work their way into just about everything we do. Ordinarily, you might not think of worksheet data as a list, but that data can quickly turn into one, depending on your needs. That need becomes a bit more complicated if you...; Tags: Data, Microsoft Excel, List, Cell, Susan Harkins; Blog posts 2007-08-06
Speed up SQL Server database queries with these tips: If you've worked with SQL Server databases for any amount of time, it's practically a given that you've run into slow running queries. Sometimes the reason for the slow response time is due to the load on the system, and other times it is because the query is not written...; Tags: Business Situation, Database, Microsoft SQL Server, Statement, SaleDate, Tim Chapman; Blog posts 2007-09-11
Two ways to return a unique list in Excel: Filtering data to produce a unique list of entries is a common task in Excel. Here are two methods of getting the job done: manually and with a little bit of VBA automation. Lists work their way into just about everything we do. Ordinarily, you might not...; Tags: Data, List, Cell, AdvancedFilter Method, Default Value, Microsoft Excel, Microsoft Office, Office Suites, Software, Susan Harkins; Blog posts 2009-03-17
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
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
Include totals with numeric values via DataGrid: I talk to a lot of people who sneer whendiscussing the DataGridcontrol; they often discard it in favor of third-partyalternatives. DataGrid, a core piece of the .NET Framework, isactually a valuable part of my development toolbox. Presenting data in a table format provides manyopportunities. I'll explain how...; Tags: DataGrid, DataGrid Control, sConn, server, Tony Patton, totalFreight; Technical articles 2005-06-29
Applied Reflection: Creating a dynamic Web service to simplify code: This article is also available as a TechRepublic download, complete with sample code.Many developersare using Web services to communicate with their business logic, and there area lot of advantages to this. This approach allows a wide range of flexibilityin the architecture that would otherwise be very hard to come by....; Tags: Web services, Zach Smith, Web service, business logic, Web; Technical articles 2006-10-19
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
Upsizing an existing Microsoft Access database: Most Access and SQL Server developers eventually face the prospect of upsizing an Access database to SQL Server. Thanks to the Access Upsizing Wizard, most of the process is painless, especially if you're creating a new ADP to interact with SQL Server data. However, the wizard isn't perfect, and there...; Tags: Databases, Enterprise software, Susan Harkins, Microsoft Corp., database, Microsoft SQL Server, Microsoft Access, server; Technical articles 2003-07-17
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
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
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

<< Previous
page 1 of 1
Next >>

Content Types

Blog posts (1 results)

Technical articles (2 results)

IT Professional's Guide to Policies and Procedures, Third Ed: Whether you're creating policies for management, training, personnel, support, privacy, Internet/e-mail usage, security, or inventory, you'll meet the needs of your entire enterprise with this one download!; Buy Now

IT Help Desk Survival Guide, Third Edition: TechRepublic's IT Help Desk Survival Guide, Third Edition provides tools and recommendations to help you better manage help desk services, improve end-user support, troubleshoot frustrating hardware issues, identify quick fixes to vexing Windows problems, and help users make the most of Microsoft Office 2003.; Buy Now

orderid

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

Additional Resources

Content Types

CIO Sessions