1

Closed

Add a 'query' Command for .sql scripts

description

I would like to be able to run .sql scripts from wsubi by simply saying something like this:

[~wsubi:] query MyScript.sql [params]

A 'query' should be able to do the following:
  • Return a single value as a result (prints to console or file)
  • Return a row as a result (prints to console or file)
  • Return a set of rows as a result (outputs to a file)
  • Run a script without getting data back (except maybe pass / fail result of executing it)
User will need to specify some parameters of their command that are different from other wsubi commands, specifically:
  • Connection String
  • Query type (Value, Row, RowSet, NonQuery)
Closed Feb 5, 2014 at 1:33 AM by bryanoconnell

comments

bryanoconnell wrote May 8, 2013 at 1:31 AM

This enhancement will be part of version 1.6.