jeremyevans/sequel — pull request #792 by d4rk5eed (2014-04-06 10:42:02+00:00)
Title: Named params support for stored procedures of mssql adapter

Since mssql supports named params for stored procedures ([examine details here](http://technet.microsoft.com/en-us/library/ms177436(v=sql.105).aspx)),
I propose commits for mssql adapter.
So method call like:
```ruby
DB.call_mssql_sproc(:SequelTest, {:args => [
[1, 'first'],
[2, 'second'],
[:output, 'int', ['result_varname', 'output_arg_name']]
]})
```
will generate mssql query like this:
```sql
Desclare @var1 int; @RC int;
Execute SequelTest @first=1, @second=2, @output_arg_name=@var1;
Select @RC AS RESULT, @@ROWCOUNT AS NUMROWS, @var as [result_varname];
```
where result_varname is key in result hash.

I perceive that it's ugly and hash is more appropriate but it'is made for backward compatibility with current way.
Also tests for this behavior is provided, test for unnamed params are isolated in 'with unnamed parameters' context, and test for named ones are in 'with named parameters' respectively.