1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

What is T-SQL

Discussion in 'Databases' started by makcapri, Dec 7, 2012.

  1. #1
    What is T-SQL. I searched google but did not understand clearly. Is there anyone who can tell me about T-SQL. I have learnd SQL from w3schools but do not know about T-SQL. Please somebody explain in easy words.
    SEMrush
     
    Solved! View solution.
    makcapri, Dec 7, 2012 IP
    SEMrush
  2. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,287
    Likes Received:
    2,602
    Best Answers:
    460
    Trophy Points:
    710
    Digital Goods:
    29
    #2
    digitalpoint, Dec 7, 2012 IP
  3. makcapri

    makcapri Greenhorn

    Messages:
    70
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #3
    I want to learn T-SQL Server 2008. First I have to learn SQL properly then T-SQL .. AM I RIGHT?
    I have learned SQL from w3schools. Any best website or book for T-SQL from very basic leaning please suggest
     
    makcapri, Dec 8, 2012 IP
  4. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
  5. makcapri

    makcapri Greenhorn

    Messages:
    70
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #5
    makcapri, Dec 9, 2012 IP
  6. makcapri

    makcapri Greenhorn

    Messages:
    70
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #6
    Thanks for the answer. So, tell me DO I NEED TO LEARN SQL FROM W3SCHOOLS THEN T-SQL? OR I CAN DIRECTLY JUMP TO START LEARNING T-SQL. WHAT DO YOU SUGGEST
     
    makcapri, Dec 10, 2012 IP
  7. concerto49

    concerto49 Greenhorn

    Messages:
    83
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    10
    #7
    Suggest you learn SQL first if you don't already know it. Learning the basics and building blocks always helps and will be useful in the future.
     
    concerto49, Dec 13, 2012 IP
  8. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #8
    Rukbat, Dec 13, 2012 IP
  9. jerrymark

    jerrymark Peon

    Messages:
    10
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #9
    Transact-SQL (T-SQL) is microsoft's and sybase's proprietary extension to sql. SQL, often expanded to Structured Query Language, is a standardized computer language that was originally developed by IBM for querying, altering and defining relational databases, using declarative statements. T-SQL expands on the SQL standard to include procedural programming, local variables, various support functions for string processing, date processing, mathematics, etc.
     
    jerrymark, Dec 26, 2012 IP
  10. agitetech

    agitetech Peon

    Messages:
    122
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #10
    SQL is a language used to communicate with relational databases. It defines operations for inserting, deleting, retrieving and updating information organized in tables. It is also used for managing databases. Although there are standards for SQL, such as ANSI SQL92 and SQL99, most databases use their own dialect and/or extentions. Microsoft's flavor of SQL used in SQL Server 7 and SQL Server 2000 is called T-SQL.
     
    agitetech, Dec 27, 2012 IP
  11. iliveforyou

    iliveforyou Active Member

    Messages:
    207
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #11
    you can learn t-sql language from: http://www.tsql.info/
     
    iliveforyou, Jan 7, 2013 IP
  12. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #12
    http://www.tsql.info/ is a good site if a) you already know SQL and b) you have at least a little experience with T-SQL. It doesn't teach T-SQL, it's just a bare language reference. http://www.tsql.info/sql.php is a good bare SQL language reference, but neither one is a tutorial.
     
    Rukbat, Jan 8, 2013 IP
  13. c4ntaloop

    c4ntaloop Greenhorn

    Messages:
    14
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    13
    #13
    If you dont know anything about Query language, best to go with SQL first. Learn the basic, the core foundation, and get used to the logic.

    After you master that you can decide to go deep to T-SQL, MySQL, etc. The query/syntax is a little bit different among the language, however the logic is the same.

    Its just like saying "hey buddy" in some countries and "hey mate" in some others. The idea is the same.

    If you are really serious and want to become expert buy a good book or subscribe to those online video tutorials, it is worth. Download and install the SQL server and get your hands on it, there is free edition. Then after a while, test what you learn here http://www.sql-ex.ru/tsql . You'll become expert in no time.
     
    c4ntaloop, Jan 15, 2013 IP
  14. afoley77

    afoley77 Active Member

    Messages:
    927
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    70
    #14
    T-SQL( Transact-SQL) is the procedural programming language or (procedural) extensions for SQL used by SQL Server. So if you are strong with your SQL basics then you will easily learn T-SQL. So i would like to suggest you to go firstly with SQL, then T-SQL..
     
    afoley77, Jan 23, 2013 IP
  15. Synastute

    Synastute Greenhorn

    Messages:
    96
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    6
    #15
    T-SQL means Transact SQL which is the extension of SQL used by Microsoft in SQL server.
     
    Synastute, Feb 3, 2013 IP
  16. TestingWhiz1

    TestingWhiz1 Member

    Messages:
    64
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    28
    #16
    T-SQL stands for Transact SQL. It is an extension to SQL from Sybase & Microsoft with several features like error handling, transaction control,etc.
     
    TestingWhiz1, Feb 7, 2013 IP
    1 person likes this.
  17. randheer

    randheer Greenhorn

    Messages:
    19
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #17
    Checkout TSQL Tutorial on http://www.sqlserverquest.com/p/t-sql-tutorial.html
    http://www.sqlserverquest.com/p/t-sql-tutorial.html
     
    randheer, Nov 8, 2014 IP
  18. ghost.rider

    ghost.rider Active Member

    Messages:
    134
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    75
    Digital Goods:
    2
    #18
    Just learn it if you want to really try
     
    ghost.rider, Nov 20, 2014 IP