Welcome to MSDN Blogs Sign in | Join | Help

SQL 2005: TSQL enhancements

Click the following link to learn things like: TOP, RANK, ROW_NUMBER, PIVOT, Recursion...

http://www.awprofessional.com/articles/article.asp?p=327394&seqNum=7&rl=1

 

 

Published Friday, September 02, 2005 9:58 PM by weix

Comments

# re: SQL 2005: TSQL enhancements

Thanks your excellent article.
A few typos found:

1.
...
make a table-valued function
CREATE FUNCTION Stretch (@length FLOAT)
RETURN @T TABLE

RETURN --> RETURNS
...


2.
...
SELECT B.* S.MinLength, S.MaxLength FROM Belt AS B
CROSS APPLY Stretch(B.Length) AS S
...

B.* S.MinLength --> B.* , S.MinLength
The comma is missing.

Saturday, September 03, 2005 6:58 PM by lxya
Anonymous comments are disabled
 
Page view tracker