SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


New T-SQL Features in SQL Server 2005 Part 2


New T-SQL Features in SQL Server 2005 Part 2

Author
Message
Sureshkumar Ramakrishnan
Sureshkumar Ramakrishnan
Mr or Mrs. 500
Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)

Group: General Forum Members
Points: 582 Visits: 37
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/sramakrishnan/2738.asp


Kindest Regards,

Sureshkumar Ramakrishnan

Sureshkumar Ramakrishnan
Sureshkumar Ramakrishnan
Mr or Mrs. 500
Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)

Group: General Forum Members
Points: 582 Visits: 37

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




Kindest Regards,

Sureshkumar Ramakrishnan

Holy One
Holy One
SSC-Enthusiastic
SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)

Group: General Forum Members
Points: 127 Visits: 411

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


Charles Kincaid
Charles Kincaid
SSCertifiable
SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)

Group: General Forum Members
Points: 5499 Visits: 2384

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.



ATBCharles Kincaid
Sureshkumar Ramakrishnan
Sureshkumar Ramakrishnan
Mr or Mrs. 500
Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)Mr or Mrs. 500 (582 reputation)

Group: General Forum Members
Points: 582 Visits: 37

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




Kindest Regards,

Sureshkumar Ramakrishnan

Yelena Varshal
Yelena Varshal
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16358 Visits: 608

Good Article, easy to read and understand.




Regards,
Yelena Varshal

srad
srad
SSC Journeyman
SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)

Group: General Forum Members
Points: 91 Visits: 23
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'.



Mohan-383366
Mohan-383366
SSC Rookie
SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)

Group: General Forum Members
Points: 40 Visits: 1
Good work Suresh. I am following this series. Thanks a lot.
Wayne West
Wayne West
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10110 Visits: 3710
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.

-----
Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search