What is T-SQL

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.

 

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

 

http://lmgtfy.com/?q=tsql+tutorial

 

too bad...

 

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

 

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.

 

And DON'T learn anyting from W3Schools. It's a greaat reference site if you forgot some syntax, and don't remember the address of any other site to check it on, but a lot of what they "teach" is just plain wrong - especially if you eventually want to learn T-SQL.

http://www.sqlcourse.com/index.html is good for the basics. http://msdn.microsoft.com/en-us/library/ms365303.aspx is a basic gateway for T-SQL.

 

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.

 

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.

 

you can learn t-sql language from: http://www.tsql.info/

 

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.

 

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.

 

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..

 

T-SQL means Transact SQL which is the extension of SQL used by Microsoft in SQL server.

 

T-SQL stands for Transact SQL. It is an extension to SQL from Sybase & Microsoft with several features like error handling, transaction control,etc.

 

Checkout TSQL Tutorial on http://www.sqlserverquest.com/p/t-sql-tutorial.html
http://www.sqlserverquest.com/p/t-sql-tutorial.html

 

Just learn it if you want to really try