|
Author | decipherinfosys |
Title |
|
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.
|
|
Author | William Brewer |
Title |
|
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! |
|
Author | Arthur Fuller |
Title |
|
Annotation | Arthur Fuller demonstrates how running totals are simple to create in SQL Server queries once
you understand the requirements. |
|
Author | Arthur Fuller |
Title |
|
Annotation | Find 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. |
|
Author | Dinesh Asanka |
Title |
|
Annotation | Temporary 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? |
|
Author | Dinesh Asanka |
Title |
|
Annotation | SQL 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. |
|
Author | Mat |
Title |
|
Annotation | It can be surprising to see certain results when doing numeric arithmetic... |
|
Author | Arthur Fuller |
Title |
|
Annotation | Your 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. |
|
Author | Microsoft Corp. |
Title |
|
Annotation | This 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. |
|
Author | Alex Grinberg |
Title |
|
Annotation | SQL 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. |