http://www.sqlservercentral.com/Content tagged T-SQL, Basic Querying posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)In this article Randy Dyness shows you how to avoid temp tables whenever to maximize the performance of your queries. http://www.sqlservercentral.com/articles/Performance+Tuning/temptabl/662/2006/06/02http://www.sqlservercentral.com/articles/Performance+Tuning/temptabl/662/Knowing the various types of joins can greatly expand your T-SQL skills. Jambu Krishnamurthy brings us a refresher article on the various types of joins and how to write them. http://www.sqlservercentral.com/articles/Basic+Querying/2937/2008/03/26http://www.sqlservercentral.com/articles/Basic+Querying/2937/This article by James Travis details the differences between IS NULL and = NULL. He also discusses the ANSI_NULLS setting. http://www.sqlservercentral.com/articles/Basic+Querying/understandingthedifferencebetweenisnull/871/2008/02/22http://www.sqlservercentral.com/articles/Basic+Querying/understandingthedifferencebetweenisnull/871/The use of bitmasking is usually limited to decoding values in the system views, but it can be useful in other places when you want to save space. New author Lee Everest brings us an introduction to bitmasking and its use in SQL Server 2005. http://www.sqlservercentral.com/articles/Miscellaneous/2748/2007/12/05http://www.sqlservercentral.com/articles/Miscellaneous/2748/Identity columns are commonly used as primary keys in database tables. These columns automatically assign a value for each new row inserted. But what if you want to insert your own value into the column? It's actually very easy to do.http://www.sqlservercentral.com/redirect/articles/3156/2007/08/21http://www.sqlservercentral.com/redirect/articles/3156/Arranging SQL data that you can effectively analyse requires an understanding of how to use certain SQL clauses and operators. These tips will help you figure out how to build statements that will give you the results you want.http://www.sqlservercentral.com/redirect/articles/3112/2007/07/27http://www.sqlservercentral.com/redirect/articles/3112/We're pleased to announce that Robert will be writing for us each month - generally on stored procedures, but occasionally on a different topic. This article discusses how nesting stored procedures works and how to use @@NextLevel. Good reading! If there is a stored procedure topic you'd like to see covered, add a comment to the article or email us at articles@sqlservercentral.com http://www.sqlservercentral.com/articles/Basic+Querying/nestingstoredprocedures/998/2007/05/18http://www.sqlservercentral.com/articles/Basic+Querying/nestingstoredprocedures/998/Knowing the various types of joins can greatly expand your T-SQL skills. Jambu Krishnamurthy brings us a refresher article on the various types of joins and how to write them. http://www.sqlservercentral.com/articles/Basic+Querying/2937/2008/03/26http://www.sqlservercentral.com/articles/Basic+Querying/2937/The use of bitmasking is usually limited to decoding values in the system views, but it can be useful in other places when you want to save space. New author Lee Everest brings us an introduction to bitmasking and its use in SQL Server 2005. http://www.sqlservercentral.com/articles/Miscellaneous/2748/2007/12/05http://www.sqlservercentral.com/articles/Miscellaneous/2748/In this video, Kathi continues her T-SQL series and exands how to use the WHERE clause. http://www.sqlservercentral.com/redirect/articles/2675/2006/10/26http://www.sqlservercentral.com/redirect/articles/2675/In this second part video from Kathi, she covers how to write T-SQL in much more indepth. She covers how to handle NULLs and many more items in this video. http://www.sqlservercentral.com/redirect/articles/2642/2006/10/12http://www.sqlservercentral.com/redirect/articles/2642/In this video, you'll learn how to write basic select statements. This beginner video takes you from the ground up writing T-SQL. http://www.sqlservercentral.com/redirect/articles/2636/2006/10/04http://www.sqlservercentral.com/redirect/articles/2636/This is an entry level look at how temp tables work in SQL along with some tips about how to use them effectively. http://www.sqlservercentral.com/articles/Basic+Querying/temptablesinsqlserver/1279/2006/07/14http://www.sqlservercentral.com/articles/Basic+Querying/temptablesinsqlserver/1279/In this article Randy Dyness shows you how to avoid temp tables whenever to maximize the performance of your queries. http://www.sqlservercentral.com/articles/Performance+Tuning/temptabl/662/2006/06/02http://www.sqlservercentral.com/articles/Performance+Tuning/temptabl/662/Part 2 of Steve Jones' series on beginning SQL Server from the perspective of a system administrator or someone not used to working with SQL Server. If you've been designated the new administrator, take a look at this series for some help in coming up to speed on this product. http://www.sqlservercentral.com/articles/Administering/beginningsqlserverlimityourqueries/1458/2006/04/14http://www.sqlservercentral.com/articles/Administering/beginningsqlserverlimityourqueries/1458/A view is a virtual table that consists of columns from one or more tables. Though it is similar to a table, it is stored in the database. It is a query stored as an object. Hence, a view is an object that derives its data from one or more tables. These tables are referred to as base or underlying tables. http://www.sqlservercentral.com/redirect/articles/2169/2005/11/24http://www.sqlservercentral.com/redirect/articles/2169/We've had a lot of coverage of dynamic sql (including another great one from Robert Marda later this week) but this one is a little different. Done in a question/answer format, Andy tries to explain to junior developers why dynamic sql is to be avoided, how to do so, what to do when you can't. http://www.sqlservercentral.com/articles/Performance+Tuning/dynamicsqlorstoredprocedure/969/2005/08/26http://www.sqlservercentral.com/articles/Performance+Tuning/dynamicsqlorstoredprocedure/969/This article by James Travis details the differences between IS NULL and = NULL. He also discusses the ANSI_NULLS setting. http://www.sqlservercentral.com/articles/Basic+Querying/understandingthedifferencebetweenisnull/871/2008/02/22http://www.sqlservercentral.com/articles/Basic+Querying/understandingthedifferencebetweenisnull/871/SQL Server 2000 is an extremely powerful and flexible development platform, but if the users mess up the data, there's nothing you can do. Protecting the integrity sometimes means severely limiting access to users. Roy Carlson brings us a technique using sp_makewebtask that you can easily use to provide users with some data without giving them query access. http://www.sqlservercentral.com/articles/Miscellaneous/youwanttodowhatwithmydatabase/1882/2005/05/17http://www.sqlservercentral.com/articles/Miscellaneous/youwanttodowhatwithmydatabase/1882/When most developers think of joins, they think of a.SomethingID = b.SomethingID. This type of join, the equijoin, is vitally important to SQL programming; however, it only scratches the surface of the power of the SQL join. This is the first in a series of articles that will look at several different types of exotic joins in SQL. This article will focus on using the BETWEEN operator in joins when dealing with range-based data. http://www.sqlservercentral.com/articles/Basic+Querying/usingexoticjoinsinsql/899/2005/04/29http://www.sqlservercentral.com/articles/Basic+Querying/usingexoticjoinsinsql/899/Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary! http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/2005/02/04http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/In this article, Brian Kelley continues his series on Query Analyzer for SQL Server 2000. Query Analyzer offers a highly configurable integrated development environment (IDE). Some of the areas Brian looks at are how to modify the fonts and colors, set connection settings, choose scripting options, and customizing file and result set options. Learn how to make the most of the IDE and make it work for you. http://www.sqlservercentral.com/articles/Administering/qa2k_3/740/2005/01/07http://www.sqlservercentral.com/articles/Administering/qa2k_3/740/Brian Kelley continues his series on getting the most out of SQL Server 2000's Query Analyzer. In this article he looks at the Object Browser and the Transact-SQL Debugger, new features in the 2000 Edition which can reduce development and troubleshooting time for DBAs and database developers. http://www.sqlservercentral.com/articles/Administering/qa2k_2/622/2004/12/31http://www.sqlservercentral.com/articles/Administering/qa2k_2/622/So you open up the tool a hundred times a day. In this article by Brian Kelley, he shows you how to get the most out of some of the known and unknown features. http://www.sqlservercentral.com/articles/Administering/qa2k_1/614/2004/12/23http://www.sqlservercentral.com/articles/Administering/qa2k_1/614/Working with date and time data in SQL Server can be a bit cumersome using just T-SQL. With the separate datatypes being pulled from SQL Server 2005 for the time being, however, it is something that a DBA needs to get used to. Robert Marda brings us an instructional look at the different datetime data types and some things you should be aware of when developing with them. http://www.sqlservercentral.com/articles/Basic+Querying/manipulatingandusingdatetimedata/1544/2004/10/27http://www.sqlservercentral.com/articles/Basic+Querying/manipulatingandusingdatetimedata/1544/This series of articles will examine the purposes, uses, and optimization of cursors in SQL 2000.http://www.sqlservercentral.com/redirect/articles/1541/2004/10/14http://www.sqlservercentral.com/redirect/articles/1541/Part 2 of Steve Jones' series on beginning SQL Server from the perspective of a system administrator or someone not used to working with SQL Server. If you've been designated the new administrator, take a look at this series for some help in coming up to speed on this product. http://www.sqlservercentral.com/articles/Administering/beginningsqlserverlimityourqueries/1458/2006/04/14http://www.sqlservercentral.com/articles/Administering/beginningsqlserverlimityourqueries/1458/The ORDER BY clause is one of the basic keywords that defines the SQL Language. And it can help prevent strange results from being returned to the average user. Read on to see how and why this addition to your queries can help ensure more "ordered" results :) http://www.sqlservercentral.com/articles/Basic+Querying/whentousetheorderbyclause/1357/2004/05/19http://www.sqlservercentral.com/articles/Basic+Querying/whentousetheorderbyclause/1357/Have you ever built a join graphically using Access or Visual Studio? Did you know that you can do this with the native SQL Server tools? And it's easy! Follow along as Dale Corey shows you how. http://www.sqlservercentral.com/articles/Basic+Querying/buildingjoinstheeasyway/1341/2004/04/26http://www.sqlservercentral.com/articles/Basic+Querying/buildingjoinstheeasyway/1341/Continuing Steve Jones' series on string manipulation in T-SQL, this article examines how quotations are handled in T-SQL. http://www.sqlservercentral.com/articles/Basic+Querying/tamethosestringspart8/627/2004/03/25http://www.sqlservercentral.com/articles/Basic+Querying/tamethosestringspart8/627/