Is there a free version of SQL Server where one can practice or any other tool which checks correct SQL Server syntax?
I would like an offline one.
I am expecting something like OracleXE server.
21 Answer
What you are looking for is SQL Express Edition. It is the free version with limitations.
Link:
If you want all the features of SQL Server Enterprise edition to test then you need Developer Edition.
Edit:To marc_s point here is the blog post from MSFT about MSSQL Developer Edition being free:
All you need to do is sign up for the "Dev Essentials" (Free):
1