ADO中sqlserver存储过程使用

---

从ADO中得到多个记录集以及怎么样在ADO中使用sql server 的存储过程

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)



 SELECT 'TINYINT'          , @myTinyint        , LEN(@myTinyint)                      , DATALENGTH(@myTinyint)



 SELECT 'BIT'              , @myBit            , LEN(@myBit)                          , DATALENGTH(@myBit)



 SELECT 'DECIMAL'          , @myDecimal        , LEN(@myDecimal)                      , DATALENGTH(@myDecimal)



 SELECT 'NUMERIC'          , @myNumeric        , LEN(@myNumeric)                      , DATALENGTH(@myNumeric)



 SELECT 'MONEY'            , @myMoney          , LEN(CAST(@mySmallMoney as varchar))  , DATALENGTH(@myMoney)



 SELECT 'SMALLMONEY'       , @mySmallMoney     , LEN(CAST(@mySmallMoney as varchar))  , DATALENGTH(@mySmallMoney)



 SELECT 'FLOAT'            , @myFloat          , LEN(@myFloat)                        , DATALENGTH(@myFloat)



 SELECT 'REAL'             , @myReal           , LEN(@myReal)                         , DATALENGTH(@myReal)



 SELECT 'DATETIME'         , @myDatetime       , LEN(@myDatetime)                     , DATALENGTH(@myDatetime)



 SELECT 'SMALLDATETIME'    , @mySmallDatetime  , LEN(@mySmallDatetime)                , DATALENGTH(@mySmallDatetime)



 SELECT 'CHAR'             , @myChar           , LEN(@myChar)                         , DATALENGTH(@myChar)



 SELECT 'VARCHAR'          , @myVarchar        , LEN(@myVarchar)                      , DATALENGTH(@myVarchar)



 SELECT 'TEXT'             , ''                , ''                                   , DATALENGTH(@myText)



 SELECT 'NCHAR'            , @myNChar          , LEN(@myNChar)                        , DATALENGTH(@myNChar)



 SELECT 'NVARCHAR'         , @myNVarchar       , LEN(@myNVarchar)                     , DATALENGTH(@myNVarchar)



 SELECT 'NTEXT'            , ''                , ''                                   , DATALENGTH(@myNText)



 SELECT 'GUID'             , @myGuid           , LEN(@myGuid)                         , DATALENGTH(@myGuid)



 



 -- TODO:  READTEXT should do this...



 /*



     , @myText "text"



     , @myNText "ntext"



 */



 



 RETURN(0)



 



 



 

Code: 本文作者:

---

« 
» 

---