September 2004 - Posts

• Query specification: but is it grouped?

  Earlier, I explained what exactly a query specification is. It is important to note that query specifications come in two very different varieties: grouped and not. A query specification is grouped if it has any of the following: GROUP BY clause, HAVING Read More... Posted Tuesday, September 28, 2004 11:20 AM by TSQL_language | 0 Comments

• Extended parameterization

  Thanks to everyone who commented on parameterization in TSQL. It was a pretty eye-opening experience to see the lack of "extended" parameterization (beyond simple runtime values) being such a pain point for the users. I'll make sure your voices are heard Read More... Posted Monday, September 27, 2004 9:55 AM by TSQL_language | 0 Comments

• TSQL: compiler under the covers

  Here is an interesting comment from chrisbro about some features he finds sorely missing in TSQL: * Can't specify a parameter to be used as an IN clause * Can't easily specify parameters to be used in the ORDER BY clause; especially painful to do multiple Read More... Posted Friday, September 24, 2004 12:00 PM by TSQL_language | 13 Comments

• Basics: query specification

  Let's start from basics, if it looks boring, feel free skip to the next post :-). I just feel I need to establish some terminology first. The main building block of SQL is what the standard calls "query specification". It consists of "clauses": SELECT, Read More... Posted Thursday, September 23, 2004 12:35 PM by TSQL_language | 1 Comments

• Intro

  My name is not actually TSQL language :-), I am Eugene Zabokritski, a Technical Lead working in the TSQL front-end team of the SQL Engine group. My plan is to post a series of overviews of some TSQL areas that I think are complicated enough to warrant Read More... Posted Wednesday, September 22, 2004 5:44 PM by TSQL_language | 8 Comments