Methods and apparatus relating to server/client sql environments
AssigneeMicrosoft Corporation
InventorsIl-Sung Lee, Matthew A. Neerincx, Vaughn L. Washington, Alazel Acheson
Life of this patent
Estimating the term…
Abstract
Systems and methodologies that enhance a Tabular Data Stream (TDS) protocol by enabling clients to send tabular formed data as a single parameter to servers. A Table Valued Parameter (TVP) transporting component enables the client servers to transmit entire database tables as a single parameter; when invoking a server side procedure, for example. As such, values can be passed for functions associated with a stored procedure, and a parameter styled Application Program Interface (API) can be implemented.
Claims20
A computer implemented system comprising the following computer executable components:
- a tabular data stream (TDS) protocol that transfers requests-responses between a client(s) and a server(s)
- a table valued parameter (TVP) transporting component as part of the TDS, the TVP component sends tabular formed data as a single parameter from the client to the server.
A computer implemented method comprising the following computer executable acts:
- transferring data from a client to a server via a TDS protocol;
- and
- sending a tabular formed data as a single parameter from the client to the server.
A computer implemented system comprising:
- means for exchanging data between a client and a server;
- and
- means for receiving a table by the server in form of a single parameter.
Dependencies are inferred from the claim text.