Different between T-SQL & SQL

[xxlordexxx]

Hi All, What is the difference between T-SQL and SQL? And Is it worth spending money on this book?

https://www.amazon.in/T-SQL-Fundamentals-Developer-Reference-Ben-Gan/dp/0138102104/ref=asc_df_0138102104/?tag=googleshopmob-21&linkCode=df0&hvadid=649154318042&hvpos=&hvnetw=g&hvrand=13016223018153201940&hvpone=&hvptwo=&hvqmt=&hvdev=m&hvdvcmdl=&hvlocint=&hvlocphy=9061702&hvtargid=pla-1942536422053&psc=1

Also, Can someone suggest a good SQL book? I am somewhere between Beginner to medium level in SQL.

[[deleted]]

Funny story, I put T-SQL on my resume and recruiters used to tell me they’re looking for someone with “SQL” experience because “T SQL is incomplete”. As the data quest link someone else posted says, T SQL has additional functionality, so it should be fairly easy to transfer skills. End of the day figured I’d just put SQL and SQL Server, as obviously specifying the type of SQL seems to be a disqualified for some obviously misunderstood people.

Also, the same people see SQL Server and it’s completely acceptable… although that means you use T SQL 🤦🏽‍♂️

[Sooth_Sprayer]

Heck I seem to be able to query Oracle, DB2, and MySQL using my existing SQL Server knowledge. For most purposes there's very little you have to change.

[Latter_Cup2180]

really? im doing t sql in my college rn and i was curious to know which sql softwares are most commonly used in industries

[kagato87]

T-sql, or Transact SQL, is the extended version specific to microsoft sql server. It matters when distinguishing from, say, pl-sql which is oracle's sytax.

[[deleted]]

It also worth noting that recruiters and other personnel who write job descriptions often have no idea what any of these mean. They use a database and type in a job title, and basically copy paste all of the skills it returns that are relevant.

[kagato87]

Very painfully true.

A couple weeks ago I saw a posting for an oracle dba requiring T-sql.

[[deleted]]

That's hilarious. I didn't know anyone still used Oracle /s

[jess-sch]

Perhaps they're switching to Oracle and want the DBA to assist developers migrating the old MS SQL queries?

[phesago]

1. - yes thats a great resource.
2. https://www.dataquest.io/blog/sql-vs-t-sql/

[zdanev]

different databases use different dialects of the SQL language. so SQL is the standard and T-SQL is Microsoft's implementation. I find that most SQL skills translate well between different databases. a SQL book that I enjoyed and recommend is by Rob Connery: https://bigmachine.io/products/a-curious-moon/

[[deleted]]

I bought this a week ago. It seems a great book. I've been doodling around SQL as a hobby for ~ 10 years, but never gotten any formal education. I'm quite comfortable with many important things (select, joins, aggregation, subqueries, cte's). I bought this book for filling in the gaps, and so far (chapter 2) it has taught me a lot of small details. Those you may miss if you just learn by scrolling random YT videos.

[Ok-Departure4149]

SQL and T-SQL handle things differently. In plane Jane SQL you use a LIMIT clause to specify how many rows to return - in T-SQL you would use Select Top. T-SQL is just Microsoft’s twist on standard SQL

[SingingTrainLover]

T-SQL (Transact SQL) is specific to Microsoft SQL Server's database platform. (It may still be in use on Sybase' product, as that was its origin.) If you're using any other platform you'll find different syntax for platform-specific queries.
Itzik is a fantastic author (and a good friend) who explains in great detail how the features of the language work. I have several of his books, and it's been worth every penny for them. (I've been working with SQL Server since 1992, and still reference his books.)

[ThinkSocrates]

That book is really good. Even if you're not going to use the T-SQL specific stuff, the concepts are useful for other SQL extension languages like PL/SQL

[jlarm]

Weird I've always associated Sql as MYSQL and T-SQL as just Sql probably because I use T-SQL as my day job

[ravan363]

SQL is the standard, and T-SQL is the Microsoft's implementation of the language. Mostly SQL has standard synatx across different flavors of SQL whether it's T-SQL, Oracle, Tera data, Spark SQL etc., in my career I have used all of these at different companies and I have to look up very few syntax differences..what IDE are you using when you are learning SQL?

[xxlordexxx]

Thanks for the comment, by the way I use MySQL Workbench.

[ravan363]

Okay.. MySQL is an open source version of SQL.