Books and articles about SQL Rambler's Top100 Сменить язык на: Русский 19 March 2024 13:00:10


www.sql-ex.ru
Skip Navigation Links  

 

Transact-SQL


Authordecipherinfosys
Title

COALESCE(), ISNULL(), NVL()

Annotation ISNULL (MS SQL Server), NVL(Oracle) functions are used to replace null values with user defined value in case the user wants to treat null value differently.

AuthorWilliam Brewer
Title

Quantifying Text differences in T-SQL

Annotation In TSQL there is a limit to the way you can compare text strings. They're either equal or not. Sooner or later, usually when cleaning data, something more subtle is required!

AuthorYousef Ekhtiari
Title

Some Usages for XML

Annotation...

AuthorArthur Fuller
Title

Running totals in SQL Server queries

AnnotationArthur Fuller demonstrates how running totals are simple to create in SQL Server queries once you understand the requirements.

AuthorArthur Fuller
Title

Add some curves to your SQL Server Model database

AnnotationFind out why Arthur Fuller believes that the Model database is the most overlooked and underused feature in SQL Server. He presents a sample demonstration of how you might use the Model database.

AuthorDinesh Asanka
Title

Temp Tables in SQL Server

AnnotationTemporary tables are always a great help for a developer. In the early days when I used Access I used to create tables that I treated as temporary and then delete them whenever I finished my task. Using SQL Server this is much simpler. Or is it?

AuthorDinesh Asanka
Title

Triggers to Execute in Pre Defined Order

AnnotationSQL Server allows multiple triggers on a table, but the order in which they are executed can sometimes cause problems. Author Dinesh Asanka brings us a technique for managing the order of execution for your triggers.

AuthorMat
Title

Multiplication and Division with Numerics

AnnotationIt can be surprising to see certain results when doing numeric arithmetic...

AuthorArthur Fuller
Title

Intelligent Database Design Using Hash Keys

AnnotationYour application may require an index based on a lengthy string, or even worse, a concatenation of two strings, or of a string and one or two integers. In a small table, you might not notice the impact. But suppose the table of interest contains 50 million rows? Then you will notice the impact both in terms of storage requirements and search performance.You don’t have to do it this way. There is a very slick alternative, using what are known alternatively as hash buckets or hash keys.

AuthorMicrosoft Corp.
Title

Microsoft SQL Server 2000 User Defined Functions Whitepaper

AnnotationThis white paper outlines the characteristics of the new user-defined function (UDF) feature that is introduced in Microsoft SQL Server 2000. The white paper also summarizes how you can create your own Transact-SQL functions to extend the programmability of Transact-SQL.

AuthorRandy Dyess
Title

Common Transact-SQL Performance Coding Errors


AuthorAlex Grinberg
Title

The ARRAY In SQL Server 2000

AnnotationSQL Server 2000 and Transact-SQL have many features, but one of the most often asked for features has been the implementation of some sort of array data type. This basic programming concept is notably absent from the development platform and results in many headaches and frustrations for DBAs. Alex Grinberg brings us his techniques for simulating arrays in SQL Server 2000.


Usage of any materials of this site is possible
only under condition of mandatory allocation of the direct link to a site
http://www.sqlbooks.ru
on each page where used materials are placed.

 Main   Articles    Books 
Рейтинг@Mail.ru Rambler's Top100 Alt Упражнения по SQL: обучение, тестирование, сертификация по языку SQL Copyright c 2002-2006. All rights reserved.