What's the difference between tsql and isql?

Question

I saw this in this post,and is really confused

Answer 1

TSql is Microsoft's native Transaction Sql language for SQL Server. http://msdn.microsoft.com/en-us/library/ms189826(SQL.90).aspx

iSql appears to be an old Microsoft utility that allows you to run SQL statements against SQL Server. http://msdn.microsoft.com/en-us/library/aa214007(SQL.80).aspx

Answer 2

isql is an old CLI tool that I believe Microsoft has deprecated. It looks like from this webpage that tsql is a Linux CLI tool for querying databases and doing diagnostics.

Answer 3

SQL Server applications must be using T-SQL statements to communicate with the server, but how your T-SQL is written and run can ultimately impact your server performance.

isql defines the order of the date format as month, date, and year (mm dd yyyy hh:mmAM (or PM)) regardless of the locale environment. To change this default order, use the convert function. isql [-b] [-e] [-F] [-p] [-n] [-v] [-X] [-Y] [-Q]