Skip to content

Unsupported Functionality

Sql Quantum Leap edited this page Dec 11, 2015 · 2 revisions

The options listed below won't ever be supported in SimpleSqlExec due to being either irrelevant for a command line tool that makes a single connection, or being contrary to the stated design goal of this project. To that end, features such as support for Multiple Active Result Sets (MARS) or Connection Pooling would be useless. And features such as interactive querying and output formatting for reporting purposes.

SQLCMD options that will not be implemented:

  • -I to turn on QUOTED_IDENTIFIER
  • -q "cmdline query"
  • -L[c] list local servers
  • -z "new_password"
  • -Z "new_password"
  • -k [1 | 2]
  • -R localize numeric, currency, date, and time columns based on the client’s locale
  • -w column_width
  • -W
  • -y variable_length_type_display_width
  • -Y fixed_length_type_display_width

Connection String keywords that will not be implemented:

  • Asynchronous Processing / Async
  • Context Connection
  • MultipleActiveResultSets
  • Persist Security Info / PersistSecurityInfo
  • Connection Lifetime (or Load Balance Timeout)
  • Max Pool Size
  • Min Pool Size
  • Pooling
  • Transaction Binding
Clone this wiki locally