+ Post New Thread
Results 1 to 5 of 5
Web Development Thread, Recommend a book/website for T-SQL programming in Coding and Web Development; Title says it all! I'm fairly confident with queries and aggregate functions etc. but I know that T-SQL can do ...
  1. #1

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,452
    Thank Post
    1,439
    Thanked 1,170 Times in 798 Posts
    Rep Power
    707

    Recommend a book/website for T-SQL programming

    Title says it all!

    I'm fairly confident with queries and aggregate functions etc. but I know that T-SQL can do a hell of a lot more if you know what you're doing, so I'd like to learn.

    Any recommendations welcome

  2. #2


    Join Date
    May 2009
    Posts
    3,003
    Thank Post
    265
    Thanked 795 Times in 602 Posts
    Rep Power
    289
    The subject is quite wide - so it kind of depends what you want to achieve.

    Professional Microsoft SQL Server 2008 Programming by Robert Vieira might be OK. There are a lot of web based resources too (unfortunately quality is variable).

    MSDN does have some useful stuff.

  3. Thanks to pcstru from:

    LosOjos (25th October 2013)

  4. #3

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,452
    Thank Post
    1,439
    Thanked 1,170 Times in 798 Posts
    Rep Power
    707
    Quote Originally Posted by pcstru View Post
    The subject is quite wide - so it kind of depends what you want to achieve.
    I suppose I need to start with the basics of T-SQL programming so I can get an idea what you can do and the limitations. Interested in writing data manipulation scripts (particularly with regards to XML) and server side functions initially.

    Quote Originally Posted by pcstru View Post
    Professional Microsoft SQL Server 2008 Programming by Robert Vieira might be OK. There are a lot of web based resources too (unfortunately quality is variable).

    MSDN does have some useful stuff.
    Yeah I have been struggling to find quality material online, that's why I'm asking here. Lots of people copy and pasting scripts with no idea how they work.

    I'll take a look at that book, thanks

  5. #4


    Join Date
    May 2009
    Posts
    3,003
    Thank Post
    265
    Thanked 795 Times in 602 Posts
    Rep Power
    289
    Beginning T-SQL covers stored procedures and XML data types. The first few chapters deal with stuff you probably already know, but that might lull you into a (hopefully not false) sense of comfort! There's an update for 2012 - I only have the 2008 copy.

    Wrox beginning T-SQL is also on our shelves. It's a meatier tome but I can't see at a quick glance that it covers processing XML datatypes.

  6. Thanks to pcstru from:

    LosOjos (25th October 2013)

  7. #5

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,452
    Thank Post
    1,439
    Thanked 1,170 Times in 798 Posts
    Rep Power
    707
    Quote Originally Posted by pcstru View Post
    Beginning T-SQL covers stored procedures and XML data types. The first few chapters deal with stuff you probably already know, but that might lull you into a (hopefully not false) sense of comfort! There's an update for 2012 - I only have the 2008 copy.

    Wrox beginning T-SQL is also on our shelves. It's a meatier tome but I can't see at a quick glance that it covers processing XML datatypes.
    Thanks, the more material I can get my hands on the better!

    As for the XML, this is where I'm struggling to find advice online: vast majority of articles I can find are talking about the SQL XML data type, whereas what I'm trying to do is actually map XML documents to SQL fields, as opposed to storing the raw XML in SQL. I did find a method of doing this (though I have been having a little trouble with it: Dealing with 'missing' XML on import to SQL) but it's extremely slow, I'm talking 4 hours for a document in XML format that takes 5 minutes if that XML is converted to CSV and imported via a BULK INSERT. I suspect it's because rather than mapping nodes to columns, it's actually searching the entire XML document for every record. I strongly suspect that there'll be a way of doing this more efficiently using XPath queries or similar, just need a bit of guidance I can work with.

    For now of course I'm converting everything I can to CSV and importing that for the massive time saving but I'm the sort who doesn't like to be beaten until I've exhausted all options!

SHARE:
+ Post New Thread

Similar Threads

  1. Website for pupils doing OCR Nationals in ICT
    By merlinpjl in forum IT News
    Replies: 13
    Last Post: 2nd February 2011, 12:45 PM
  2. Website for sale
    By mjones43 in forum General Chat
    Replies: 20
    Last Post: 16th October 2007, 10:15 PM
  3. Replies: 37
    Last Post: 7th March 2007, 01:17 AM
  4. Recommend a broadband supplier for parents.
    By tosca925 in forum How do you do....it?
    Replies: 6
    Last Post: 27th June 2006, 11:07 AM
  5. Replies: 11
    Last Post: 3rd November 2005, 04:31 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •