lsp-mode mssql client#
lsp-treemacs clone the repo and add the
following lines in your config:
(add-to-load-path ".../lsp-mssql/") (require 'lsp-mssql) (add-hook 'sql-mode-hook 'lsp)
Confgure the connections.
(setq lsp-mssql-connections [(:server "localhost" :database "" :user "SA" :password "demoPWD2")])
*.sql file and do
M-x lsp. On the first run, it will ask you
whether to install the language server. Then when you are in the
M-x lsp-mssql-connect which will ask you to select
connection. After the connection is established the current buffer will
be associated with the SQL Server and the completion and the query
exection will be performed against that server.
lsp-mssql-connect- connect the editor to
lsp-mssql-disconnect- disconnect the editor
lsp-mssql-execute-buffer- execute current buffer
lsp-mssql-execute-region- execute selected region.
- MSSQL Object Explorer
MSSQLobject explorer to the right.
lsp-mssql-object-explorer-connect- connect the connection under point. Bound to
Cin the object explorer.
lsp-mssql-object-explorer-refresh- refresh the node. Bound to
Rin the object explorer.
Run mssql in docker#
docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=demoPWD2" \ -p 1433:1433 --name sql1 \ -d mcr.microsoft.com/mssql/server:2019-GA-ubuntu-16.04
snippets directory contains the snippets from
(add-to-list 'yas-snippets-dir "path to stippets dir.")
- Implement disconnect.
- Implement cancel query
- Provide options to customize the output