From: Alexander Tretjakov <alex@...>
Date: 2008-03-14T22:38:38+09:00
Subject: MSSQL 2005 Stored Procedure?

I want to programmig in Ruby... but have some problems.

1. Can anyone help me with the syntax for retriving an 'out'
variable from an MSSQL2005 Stored Procedure?


2. Can anyone help me with the syntax for retriving 3 recordset
from an MSSQL2005 Stored Procedure?

Example code TSQL
create procedure us_test @coden int out
as
select * from table1
select *,0 as id from table2
select 0,'ffff' as namefield from table3
select @coden=@coden+100
GO
declare @i int
select @i=1
exec us_test @i out
select @i

We return 3 recordset and @i=101

I want to run us_test from Ruby (on Windows system).
-- 
Posted via http://www.ruby-forum.com/.