Transact SQL is Microsoft's proprietary version of the popular SQL. The focus of this section is to provide
certain quick and dirty workarounds for some daily issues t-SQL programmers face in daily SQL development. All the
general drawbacks of SQL, and its failing to meet the relational requirements are applicable to Transact SQL as
well. Therefore, it is advised that the reader be well aware of the relational fundamentals and data management
basics in general, before attempting the samples illustrated here.
Here is an overview of the articles on this section:
- Creating a table of sequentially incrementing numbers
An SQL table of sequentially incrementing numbers can be a powerful tool in your t-SQL trick bag. It finds a role
in a variety of situations, right from parsing strings and generating dates to replacing complex procedural constructs
and cursors with simple and efficient set based code. Read more...
- Faking arrays in Transact SQL
It is a very common requirement among the SQL programmers to use multi-value strings in an SQL query especially when
the data is originated from external sources. Since there is no builtin support for an array or list datatype in
t-SQL, quite often folks use delimited VARCHAR strings to lump multiple values together. Read more...
- Concatenating row values to for listed output
Many a time, SQL programmers are faced with a requirement to generate report-like resultsets right off of a t-SQL
query. In most cases, the requirement arises from the fact that there are no sufficient tools or in-house expertise
to develop tools that can extract the data as a resultset and massage the data in the desired display format. Read more...
- Ranking data values in Transact SQL
It is a very common requirement among the SQL programmers to use multi-value strings in an SQL query especially when
the data is originated from external sources. Since there is no builtin support for an array or list datatype in
t-SQL, quite often folks use delimited VARCHAR strings to lump multiple values together. Read more...
- Character replacements in t-SQL
Quite often SQL programmers are left with the dirty job of working with badly formatted strings mostly generated
from external sources. Typical examples are badly structured date values, social security numbers with misplaced
hyphens, badly formatted phone numbers etc. Read more...
|
