Differences between revisions 1 and 2

freetds

FreeTDS is a set of libraries for Unix and Linux that allows your programs to natively talk to Microsoft SQL Server and Sybase databases.

Query MSSQL with tsql command

TDSVER=7.0 tsql -H 192.168.1.123 -U userx -P 12345678 -p 1433

Show databases:

   1 select name from master..sysdatabases;
   2 go

Show tables:

   1 SELECT * FROM information_schema.tables;
   2 go

-  ⇤ ← Revision 1 as of 2013-09-11 15:12:37 → 
  Size: 428
  Editor: bl13-8-218
  Comment:
+   ← Revision 2 as of 2013-11-06 21:39:21 → ⇥
  Size: 429
  Editor: 31
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 5:
-TDSVER=7.0 tsql -H 192.168.1.123 -U userx -P 12345678-p 1433
+TDSVER=7.0 tsql -H 192.168.1.123 -U userx -P 12345678 -p 1433