SQLServerCentral / Discuss Content Posted by Sureshkumar Ramakrishnan / Article Discussions / Article Discussions by Author / New T-SQL Features in SQL Server 2005 Part 2 / Latest Posts

RE: New T-SQL Features in SQL Server 2005 Part 2

Wayne West — Wed, 28 Nov 2007 08:44:31 GMT

Very good series! My entire shop, with the exception of a one-shot project, is SQL 2000, I'm hoping to move it to 2k5 in the next six months as prep for 2k8. Useful stuff, I only wish that your articles linked to previous/next articles in the series.

RE: New T-SQL Features in SQL Server 2005 Part 2

Mohan-383366 — Fri, 08 Dec 2006 08:01:00 GMT

Good work Suresh. I am following this series. Thanks a lot.

RE: New T-SQL Features in SQL Server 2005 Part 2

srad — Thu, 07 Dec 2006 08:10:00 GMT

Couple of things incorrect with the OUTPUT example. There is no 'Oxford' store to update in dbo.tblStore and the SELECT * FROM dbo.StoreAudit should show the InsertedStore as 'Grantham'.

RE: New T-SQL Features in SQL Server 2005 Part 2

Yelena Varshal — Wed, 06 Dec 2006 13:30:00 GMT

Good Article, easy to read and understand.

RE: New T-SQL Features in SQL Server 2005 Part 2

Sureshkumar Ramakrishnan — Wed, 06 Dec 2006 10:04:00 GMT

You are right D'Archy .The section table should not be populated with the records for Module 4.

Apologies for that ..Just execute the following script and it should give you the desired results

delete from tblsection where fk_moduleid=4

Thanks for your comments

RE: New T-SQL Features in SQL Server 2005 Part 2

Charles Kincaid — Wed, 06 Dec 2006 08:32:00 GMT

Great article!

I particularly enjoy the OUTPUT clause. One of the thing that I bi***, er, gripe about is data archiving. It is usually left out of designs until the server fills up. This will be a great boon as I can now write my archive function with only one statement per table and wrap the whole thing in a transaction. My archive database is an exact copy, structurally, of the production database.

RE: New T-SQL Features in SQL Server 2005 Part 2

Holy One — Wed, 06 Dec 2006 08:14:00 GMT

Isn't there an error in the first example? Shouldn't the last record in tblsection join to the 4, Test record in tblModule?

I think that you didn't mean to insert the 4, TEST record into tblModule, correct?

D'Arcy

RE: New T-SQL Features in SQL Server 2005 Part 2

Sureshkumar Ramakrishnan — Wed, 06 Dec 2006 03:22:00 GMT

Hi All,

The following are the references that were used in the write up for the article.

It has been missed during the compliation of the article.Please refer to the reference for further details.

REFERENCES

1.SQL Server 2005 Books Online

2.An Overview of SQL Server 2005 for the Database Developer :http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql_ovyukondev.asp

New T-SQL Features in SQL Server 2005 Part 2

Sureshkumar Ramakrishnan — Sun, 26 Nov 2006 11:23:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/sramakrishnan/2738.asp