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
Additional Resources
- 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 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- Select random rows from a table in SQL
- Random rows are a particularly good way to add dynamism to a site; unfortunately, SQL doesn't permit the selection of random rows. Check out this simple trick to deliver randomly selected rows. There are many ways that you can use randomly selected rows; they're especially effective when you...
- Tags: SQL, Databases, Arthur Fuller, Programming languages, NULL DEFAULT NewID, SQL Server Newsletter, TechRepublic Inc., Solution, Row, News, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Technical articles 2005-07-25
- 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
- Doing an "indirect" SQL SELECT
- Does anyone know how I can do an "indirect" SQL SELECT statement? (one in which the column to return from a table is not named explicitly, but is contained in a variable?)For example, instead of this:SELECT trailer FROM .... WHERE ...I need to be able to do something like this:DECLARE...
- Tags: ttobin100@..., SQL, SELECT @FieldName, DECLARE @FieldName nVarChar
- Discussion threads 2007-10-08
- 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
- 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
- Select Text
- In Microsoft Office Word 2007, one can select text or items in a table by using the mouse or the keyboard. One can also select text or items that are in different places. For example, the user can select a paragraph on one page and a sentence on a different...
- Tags: Microsoft Corp., Text, Keyboards, Mice, Microsoft Word, Word Processors, Microsoft Office, Hardware, Peripherals, Office Suites, Software
- White papers 2007-12-01
- Select statment in a VB code
- Select statement is timing out inside VB program code thereby resulting to ODBC failure. However the select command is correct and the same select command is working using query analyzer from the SQLSelect Statement in a VB CodeKindly post your code and let me check that to provide u the...
- Tags: tim.oyelowo@..., IVC_DATE, software, programming, Microsoft Visual Basic
- Discussion threads 2007-02-19
- 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
- Nested Select statements
- Has anyone ever used a statement like this:Select column1, column 2, (select columnA from table2) from table1 where....?This is contrary to anything I have ever seen in SQL (especially ANSI/ISO SQL), and I would appreciate your comments. ThanksSKNo I haven't, not once in in 17 yearsmore to the point...
- Tags: Databases, shelley.kuebler@...
- Discussion threads 2007-11-19
- << Previous
- page 1 of 1
- Next >>
