1 Resources for

select tblcustomers.customerid

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

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

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
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
Can a combo box be set to display only certain data: I have a combo box that selects a customer and brings up all of the data associated with that customer (Billing data on Main form, Order data (on Sub form #1) and Shipping Data on Sub form #2)...The combo box is unbound and uses a select table/query.Both subforms are 'bridged...; Tags: imroseofsharon@..., combo box, Sub; Discussion threads 2007-09-12
Using SQL Server 2008's MERGE statement: Can you get the Identity key back?This is a great idea. It can reduce the "CU" of my CRUD stored procedures to have one for both create and update.When doing the "WHEN MATCHED", can you do a begin/end block there so that you can capture the @@IDENTITY value?YesYou could do...; Tags: Paul C., Using SQL Server 2008, SELECT CustomerID, TotalSalesCount, TotalSalesAmount, GetDate, LoadDate; Discussion threads 2007-09-25

Displayging Querie results from multiple tables in a form: I have a form I am using to Edit records from two joined table records. If it finds a match in the second table it works fine. I want to use a copy of the form to add new records to the second table. The first table has the master...; Tags: second table; Discussion threads 2006-01-04
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
Assess a SQL Server applicant's skills with this TSQL test: For Test item #7: "Return the Product Category and the average Sale Price for those customers who have purchased two or more products." If what you really asked as I believe you intended to ask was:"Return the Product Category and the average Sale Price for those customers who have purchased...; Tags: applicant, developer, george_c57@..., Microsoft SQL Server, programming, server, SQL; Discussion threads 2006-10-23
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
Defining cascading referential integrity constraints in SQL Server: Cascading referential integrity constraints are foreign key constraints that tell SQL Server to perform certain actions when a primary key field in a primary key-foreign key relationship is updated or deleted. By using cascading referential integrity constraints, you can define the actions that SQL Server 2005 takes when a user...; Tags: databases, sql server; Blog posts 2007-06-25
Basic and complex SQL joins made easy: If you think SQL JOIN statements are beyond your reach, think again. This quick review of basic concepts makes joins easy by explaining each type and showing you how to use them.If you’re new to SQL, joins can be a daunting concept. There are many different types of joins and...; Tags: Programming languages, Databases, Shelley Doll, SQL; Technical articles 2002-07-08
JOIN table and stored procedure: Is is possible to JOIN a table and the results of a stored procedure (ANSI SQL, Oracle, MySQL or SQL Server)join...You would have to put the results of the stored proc in at least a temp table, then do the join. Is that what you are looking for? ...; Tags: Databases; Discussion threads 2005-02-25
Using SQL Server 2008's MERGE statement: SQL Server 2008's new MERGE statement allows you to insert, update, or delete data based on certain join conditions in the same statement. In previous versions of SQL Server, you have to create separate statements if you need to insert, update, or delete data in one table based on certain conditions...; Tags: Microsoft SQL Server, Data, Statement, Table, SQL Server 2008, MERGE, MERGE Statement, Tim, Sales Strategy, Sales Force Management, Databases, Enterprise Software, Sales, Software, Data Management, Tim Chapman; Blog posts 2007-09-24
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
Using XPath string functions in XSLT templates: Mapping XML data to target fields in another system can get tricky when there isn't a one-to-one match. Fortunately, XPath includes string functions that will help you perform advanced string translations. See how you can put these functions to work.By Brian SchaffnerWhen using Extensible Stylesheet Language Transformations XSLT templates, it's...; Tags: XML, Guest Contributor, XSLT; Technical articles 2001-09-27
Explore the capabilities of Query of Queries in ColdFusion MX: One of the features Macromedia introduced in ColdFusion 5 was the ability to execute SQL statements against a pre-existing query result set. It called this functionality Query of Queries. With ColdFusion MX, the Query of Queries feature set has been expanded even further. I’ll show you how to use Query...; Tags: Programming languages, Development tools, Databases, Brian Kotek, ColdFusion MX, Allaire ColdFusion; Technical articles 2003-06-09
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
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
Thinking SQL: Set-based logic can improve query performance: You can't teach an old dog new tricksatleast 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
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

<< Previous
page 1 of 1
Next >>

TechRepublic's E-mail Usage Policy: Numerous studies indicate that personal e-mail use at work is a leading cause of lost productivity. In addition, personal e-mail use can introduce vir ...; Buy Now

TechRepublic's Data Retention Policy: The organization is subject to data retention requirements resulting from a mix of legal, industry, and business mandates. These data retention requir ...; Buy Now