SQL Server stored procedures in ADO use

How to get more than one recordset from ADO and how to use SQL Server stored procedures in ADO
DataType
Value
Length
Data Length
BIGINT
996857543543543
15
8
Int
543543
6
4
SMALLINT
32765
5
2
TINYINT
254
3
1
BIT
True
1
1
DECIMAL
765.5432321
11
9
NUMERIC
432.6544
8
5
Money
543.1234
6
8
SmallMoney
543.1234
6
4
FLOAT
5.4E+54
8
8
Real
2.43E+24
9
4
Datetime
8/31/2003 11:55:25 PM
19
8
smalldatetime
8/31/2003 11:55:00 PM
19
4
CHAR
Qwe
3
4
VARCHAR
variable!
9
9
TEXT


307
NCHAR
WIDE
4
8
NVARCHAR

0
0
NTEXT


614
Guid
{58F94A80-B839-4B35-B73C-7F4B4D336C3C}
36
16
Return value:0
CREATE PROCEDURE "dbo". " Datatypetester "
@myBigInt bigint
, @myInt int
, @mySmallint smallint
, @myTinyint tinyint
, @myBit bit
, @myDecimal decimal (10, 7)
, @myNumeric Numeric (7, 4)
, @myMoney Money
, @mySmallMoney smallmoney
, @myFloat float
, @myReal Real
, @myDatetime datetime
, @mySmallDatetime smalldatetime
, @myChar char (4)
, @myVarchar varchar (10)
, @myText text
, @myNChar nchar (4)
, @myNVarchar nvarchar (10)
, @myNText ntext
, @myGuid uniqueidentifier
As

SELECT ' BIGINT ' "DataType", @myBigInt "Value", LEN (@myBigInt) "Length", Datalength (@myBigInt) "Data Length"
SELECT ' INT ', @myInt, LEN (@myInt), datalength (@myInt)
SELECT ' SMALLINT ', @mySmallint, LEN (@mySmallint), datalength (@mySmallint)