Safe Haskell | Safe-Inferred |
---|---|
Language | Haskell2010 |
Synopsis
- sql :: ResultSet a => Connection -> Text -> IO a
- class ResultSet a where
- resultSetParser :: Parser' a
- class Result a where
- resultParser :: Bool -> Parser' a
- class Row a where
- fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> a
- newtype Only a = Only {
- fromOnly :: a
- newtype RowCount = RowCount Int
- newtype ReturnStatus = ReturnStatus Int
- rpc :: (RpcQuerySet a, RpcResponseSet b) => Connection -> a -> IO b
- class RpcResponseSet a where
- data RpcResponse a b
- = RpcResponse !Int !a !b
- | RpcResponseError !Info
- class RpcOutputSet a where
- fromReturnValues :: [ReturnValue] -> a
- class RpcResultSet a where
- class RpcResult a where
- rpcResultParser :: Parser' a
- class RpcQuerySet a where
- toRpcRequest :: a -> RpcRequest
- data RpcQuery a b = RpcQuery !a !b
- class RpcQueryId a where
- toRpcReqBatch :: RpcParamSet b => a -> b -> RpcReqBatch
- data StoredProcedure
- class RpcParamSet a where
- toRpcReqBatchParams :: a -> [RpcReqBatchParam]
- data RpcParam a
- = RpcParamVal !RpcParamName !TypeInfo !a
- | RpcParamRef !RpcParamName !TypeInfo !a
- | RpcParamDefVal !RpcParamName !TypeInfo !a
- | RpcParamDefRef !RpcParamName !TypeInfo !a
- type RpcParamName = Text
- bitVal :: Integral a => RpcParamName -> Maybe a -> RpcParam (Maybe a)
- tinyintVal :: Integral a => RpcParamName -> Maybe a -> RpcParam (Maybe a)
- smallintVal :: Integral a => RpcParamName -> Maybe a -> RpcParam (Maybe a)
- intVal :: Integral a => RpcParamName -> Maybe a -> RpcParam (Maybe a)
- bigintVal :: Integral a => RpcParamName -> Maybe a -> RpcParam (Maybe a)
- smallmoneyVal :: RpcParamName -> Maybe Money -> RpcParam (Maybe Money)
- moneyVal :: RpcParamName -> Maybe Money -> RpcParam (Maybe Money)
- smalldatetimeVal :: RpcParamName -> Maybe UTCTime -> RpcParam (Maybe UTCTime)
- datetimeVal :: RpcParamName -> Maybe UTCTime -> RpcParam (Maybe UTCTime)
- float24Val :: Fractional a => RpcParamName -> Maybe a -> RpcParam (Maybe a)
- realVal :: Fractional a => RpcParamName -> Maybe a -> RpcParam (Maybe a)
- float53Val :: Fractional a => RpcParamName -> Maybe a -> RpcParam (Maybe a)
- doubleVal :: Fractional a => RpcParamName -> Maybe a -> RpcParam (Maybe a)
- uniqueidentifierVal :: RpcParamName -> Maybe UUID -> RpcParam (Maybe UUID)
- decimalVal :: HasResolution a => RpcParamName -> Precision -> Either Scale (Fixed a) -> RpcParam (Maybe (Fixed a))
- numericVal :: HasResolution a => RpcParamName -> Precision -> Either Scale (Fixed a) -> RpcParam (Maybe (Fixed a))
- charVal :: RpcParamName -> Maybe ByteString -> RpcParam (Maybe ByteString)
- varcharVal :: RpcParamName -> Maybe ByteString -> RpcParam (Maybe ByteString)
- textVal :: RpcParamName -> Maybe ByteString -> RpcParam (Maybe ByteString)
- ncharVal :: RpcParamName -> Maybe Text -> RpcParam (Maybe Text)
- nvarcharVal :: RpcParamName -> Maybe Text -> RpcParam (Maybe Text)
- ntextVal :: RpcParamName -> Maybe Text -> RpcParam (Maybe Text)
- binaryVal :: RpcParamName -> Maybe ByteString -> RpcParam (Maybe ByteString)
- varbinaryVal :: RpcParamName -> Maybe ByteString -> RpcParam (Maybe ByteString)
- imageVal :: RpcParamName -> Maybe ByteString -> RpcParam (Maybe ByteString)
- bitRef :: Integral a => RpcParamName -> Maybe a -> RpcParam (Maybe a)
- tinyintRef :: Integral a => RpcParamName -> Maybe a -> RpcParam (Maybe a)
- smallintRef :: Integral a => RpcParamName -> Maybe a -> RpcParam (Maybe a)
- intRef :: Integral a => RpcParamName -> Maybe a -> RpcParam (Maybe a)
- bigintRef :: Integral a => RpcParamName -> Maybe a -> RpcParam (Maybe a)
- smallmoneyRef :: RpcParamName -> Maybe Money -> RpcParam (Maybe Money)
- moneyRef :: RpcParamName -> Maybe Money -> RpcParam (Maybe Money)
- smalldatetimeRef :: RpcParamName -> Maybe UTCTime -> RpcParam (Maybe UTCTime)
- datetimeRef :: RpcParamName -> Maybe UTCTime -> RpcParam (Maybe UTCTime)
- float24Ref :: Fractional a => RpcParamName -> Maybe a -> RpcParam (Maybe a)
- realRef :: Fractional a => RpcParamName -> Maybe a -> RpcParam (Maybe a)
- float53Ref :: Fractional a => RpcParamName -> Maybe a -> RpcParam (Maybe a)
- doubleRef :: Fractional a => RpcParamName -> Maybe a -> RpcParam (Maybe a)
- uniqueidentifierRef :: RpcParamName -> Maybe UUID -> RpcParam (Maybe UUID)
- decimalRef :: HasResolution a => RpcParamName -> Precision -> Either Scale (Fixed a) -> RpcParam (Maybe (Fixed a))
- numericRef :: HasResolution a => RpcParamName -> Precision -> Either Scale (Fixed a) -> RpcParam (Maybe (Fixed a))
- charRef :: RpcParamName -> Int -> Maybe ByteString -> RpcParam (Maybe ByteString)
- varcharRef :: RpcParamName -> Int -> Maybe ByteString -> RpcParam (Maybe ByteString)
- textRef :: RpcParamName -> Int -> Maybe ByteString -> RpcParam (Maybe ByteString)
- ncharRef :: RpcParamName -> Int -> Maybe Text -> RpcParam (Maybe Text)
- nvarcharRef :: RpcParamName -> Int -> Maybe Text -> RpcParam (Maybe Text)
- ntextRef :: RpcParamName -> Int -> Maybe Text -> RpcParam (Maybe Text)
- binaryRef :: RpcParamName -> Int -> Maybe ByteString -> RpcParam (Maybe ByteString)
- varbinaryRef :: RpcParamName -> Int -> Maybe ByteString -> RpcParam (Maybe ByteString)
- imageRef :: RpcParamName -> Int -> Maybe ByteString -> RpcParam (Maybe ByteString)
- bitDefRef :: Integral a => RpcParamName -> RpcParam (Maybe a)
- tinyintDefRef :: Integral a => RpcParamName -> RpcParam (Maybe a)
- smallintDefRef :: Integral a => RpcParamName -> RpcParam (Maybe a)
- intDefRef :: Integral a => RpcParamName -> RpcParam (Maybe a)
- bigintDefRef :: Integral a => RpcParamName -> RpcParam (Maybe a)
- smallmoneyDefRef :: RpcParamName -> RpcParam (Maybe Money)
- moneyDefRef :: RpcParamName -> RpcParam (Maybe Money)
- smalldatetimeDefRef :: RpcParamName -> RpcParam (Maybe UTCTime)
- datetimeDefRef :: RpcParamName -> RpcParam (Maybe UTCTime)
- float24DefRef :: Fractional a => RpcParamName -> RpcParam (Maybe a)
- realDefRef :: Fractional a => RpcParamName -> RpcParam (Maybe a)
- float53DefRef :: Fractional a => RpcParamName -> RpcParam (Maybe a)
- doubleDefRef :: Fractional a => RpcParamName -> RpcParam (Maybe a)
- uniqueidentifierDefRef :: RpcParamName -> RpcParam (Maybe UUID)
- decimalDefRef :: HasResolution a => RpcParamName -> Precision -> Scale -> RpcParam (Maybe (Fixed a))
- numericDefRef :: HasResolution a => RpcParamName -> Precision -> Scale -> RpcParam (Maybe (Fixed a))
- charDefRef :: RpcParamName -> Int -> RpcParam (Maybe ByteString)
- varcharDefRef :: RpcParamName -> Int -> RpcParam (Maybe ByteString)
- textDefRef :: RpcParamName -> Int -> RpcParam (Maybe ByteString)
- ncharDefRef :: RpcParamName -> Int -> RpcParam (Maybe Text)
- nvarcharDefRef :: RpcParamName -> Int -> RpcParam (Maybe Text)
- ntextDefRef :: RpcParamName -> Int -> RpcParam (Maybe Text)
- binaryDefRef :: RpcParamName -> Int -> RpcParam (Maybe ByteString)
- varbinaryDefRef :: RpcParamName -> Int -> RpcParam (Maybe ByteString)
- imageDefRef :: RpcParamName -> Int -> RpcParam (Maybe ByteString)
- withTransaction :: Connection -> IO a -> IO a
- data QueryError = QueryError !Info
SQL Text Query
A sql
function accepts valid Connection
and SQL text.
And the expression could be evaluated as a instance of ResultSet
type class.
A Row
represents a record included in a query result.
Also list of Row
is a instance of ResultSet
.
So the result of select query could be obtained as follows.
{-# LANGUAGE OverloadedStrings #-} import Database.MSSQLServer.Connection import Database.MSSQLServer.Query sql_select1 :: Connection -> IO Int sql_select1 conn = do [Only i] <- sql conn "SELECT 2 + 2" :: IO [Only Int] return i
In SQL , uncomputable expression could be evaluated as NULL.
In that case, Maybe
type could be used.
sql_select2 :: Connection -> IO (Maybe Int) sql_select2 conn = do [Only mi] <- sql conn "SELECT 6 / 2" :: IO [Only (Maybe Int)] return mi
sql_select3 :: Connection -> IO (Maybe Int) sql_select3 conn = do [Only mi] <- sql conn "SELECT 6 / 0" :: IO [Only (Maybe Int)] return mi
The result of select query from SQL table could be obtained as follows.
A member of tuple must be a instance of Data
type class
and convertible with the SQL data type of a SQL table column.
{-# LANGUAGE OverloadedStrings #-} import Database.MSSQLServer.Connection import Database.MSSQLServer.Query import qualified Data.Text.Lazy as LT import Database.Tds.Message import Data.Time (UTCTime(..)) sql_select4 :: Connection -> IO [(Int,String,LT.Text,Money,UTCTime,Maybe UTCTime,Maybe UTCTime)] sql_select4 conn = sql conn "SELECT * FROM TSome ORDER BY somePrice"
Any type could be a instance of Row
and used as the result of select query as follows.
{-# LANGUAGE BangPatterns #-} data Some = Some { someID :: Int , someTitle :: LT.Text , someContent :: LT.Text , somePrice :: Money , someCreated:: UTCTime , someModified:: Maybe UTCTime , someDeleted:: Maybe UTCTime } deriving (Show) instance Row Some where fromListOfRawBytes [m1,m2,m3,m4,m5,m6,m7] [b1,b2,b3,b4,b5,b6,b7] = Some d1 d2 d3 d4 d5 d6 d7 where !d1 = fromRawBytes (mcdTypeInfo m1) b1 !d2 = fromRawBytes (mcdTypeInfo m2) b2 !d3 = fromRawBytes (mcdTypeInfo m3) b3 !d4 = fromRawBytes (mcdTypeInfo m4) b4 !d5 = fromRawBytes (mcdTypeInfo m5) b5 !d6 = fromRawBytes (mcdTypeInfo m6) b6 !d7 = fromRawBytes (mcdTypeInfo m7) b7 mcdTypeInfo :: MetaColumnData -> TypeInfo mcdTypeInfo (MetaColumnData _ _ ti _ _) = ti fromListOfRawBytes _ _ = error "fromListOfRawBytes: List length must be 7" sql_select5 :: Connection -> IO [Some] sql_select5 conn = sql conn "SELECT TOP 10 * FROM TSome ORDER BY somePrice DESC"
Row
is also a instance of Result
and tuple of Result
is a instance of ResultSet
.
So the result of multiple SQL query could be obtained simultaneously as follows.
import Data.Monoid (mconcat) sql_select6 :: Connection -> IO ([Some],[Some]) sql_select6 conn = sql conn $ mconcat ["SELECT * FROM TSome WHERE someID < 8 ORDER BY someID;", "SELECT * FROM TSome WHERE 8 <= someID AND someID < 12 ORDER BY someID DESC;"]
RowCount
is a instance of ResultSet
.
So the count of SQL table record affected with the SQL query could be obtained as follows.
{-# LANGUAGE OverloadedStrings #-} import Database.MSSQLServer.Connection import Database.MSSQLServer.Query sql_count1 :: Connection -> IO Int sql_count1 conn = do RowCount rc <- sql conn "UPDATE TSome SET somePrice = somePrice + 100 WHERE someID < 5" return rc
Also () is a instance of ResultSet
.
So the result of SQL query could be discarded as follows.
{-# LANGUAGE OverloadedStrings #-} import Database.MSSQLServer.Connection import Database.MSSQLServer.Query sql_discard1 :: Connection -> IO () sql_discard1 conn = sql conn "UPDATE TSome SET somePrice = somePrice + 100 WHERE someID < 5"
Even DROP/CREATE TABLE statement could be executed as follows when your account has privileges.
{-# LANGUAGE OverloadedStrings #-} {-# LANGUAGE QuasiQuotes #-} import Database.MSSQLServer.Connection import Database.MSSQLServer.Query import Text.RawString.QQ (r) sql_create_table1 :: Connection -> IO () sql_create_table1 conn = do sql conn "DROP TABLE TSome" :: IO () sql conn [r| CREATE TABLE TSome ( someID int IDENTITY(1,1) NOT NULL, someTitle nvarchar(40) NOT NULL, someContent ntext NOT NULL, somePrice money NOT NULL, someCreated datetime NOT NULL, someModified datetime NULL, someDeleted datetime NULL, CONSTRAINT PK_TSome PRIMARY KEY CLUSTERED ( someID ASC ) WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] |]
INSERT batch could be executed within transaction as follows.
sql_insert1 :: Connection -> IO () sql_insert1 conn = sql conn [r| BEGIN TRAN; INSERT INTO TSome(someTitle,someContent,somePrice,someCreated) VALUES('title','content',12345.60,GETDATE()); INSERT INTO TSome(someTitle,someContent,somePrice,someCreated) VALUES('title','content',12345.60,GETDATE()); INSERT INTO TSome(someTitle,someContent,somePrice,someCreated) VALUES('title','content',12345.60,GETDATE()); INSERT INTO TSome(someTitle,someContent,somePrice,someCreated) VALUES('title','content',12345.60,GETDATE()); COMMIT TRAN; |]
ReturnStatus
is a instance of ResultSet
.
So when a stored procedure executed in SQL text, Return status of the execution could be obtained as follows.
{-# LANGUAGE OverloadedStrings #-} import Database.MSSQLServer.Connection import Database.MSSQLServer.Query sql_status1 :: Connection -> IO Int sql_status1 conn = do ReturnStatus rets <- sql conn "EXEC SP_Input1 @Val1=3" return rets
ResultSet
class ResultSet a where Source #
resultSetParser :: Parser' a Source #
Instances
ResultSet ReturnStatus Source # | |
ResultSet RowCount Source # | |
Defined in Database.MSSQLServer.Query.ResultSet | |
ResultSet () Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' () Source # | |
Row a => ResultSet [a] Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' [a] Source # | |
(Result a1, Result a2) => ResultSet (a1, a2) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2) Source # | |
(Result a1, Result a2, Result a3) => ResultSet (a1, a2, a3) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3) Source # | |
(Result a1, Result a2, Result a3, Result a4) => ResultSet (a1, a2, a3, a4) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3, a4) Source # | |
(Result a1, Result a2, Result a3, Result a4, Result a5) => ResultSet (a1, a2, a3, a4, a5) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3, a4, a5) Source # | |
(Result a1, Result a2, Result a3, Result a4, Result a5, Result a6) => ResultSet (a1, a2, a3, a4, a5, a6) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3, a4, a5, a6) Source # | |
(Result a1, Result a2, Result a3, Result a4, Result a5, Result a6, Result a7) => ResultSet (a1, a2, a3, a4, a5, a6, a7) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7) Source # | |
(Result a1, Result a2, Result a3, Result a4, Result a5, Result a6, Result a7, Result a8) => ResultSet (a1, a2, a3, a4, a5, a6, a7, a8) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8) Source # | |
(Result a1, Result a2, Result a3, Result a4, Result a5, Result a6, Result a7, Result a8, Result a9) => ResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9) Source # | |
(Result a1, Result a2, Result a3, Result a4, Result a5, Result a6, Result a7, Result a8, Result a9, Result a10) => ResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10) Source # | |
(Result a1, Result a2, Result a3, Result a4, Result a5, Result a6, Result a7, Result a8, Result a9, Result a10, Result a11) => ResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11) Source # | |
(Result a1, Result a2, Result a3, Result a4, Result a5, Result a6, Result a7, Result a8, Result a9, Result a10, Result a11, Result a12) => ResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12) Source # | |
(Result a1, Result a2, Result a3, Result a4, Result a5, Result a6, Result a7, Result a8, Result a9, Result a10, Result a11, Result a12, Result a13) => ResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13) Source # | |
(Result a1, Result a2, Result a3, Result a4, Result a5, Result a6, Result a7, Result a8, Result a9, Result a10, Result a11, Result a12, Result a13, Result a14) => ResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14) Source # | |
(Result a1, Result a2, Result a3, Result a4, Result a5, Result a6, Result a7, Result a8, Result a9, Result a10, Result a11, Result a12, Result a13, Result a14, Result a15) => ResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15) Source # | |
(Result a1, Result a2, Result a3, Result a4, Result a5, Result a6, Result a7, Result a8, Result a9, Result a10, Result a11, Result a12, Result a13, Result a14, Result a15, Result a16) => ResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16) Source # | |
(Result a1, Result a2, Result a3, Result a4, Result a5, Result a6, Result a7, Result a8, Result a9, Result a10, Result a11, Result a12, Result a13, Result a14, Result a15, Result a16, Result a17) => ResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17) Source # | |
(Result a1, Result a2, Result a3, Result a4, Result a5, Result a6, Result a7, Result a8, Result a9, Result a10, Result a11, Result a12, Result a13, Result a14, Result a15, Result a16, Result a17, Result a18) => ResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18) Source # | |
(Result a1, Result a2, Result a3, Result a4, Result a5, Result a6, Result a7, Result a8, Result a9, Result a10, Result a11, Result a12, Result a13, Result a14, Result a15, Result a16, Result a17, Result a18, Result a19) => ResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19) Source # | |
(Result a1, Result a2, Result a3, Result a4, Result a5, Result a6, Result a7, Result a8, Result a9, Result a10, Result a11, Result a12, Result a13, Result a14, Result a15, Result a16, Result a17, Result a18, Result a19, Result a20) => ResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20) Source # | |
(Result a1, Result a2, Result a3, Result a4, Result a5, Result a6, Result a7, Result a8, Result a9, Result a10, Result a11, Result a12, Result a13, Result a14, Result a15, Result a16, Result a17, Result a18, Result a19, Result a20, Result a21) => ResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21) Source # | |
(Result a1, Result a2, Result a3, Result a4, Result a5, Result a6, Result a7, Result a8, Result a9, Result a10, Result a11, Result a12, Result a13, Result a14, Result a15, Result a16, Result a17, Result a18, Result a19, Result a20, Result a21, Result a22) => ResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22) Source # | |
(Result a1, Result a2, Result a3, Result a4, Result a5, Result a6, Result a7, Result a8, Result a9, Result a10, Result a11, Result a12, Result a13, Result a14, Result a15, Result a16, Result a17, Result a18, Result a19, Result a20, Result a21, Result a22, Result a23) => ResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23) Source # | |
(Result a1, Result a2, Result a3, Result a4, Result a5, Result a6, Result a7, Result a8, Result a9, Result a10, Result a11, Result a12, Result a13, Result a14, Result a15, Result a16, Result a17, Result a18, Result a19, Result a20, Result a21, Result a22, Result a23, Result a24) => ResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24) Source # | |
(Result a1, Result a2, Result a3, Result a4, Result a5, Result a6, Result a7, Result a8, Result a9, Result a10, Result a11, Result a12, Result a13, Result a14, Result a15, Result a16, Result a17, Result a18, Result a19, Result a20, Result a21, Result a22, Result a23, Result a24, Result a25) => ResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25) Source # | |
(Result a1, Result a2, Result a3, Result a4, Result a5, Result a6, Result a7, Result a8, Result a9, Result a10, Result a11, Result a12, Result a13, Result a14, Result a15, Result a16, Result a17, Result a18, Result a19, Result a20, Result a21, Result a22, Result a23, Result a24, Result a25, Result a26) => ResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26) Source # | |
(Result a1, Result a2, Result a3, Result a4, Result a5, Result a6, Result a7, Result a8, Result a9, Result a10, Result a11, Result a12, Result a13, Result a14, Result a15, Result a16, Result a17, Result a18, Result a19, Result a20, Result a21, Result a22, Result a23, Result a24, Result a25, Result a26, Result a27) => ResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27) Source # | |
(Result a1, Result a2, Result a3, Result a4, Result a5, Result a6, Result a7, Result a8, Result a9, Result a10, Result a11, Result a12, Result a13, Result a14, Result a15, Result a16, Result a17, Result a18, Result a19, Result a20, Result a21, Result a22, Result a23, Result a24, Result a25, Result a26, Result a27, Result a28) => ResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27, a28) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27, a28) Source # | |
(Result a1, Result a2, Result a3, Result a4, Result a5, Result a6, Result a7, Result a8, Result a9, Result a10, Result a11, Result a12, Result a13, Result a14, Result a15, Result a16, Result a17, Result a18, Result a19, Result a20, Result a21, Result a22, Result a23, Result a24, Result a25, Result a26, Result a27, Result a28, Result a29) => ResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27, a28, a29) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27, a28, a29) Source # | |
(Result a1, Result a2, Result a3, Result a4, Result a5, Result a6, Result a7, Result a8, Result a9, Result a10, Result a11, Result a12, Result a13, Result a14, Result a15, Result a16, Result a17, Result a18, Result a19, Result a20, Result a21, Result a22, Result a23, Result a24, Result a25, Result a26, Result a27, Result a28, Result a29, Result a30) => ResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27, a28, a29, a30) Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27, a28, a29, a30) Source # |
resultParser :: Bool -> Parser' a Source #
Instances
Result ReturnStatus Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultParser :: Bool -> Parser' ReturnStatus Source # | |
Result RowCount Source # | |
Defined in Database.MSSQLServer.Query.ResultSet | |
Result () Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultParser :: Bool -> Parser' () Source # | |
Row a => Result [a] Source # | |
Defined in Database.MSSQLServer.Query.ResultSet resultParser :: Bool -> Parser' [a] Source # |
fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> a Source #
Instances
Data a => Row (Only a) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> Only a Source # | |
(Data a1, Data a2) => Row (a1, a2) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2) Source # | |
(Data a1, Data a2, Data a3) => Row (a1, a2, a3) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3) Source # | |
(Data a1, Data a2, Data a3, Data a4) => Row (a1, a2, a3, a4) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3, a4) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5) => Row (a1, a2, a3, a4, a5) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3, a4, a5) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6) => Row (a1, a2, a3, a4, a5, a6) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3, a4, a5, a6) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7) => Row (a1, a2, a3, a4, a5, a6, a7) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3, a4, a5, a6, a7) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8) => Row (a1, a2, a3, a4, a5, a6, a7, a8) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3, a4, a5, a6, a7, a8) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9) => Row (a1, a2, a3, a4, a5, a6, a7, a8, a9) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10) => Row (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11) => Row (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12) => Row (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13) => Row (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14) => Row (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15) => Row (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16) => Row (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17) => Row (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17, Data a18) => Row (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17, Data a18, Data a19) => Row (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17, Data a18, Data a19, Data a20) => Row (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17, Data a18, Data a19, Data a20, Data a21) => Row (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17, Data a18, Data a19, Data a20, Data a21, Data a22) => Row (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17, Data a18, Data a19, Data a20, Data a21, Data a22, Data a23) => Row (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17, Data a18, Data a19, Data a20, Data a21, Data a22, Data a23, Data a24) => Row (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17, Data a18, Data a19, Data a20, Data a21, Data a22, Data a23, Data a24, Data a25) => Row (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17, Data a18, Data a19, Data a20, Data a21, Data a22, Data a23, Data a24, Data a25, Data a26) => Row (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17, Data a18, Data a19, Data a20, Data a21, Data a22, Data a23, Data a24, Data a25, Data a26, Data a27) => Row (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17, Data a18, Data a19, Data a20, Data a21, Data a22, Data a23, Data a24, Data a25, Data a26, Data a27, Data a28) => Row (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27, a28) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27, a28) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17, Data a18, Data a19, Data a20, Data a21, Data a22, Data a23, Data a24, Data a25, Data a26, Data a27, Data a28, Data a29) => Row (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27, a28, a29) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27, a28, a29) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17, Data a18, Data a19, Data a20, Data a21, Data a22, Data a23, Data a24, Data a25, Data a26, Data a27, Data a28, Data a29, Data a30) => Row (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27, a28, a29, a30) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27, a28, a29, a30) Source # |
Instances
Show a => Show (Only a) Source # | |
Data a => Row (Only a) Source # | |
Defined in Database.MSSQLServer.Query.Row fromListOfRawBytes :: [MetaColumnData] -> [RawBytes] -> Only a Source # | |
Data a => RpcOutputSet (Only a) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> Only a Source # |
newtype ReturnStatus Source #
Instances
RPC Query
Stored procedure RPC could be executed as follows.
{-# LANGUAGE OverloadedStrings #-} import Database.MSSQLServer.Connection import Database.MSSQLServer.Query import qualified Data.Text as T import Data.Word (Word16) rpc_sql_select1 :: Connection -> IO (RpcResponse () [Some]) rpc_sql_select1 conn = rpc conn $ RpcQuery ("sp_executesql"::T.Text) $ nvarcharVal "" (Just "SELECT * FROM TSome")
There several ways provided for specify stored procedures. See ProcID section of \[MS-TDS\] 2.2.6.6 RPC Request.
rpc_sql_select2 :: Connection -> Int -> IO (RpcResponse () [Some]) rpc_sql_select2 conn max = rpc conn $ RpcQuery SP_ExecuteSql ( nvarcharVal "" (Just "SELECT * FROM TSome WHERE someID < @Max") , nvarcharVal "" (Just "@Max Int") , intVal "" (Just max) )
rpc_sql_select3 :: Connection -> Int -> Int -> IO (RpcResponse () [Some]) rpc_sql_select3 conn min max = rpc conn $ RpcQuery (0xa::Word16) ( nvarcharVal "" (Just "SELECT * FROM TSome WHERE @Min < someID AND someID < @Max") , nvarcharVal "" (Just "@Min Int, @Max Int") , intVal "@Min" (Just min) , intVal "@Max" (Just max) )
rpc :: (RpcQuerySet a, RpcResponseSet b) => Connection -> a -> IO b Source #
RpcResponseSet
class RpcResponseSet a where Source #
Instances
data RpcResponse a b Source #
RpcResponse !Int !a !b | |
RpcResponseError !Info |
Instances
class RpcOutputSet a where Source #
fromReturnValues :: [ReturnValue] -> a Source #
Instances
RpcOutputSet () Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> () Source # | |
Data a => RpcOutputSet (Only a) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> Only a Source # | |
(Data a1, Data a2) => RpcOutputSet (a1, a2) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2) Source # | |
(Data a1, Data a2, Data a3) => RpcOutputSet (a1, a2, a3) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3) Source # | |
(Data a1, Data a2, Data a3, Data a4) => RpcOutputSet (a1, a2, a3, a4) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3, a4) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5) => RpcOutputSet (a1, a2, a3, a4, a5) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3, a4, a5) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6) => RpcOutputSet (a1, a2, a3, a4, a5, a6) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3, a4, a5, a6) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7) => RpcOutputSet (a1, a2, a3, a4, a5, a6, a7) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3, a4, a5, a6, a7) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8) => RpcOutputSet (a1, a2, a3, a4, a5, a6, a7, a8) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3, a4, a5, a6, a7, a8) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9) => RpcOutputSet (a1, a2, a3, a4, a5, a6, a7, a8, a9) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10) => RpcOutputSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11) => RpcOutputSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12) => RpcOutputSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13) => RpcOutputSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14) => RpcOutputSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15) => RpcOutputSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16) => RpcOutputSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17) => RpcOutputSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17, Data a18) => RpcOutputSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17, Data a18, Data a19) => RpcOutputSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17, Data a18, Data a19, Data a20) => RpcOutputSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17, Data a18, Data a19, Data a20, Data a21) => RpcOutputSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17, Data a18, Data a19, Data a20, Data a21, Data a22) => RpcOutputSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17, Data a18, Data a19, Data a20, Data a21, Data a22, Data a23) => RpcOutputSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17, Data a18, Data a19, Data a20, Data a21, Data a22, Data a23, Data a24) => RpcOutputSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17, Data a18, Data a19, Data a20, Data a21, Data a22, Data a23, Data a24, Data a25) => RpcOutputSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17, Data a18, Data a19, Data a20, Data a21, Data a22, Data a23, Data a24, Data a25, Data a26) => RpcOutputSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17, Data a18, Data a19, Data a20, Data a21, Data a22, Data a23, Data a24, Data a25, Data a26, Data a27) => RpcOutputSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17, Data a18, Data a19, Data a20, Data a21, Data a22, Data a23, Data a24, Data a25, Data a26, Data a27, Data a28) => RpcOutputSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27, a28) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27, a28) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17, Data a18, Data a19, Data a20, Data a21, Data a22, Data a23, Data a24, Data a25, Data a26, Data a27, Data a28, Data a29) => RpcOutputSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27, a28, a29) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27, a28, a29) Source # | |
(Data a1, Data a2, Data a3, Data a4, Data a5, Data a6, Data a7, Data a8, Data a9, Data a10, Data a11, Data a12, Data a13, Data a14, Data a15, Data a16, Data a17, Data a18, Data a19, Data a20, Data a21, Data a22, Data a23, Data a24, Data a25, Data a26, Data a27, Data a28, Data a29, Data a30) => RpcOutputSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27, a28, a29, a30) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet fromReturnValues :: [ReturnValue] -> (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27, a28, a29, a30) Source # |
RpcResultSet
class RpcResultSet a where Source #
rpcResultSetParser :: Parser' a Source #
Instances
RpcResultSet () Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' () Source # | |
Row a => RpcResultSet [a] Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' [a] Source # | |
(RpcResult a1, RpcResult a2) => RpcResultSet (a1, a2) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3) => RpcResultSet (a1, a2, a3) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3, RpcResult a4) => RpcResultSet (a1, a2, a3, a4) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3, a4) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3, RpcResult a4, RpcResult a5) => RpcResultSet (a1, a2, a3, a4, a5) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3, a4, a5) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3, RpcResult a4, RpcResult a5, RpcResult a6) => RpcResultSet (a1, a2, a3, a4, a5, a6) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3, a4, a5, a6) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3, RpcResult a4, RpcResult a5, RpcResult a6, RpcResult a7) => RpcResultSet (a1, a2, a3, a4, a5, a6, a7) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3, RpcResult a4, RpcResult a5, RpcResult a6, RpcResult a7, RpcResult a8) => RpcResultSet (a1, a2, a3, a4, a5, a6, a7, a8) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3, RpcResult a4, RpcResult a5, RpcResult a6, RpcResult a7, RpcResult a8, RpcResult a9) => RpcResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3, RpcResult a4, RpcResult a5, RpcResult a6, RpcResult a7, RpcResult a8, RpcResult a9, RpcResult a10) => RpcResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3, RpcResult a4, RpcResult a5, RpcResult a6, RpcResult a7, RpcResult a8, RpcResult a9, RpcResult a10, RpcResult a11) => RpcResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3, RpcResult a4, RpcResult a5, RpcResult a6, RpcResult a7, RpcResult a8, RpcResult a9, RpcResult a10, RpcResult a11, RpcResult a12) => RpcResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3, RpcResult a4, RpcResult a5, RpcResult a6, RpcResult a7, RpcResult a8, RpcResult a9, RpcResult a10, RpcResult a11, RpcResult a12, RpcResult a13) => RpcResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3, RpcResult a4, RpcResult a5, RpcResult a6, RpcResult a7, RpcResult a8, RpcResult a9, RpcResult a10, RpcResult a11, RpcResult a12, RpcResult a13, RpcResult a14) => RpcResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3, RpcResult a4, RpcResult a5, RpcResult a6, RpcResult a7, RpcResult a8, RpcResult a9, RpcResult a10, RpcResult a11, RpcResult a12, RpcResult a13, RpcResult a14, RpcResult a15) => RpcResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3, RpcResult a4, RpcResult a5, RpcResult a6, RpcResult a7, RpcResult a8, RpcResult a9, RpcResult a10, RpcResult a11, RpcResult a12, RpcResult a13, RpcResult a14, RpcResult a15, RpcResult a16) => RpcResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3, RpcResult a4, RpcResult a5, RpcResult a6, RpcResult a7, RpcResult a8, RpcResult a9, RpcResult a10, RpcResult a11, RpcResult a12, RpcResult a13, RpcResult a14, RpcResult a15, RpcResult a16, RpcResult a17) => RpcResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3, RpcResult a4, RpcResult a5, RpcResult a6, RpcResult a7, RpcResult a8, RpcResult a9, RpcResult a10, RpcResult a11, RpcResult a12, RpcResult a13, RpcResult a14, RpcResult a15, RpcResult a16, RpcResult a17, RpcResult a18) => RpcResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3, RpcResult a4, RpcResult a5, RpcResult a6, RpcResult a7, RpcResult a8, RpcResult a9, RpcResult a10, RpcResult a11, RpcResult a12, RpcResult a13, RpcResult a14, RpcResult a15, RpcResult a16, RpcResult a17, RpcResult a18, RpcResult a19) => RpcResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3, RpcResult a4, RpcResult a5, RpcResult a6, RpcResult a7, RpcResult a8, RpcResult a9, RpcResult a10, RpcResult a11, RpcResult a12, RpcResult a13, RpcResult a14, RpcResult a15, RpcResult a16, RpcResult a17, RpcResult a18, RpcResult a19, RpcResult a20) => RpcResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3, RpcResult a4, RpcResult a5, RpcResult a6, RpcResult a7, RpcResult a8, RpcResult a9, RpcResult a10, RpcResult a11, RpcResult a12, RpcResult a13, RpcResult a14, RpcResult a15, RpcResult a16, RpcResult a17, RpcResult a18, RpcResult a19, RpcResult a20, RpcResult a21) => RpcResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3, RpcResult a4, RpcResult a5, RpcResult a6, RpcResult a7, RpcResult a8, RpcResult a9, RpcResult a10, RpcResult a11, RpcResult a12, RpcResult a13, RpcResult a14, RpcResult a15, RpcResult a16, RpcResult a17, RpcResult a18, RpcResult a19, RpcResult a20, RpcResult a21, RpcResult a22) => RpcResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3, RpcResult a4, RpcResult a5, RpcResult a6, RpcResult a7, RpcResult a8, RpcResult a9, RpcResult a10, RpcResult a11, RpcResult a12, RpcResult a13, RpcResult a14, RpcResult a15, RpcResult a16, RpcResult a17, RpcResult a18, RpcResult a19, RpcResult a20, RpcResult a21, RpcResult a22, RpcResult a23) => RpcResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3, RpcResult a4, RpcResult a5, RpcResult a6, RpcResult a7, RpcResult a8, RpcResult a9, RpcResult a10, RpcResult a11, RpcResult a12, RpcResult a13, RpcResult a14, RpcResult a15, RpcResult a16, RpcResult a17, RpcResult a18, RpcResult a19, RpcResult a20, RpcResult a21, RpcResult a22, RpcResult a23, RpcResult a24) => RpcResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3, RpcResult a4, RpcResult a5, RpcResult a6, RpcResult a7, RpcResult a8, RpcResult a9, RpcResult a10, RpcResult a11, RpcResult a12, RpcResult a13, RpcResult a14, RpcResult a15, RpcResult a16, RpcResult a17, RpcResult a18, RpcResult a19, RpcResult a20, RpcResult a21, RpcResult a22, RpcResult a23, RpcResult a24, RpcResult a25) => RpcResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3, RpcResult a4, RpcResult a5, RpcResult a6, RpcResult a7, RpcResult a8, RpcResult a9, RpcResult a10, RpcResult a11, RpcResult a12, RpcResult a13, RpcResult a14, RpcResult a15, RpcResult a16, RpcResult a17, RpcResult a18, RpcResult a19, RpcResult a20, RpcResult a21, RpcResult a22, RpcResult a23, RpcResult a24, RpcResult a25, RpcResult a26) => RpcResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3, RpcResult a4, RpcResult a5, RpcResult a6, RpcResult a7, RpcResult a8, RpcResult a9, RpcResult a10, RpcResult a11, RpcResult a12, RpcResult a13, RpcResult a14, RpcResult a15, RpcResult a16, RpcResult a17, RpcResult a18, RpcResult a19, RpcResult a20, RpcResult a21, RpcResult a22, RpcResult a23, RpcResult a24, RpcResult a25, RpcResult a26, RpcResult a27) => RpcResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3, RpcResult a4, RpcResult a5, RpcResult a6, RpcResult a7, RpcResult a8, RpcResult a9, RpcResult a10, RpcResult a11, RpcResult a12, RpcResult a13, RpcResult a14, RpcResult a15, RpcResult a16, RpcResult a17, RpcResult a18, RpcResult a19, RpcResult a20, RpcResult a21, RpcResult a22, RpcResult a23, RpcResult a24, RpcResult a25, RpcResult a26, RpcResult a27, RpcResult a28) => RpcResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27, a28) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27, a28) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3, RpcResult a4, RpcResult a5, RpcResult a6, RpcResult a7, RpcResult a8, RpcResult a9, RpcResult a10, RpcResult a11, RpcResult a12, RpcResult a13, RpcResult a14, RpcResult a15, RpcResult a16, RpcResult a17, RpcResult a18, RpcResult a19, RpcResult a20, RpcResult a21, RpcResult a22, RpcResult a23, RpcResult a24, RpcResult a25, RpcResult a26, RpcResult a27, RpcResult a28, RpcResult a29) => RpcResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27, a28, a29) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27, a28, a29) Source # | |
(RpcResult a1, RpcResult a2, RpcResult a3, RpcResult a4, RpcResult a5, RpcResult a6, RpcResult a7, RpcResult a8, RpcResult a9, RpcResult a10, RpcResult a11, RpcResult a12, RpcResult a13, RpcResult a14, RpcResult a15, RpcResult a16, RpcResult a17, RpcResult a18, RpcResult a19, RpcResult a20, RpcResult a21, RpcResult a22, RpcResult a23, RpcResult a24, RpcResult a25, RpcResult a26, RpcResult a27, RpcResult a28, RpcResult a29, RpcResult a30) => RpcResultSet (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27, a28, a29, a30) Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultSetParser :: Parser' (a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14, a15, a16, a17, a18, a19, a20, a21, a22, a23, a24, a25, a26, a27, a28, a29, a30) Source # |
class RpcResult a where Source #
rpcResultParser :: Parser' a Source #
Instances
Row a => RpcResult [a] Source # | |
Defined in Database.MSSQLServer.Query.RpcResponseSet rpcResultParser :: Parser' [a] Source # |
RpcQuerySet
class RpcQuerySet a where Source #
toRpcRequest :: a -> RpcRequest Source #
Instances
RpcQuery !a !b |
Instances
class RpcQueryId a where Source #
There several ways provided for specify stored procedures. See ProcID section of \[MS-TDS\] 2.2.6.6 RPC Request.
toRpcReqBatch :: RpcParamSet b => a -> b -> RpcReqBatch Source #
Instances
RpcQueryId Word16 Source # | |
Defined in Database.MSSQLServer.Query.RpcQuerySet toRpcReqBatch :: RpcParamSet b => Word16 -> b -> RpcReqBatch Source # | |
RpcQueryId StoredProcedure Source # | |
Defined in Database.MSSQLServer.Query.RpcQuerySet toRpcReqBatch :: RpcParamSet b => StoredProcedure -> b -> RpcReqBatch Source # | |
RpcQueryId Text Source # | |
Defined in Database.MSSQLServer.Query.RpcQuerySet toRpcReqBatch :: RpcParamSet b => Text -> b -> RpcReqBatch Source # |
data StoredProcedure Source #
Instances
Bounded StoredProcedure Source # | |
Defined in Database.MSSQLServer.Query.RpcQuerySet | |
Enum StoredProcedure Source # | |
Defined in Database.MSSQLServer.Query.RpcQuerySet succ :: StoredProcedure -> StoredProcedure # pred :: StoredProcedure -> StoredProcedure # toEnum :: Int -> StoredProcedure # fromEnum :: StoredProcedure -> Int # enumFrom :: StoredProcedure -> [StoredProcedure] # enumFromThen :: StoredProcedure -> StoredProcedure -> [StoredProcedure] # enumFromTo :: StoredProcedure -> StoredProcedure -> [StoredProcedure] # enumFromThenTo :: StoredProcedure -> StoredProcedure -> StoredProcedure -> [StoredProcedure] # | |
Show StoredProcedure Source # | |
Defined in Database.MSSQLServer.Query.RpcQuerySet showsPrec :: Int -> StoredProcedure -> ShowS # show :: StoredProcedure -> String # showList :: [StoredProcedure] -> ShowS # | |
RpcQueryId StoredProcedure Source # | |
Defined in Database.MSSQLServer.Query.RpcQuerySet toRpcReqBatch :: RpcParamSet b => StoredProcedure -> b -> RpcReqBatch Source # |
class RpcParamSet a where Source #
toRpcReqBatchParams :: a -> [RpcReqBatchParam] Source #
Instances
RpcParamVal !RpcParamName !TypeInfo !a | |
RpcParamRef !RpcParamName !TypeInfo !a | |
RpcParamDefVal !RpcParamName !TypeInfo !a | |
RpcParamDefRef !RpcParamName !TypeInfo !a |
Instances
type RpcParamName = Text Source #
Helpers for passing parameters
tinyintVal :: Integral a => RpcParamName -> Maybe a -> RpcParam (Maybe a) Source #
smallintVal :: Integral a => RpcParamName -> Maybe a -> RpcParam (Maybe a) Source #
smallmoneyVal :: RpcParamName -> Maybe Money -> RpcParam (Maybe Money) Source #
smalldatetimeVal :: RpcParamName -> Maybe UTCTime -> RpcParam (Maybe UTCTime) Source #
datetimeVal :: RpcParamName -> Maybe UTCTime -> RpcParam (Maybe UTCTime) Source #
float24Val :: Fractional a => RpcParamName -> Maybe a -> RpcParam (Maybe a) Source #
realVal :: Fractional a => RpcParamName -> Maybe a -> RpcParam (Maybe a) Source #
float53Val :: Fractional a => RpcParamName -> Maybe a -> RpcParam (Maybe a) Source #
doubleVal :: Fractional a => RpcParamName -> Maybe a -> RpcParam (Maybe a) Source #
uniqueidentifierVal :: RpcParamName -> Maybe UUID -> RpcParam (Maybe UUID) Source #
decimalVal :: HasResolution a => RpcParamName -> Precision -> Either Scale (Fixed a) -> RpcParam (Maybe (Fixed a)) Source #
numericVal :: HasResolution a => RpcParamName -> Precision -> Either Scale (Fixed a) -> RpcParam (Maybe (Fixed a)) Source #
charVal :: RpcParamName -> Maybe ByteString -> RpcParam (Maybe ByteString) Source #
varcharVal :: RpcParamName -> Maybe ByteString -> RpcParam (Maybe ByteString) Source #
textVal :: RpcParamName -> Maybe ByteString -> RpcParam (Maybe ByteString) Source #
nvarcharVal :: RpcParamName -> Maybe Text -> RpcParam (Maybe Text) Source #
binaryVal :: RpcParamName -> Maybe ByteString -> RpcParam (Maybe ByteString) Source #
varbinaryVal :: RpcParamName -> Maybe ByteString -> RpcParam (Maybe ByteString) Source #
imageVal :: RpcParamName -> Maybe ByteString -> RpcParam (Maybe ByteString) Source #
tinyintRef :: Integral a => RpcParamName -> Maybe a -> RpcParam (Maybe a) Source #
smallintRef :: Integral a => RpcParamName -> Maybe a -> RpcParam (Maybe a) Source #
smallmoneyRef :: RpcParamName -> Maybe Money -> RpcParam (Maybe Money) Source #
smalldatetimeRef :: RpcParamName -> Maybe UTCTime -> RpcParam (Maybe UTCTime) Source #
datetimeRef :: RpcParamName -> Maybe UTCTime -> RpcParam (Maybe UTCTime) Source #
float24Ref :: Fractional a => RpcParamName -> Maybe a -> RpcParam (Maybe a) Source #
realRef :: Fractional a => RpcParamName -> Maybe a -> RpcParam (Maybe a) Source #
float53Ref :: Fractional a => RpcParamName -> Maybe a -> RpcParam (Maybe a) Source #
doubleRef :: Fractional a => RpcParamName -> Maybe a -> RpcParam (Maybe a) Source #
uniqueidentifierRef :: RpcParamName -> Maybe UUID -> RpcParam (Maybe UUID) Source #
decimalRef :: HasResolution a => RpcParamName -> Precision -> Either Scale (Fixed a) -> RpcParam (Maybe (Fixed a)) Source #
numericRef :: HasResolution a => RpcParamName -> Precision -> Either Scale (Fixed a) -> RpcParam (Maybe (Fixed a)) Source #
charRef :: RpcParamName -> Int -> Maybe ByteString -> RpcParam (Maybe ByteString) Source #
varcharRef :: RpcParamName -> Int -> Maybe ByteString -> RpcParam (Maybe ByteString) Source #
textRef :: RpcParamName -> Int -> Maybe ByteString -> RpcParam (Maybe ByteString) Source #
nvarcharRef :: RpcParamName -> Int -> Maybe Text -> RpcParam (Maybe Text) Source #
binaryRef :: RpcParamName -> Int -> Maybe ByteString -> RpcParam (Maybe ByteString) Source #
varbinaryRef :: RpcParamName -> Int -> Maybe ByteString -> RpcParam (Maybe ByteString) Source #
imageRef :: RpcParamName -> Int -> Maybe ByteString -> RpcParam (Maybe ByteString) Source #
tinyintDefRef :: Integral a => RpcParamName -> RpcParam (Maybe a) Source #
smallintDefRef :: Integral a => RpcParamName -> RpcParam (Maybe a) Source #
bigintDefRef :: Integral a => RpcParamName -> RpcParam (Maybe a) Source #
smallmoneyDefRef :: RpcParamName -> RpcParam (Maybe Money) Source #
moneyDefRef :: RpcParamName -> RpcParam (Maybe Money) Source #
datetimeDefRef :: RpcParamName -> RpcParam (Maybe UTCTime) Source #
float24DefRef :: Fractional a => RpcParamName -> RpcParam (Maybe a) Source #
realDefRef :: Fractional a => RpcParamName -> RpcParam (Maybe a) Source #
float53DefRef :: Fractional a => RpcParamName -> RpcParam (Maybe a) Source #
doubleDefRef :: Fractional a => RpcParamName -> RpcParam (Maybe a) Source #
decimalDefRef :: HasResolution a => RpcParamName -> Precision -> Scale -> RpcParam (Maybe (Fixed a)) Source #
numericDefRef :: HasResolution a => RpcParamName -> Precision -> Scale -> RpcParam (Maybe (Fixed a)) Source #
charDefRef :: RpcParamName -> Int -> RpcParam (Maybe ByteString) Source #
varcharDefRef :: RpcParamName -> Int -> RpcParam (Maybe ByteString) Source #
textDefRef :: RpcParamName -> Int -> RpcParam (Maybe ByteString) Source #
ncharDefRef :: RpcParamName -> Int -> RpcParam (Maybe Text) Source #
nvarcharDefRef :: RpcParamName -> Int -> RpcParam (Maybe Text) Source #
ntextDefRef :: RpcParamName -> Int -> RpcParam (Maybe Text) Source #
binaryDefRef :: RpcParamName -> Int -> RpcParam (Maybe ByteString) Source #
varbinaryDefRef :: RpcParamName -> Int -> RpcParam (Maybe ByteString) Source #
imageDefRef :: RpcParamName -> Int -> RpcParam (Maybe ByteString) Source #
Exceptions
withTransaction :: Connection -> IO a -> IO a Source #
data QueryError Source #
Instances
Exception QueryError Source # | |
Defined in Database.MSSQLServer.Query toException :: QueryError -> SomeException # fromException :: SomeException -> Maybe QueryError # displayException :: QueryError -> String # | |
Show QueryError Source # | |
Defined in Database.MSSQLServer.Query showsPrec :: Int -> QueryError -> ShowS # show :: QueryError -> String # showList :: [QueryError] -> ShowS # |