MS SQL Server Support

[jobe451]

I got SQLTools working with MS SQL Server, here is the definition I use. Maybe this could be added.

CLI-Definition:

    "cli" : {
        "mssql"   : "sqlcmd"
    },

Calling sqlcmd definition:

        "mssql": {
            "options": [],
            "before": [],
            "args": "-S \"{host}, {port}\" -U \"{username}\" -P \"{password}\" -d\"{database}\"",
            "queries": {
                "desc" : {
                    "query": "Select '| ' + Table_name + ' |' as tablenames From Information_schema.Tables Where Table_type = 'BASE TABLE' and Objectproperty (Object_id(Table_name), 'IsMsShipped') = 0",
                    "options": [],
                    "format" : "|%s|"
                },
                "desc table": {
                    "query": "SELECT ORDINAL_POSITION, cast(left(COLUMN_NAME,40) as varchar(40)) as COLUMN_NAME, cast(left(DATA_TYPE,20) as varchar(20)) as DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, IS_NULLABLE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '%s'",
                    "options": [],
                    "format" : "|%s|"
                },
                "show records": {
                    "query": "select top 100 * from {0}",
                    "options": [],
                    "format" : "|%s|"
                }
            }
        },   

[llsousa]

"args": "-S \"{host}, {port}\" -U \"{username}\" -P \"{password}\" -d\"{database}\"",

@mtxr , in case the authentication is done by AD, there's no need to set username and password. Is there a way to define them as optional?
Or, the code that calls the command test first if the parameters are null and in case they are, don't consider them?

[mtxr]

@llsousa sure. You can set it on your user settings by removing "username" and "password" params.

@jobe451 what was the error before these changes?

[jobe451]

@mtxr: There was no definition for MSSQL, the definition above adds that.

[mkormendy]

The settings definitions above do not work with:
https://blogs.technet.microsoft.com/dataplatforminsider/2017/04/03/sql-server-command-line-tools-for-mac-preview-now-available/