Results 1 to 5 of 5

Thread: Since SQL Server 2000 T-SQL

  1. Sep 24th, 2015, 09:49 AM #1
    Liquid Metal
    Liquid Metal is offline

    Thread Starter
    Frenzied Member
    Join Date
    Apr 2003
    Location
    The Future - Skynet
    Posts
    1,157

    Since SQL Server 2000 T-SQL

    I have not code for a long time since when I moved into management about 9 years ago.

    When it comes to database, the last SQL Server database that I was hands on was SQL Server 2000.

    I have recently got back into it just to keep up with the pace. I have installed SQL Server 2014 and seems like there are new functions and operators such as Except, Intersect, RollUp, Cube, etc...

    Is there a site that you can share to pickup on new T-SQL features?

    Also, if there are new functions or features that you think is useful or great that have been introduced since then, please feel free to share.

    Last, is there as sister forum for SQL Server questions. In the past, I used this one mainly for VB6 and VBA.

    Thank You
    I'll Be Back!

    T-1000

    Microsoft .Net 2005
    Microsoft Visual Basic 6
    Prefer using API
    Reply With Quote Reply With Quote
  2. Sep 24th, 2015, 10:15 AM #2
    techgnome
    techgnome is offline
    Smooth Moperator techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,538

    Re: Since SQL Server 2000 T-SQL

    http://www.dbforums.com/ & http://www.sqlservercentral.com/
    are good.

    As for updates, to t-sql itself, there hasn't been a lot... MS has added a few things to SQL server since... notably RowNumber, Rank, and a couple of other statistical sort of functions.

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  3. Sep 24th, 2015, 07:09 PM #3
    Liquid Metal
    Liquid Metal is offline

    Thread Starter
    Frenzied Member
    Join Date
    Apr 2003
    Location
    The Future - Skynet
    Posts
    1,157

    Re: Since SQL Server 2000 T-SQL

    Thank you! Exactly what I am looking for.
    I'll Be Back!

    T-1000

    Microsoft .Net 2005
    Microsoft Visual Basic 6
    Prefer using API
    Reply With Quote Reply With Quote
  4. Sep 24th, 2015, 07:21 PM #4
    Liquid Metal
    Liquid Metal is offline

    Thread Starter
    Frenzied Member
    Join Date
    Apr 2003
    Location
    The Future - Skynet
    Posts
    1,157

    Re: Since SQL Server 2000 T-SQL

    Quote Originally Posted by techgnome View Post
    http://www.dbforums.com/
    http://www.sqlservercentral.com/
    DBForums doesn't seems as active as SQLServerCentral.
    I'll Be Back!

    T-1000

    Microsoft .Net 2005
    Microsoft Visual Basic 6
    Prefer using API
    Reply With Quote Reply With Quote
  5. Sep 24th, 2015, 07:21 PM #5
    Liquid Metal
    Liquid Metal is offline

    Thread Starter
    Frenzied Member
    Join Date
    Apr 2003
    Location
    The Future - Skynet
    Posts
    1,157

    Re: Since SQL Server 2000 T-SQL

    Accidentally Duplicated Post. Please delete this one. Sorry
    I'll Be Back!

    T-1000

    Microsoft .Net 2005
    Microsoft Visual Basic 6
    Prefer using API
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width