public sealed class Statement : IMessage<ExecuteBatchDmlRequest.Types.Statement>, IEquatable<ExecuteBatchDmlRequest.Types.Statement>, IDeepCloneable<ExecuteBatchDmlRequest.Types.Statement>, IBufferMessage, IMessage
Parameter names and values that bind to placeholders in the DML string.
A parameter placeholder consists of the @ character followed by the
parameter name (for example, @firstName). Parameter names can contain
letters, numbers, and underscores.
Parameters can appear anywhere that a literal value is expected. The
same parameter name can be used more than once, for example:
"WHERE id > @msg_id AND id < @msg_id + 100"
It is an error to execute a SQL statement with unbound parameters.
It is not always possible for Cloud Spanner to infer the right SQL type
from a JSON value. For example, values of type BYTES and values
of type STRING both appear in [params][google.spanner.v1.ExecuteBatchDmlRequest.Statement.params] as JSON strings.
In these cases, param_types can be used to specify the exact
SQL type for some or all of the SQL statement parameters. See the
definition of [Type][google.spanner.v1.Type] for more information
about SQL types.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-07 UTC."],[[["\u003cp\u003eThis page details the \u003ccode\u003eStatement\u003c/code\u003e class within the \u003ccode\u003eGoogle.Cloud.Spanner.V1\u003c/code\u003e namespace, specifically for version 3.10.0 and includes links to previous versions.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003eStatement\u003c/code\u003e class, used for a single DML statement, inherits from \u003ccode\u003eObject\u003c/code\u003e and implements several interfaces such as \u003ccode\u003eIMessage\u003c/code\u003e, \u003ccode\u003eIEquatable\u003c/code\u003e, \u003ccode\u003eIDeepCloneable\u003c/code\u003e, and \u003ccode\u003eIBufferMessage\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eThe class contains two constructors: a default constructor, \u003ccode\u003eStatement()\u003c/code\u003e, and one that takes an \u003ccode\u003eExecuteBatchDmlRequest.Types.Statement\u003c/code\u003e object as a parameter.\u003c/p\u003e\n"],["\u003cp\u003eKey properties of the \u003ccode\u003eStatement\u003c/code\u003e class include \u003ccode\u003eParams\u003c/code\u003e for binding parameter values, \u003ccode\u003eParamTypes\u003c/code\u003e for specifying SQL types, and \u003ccode\u003eSql\u003c/code\u003e for the actual DML string.\u003c/p\u003e\n"],["\u003cp\u003eThis page provides reference documentation for the .NET implementation of \u003ccode\u003eGoogle.Cloud.Spanner.V1\u003c/code\u003e for different versions of the library, including the latest \u003ccode\u003e5.0.0-beta05\u003c/code\u003e, and includes documentation down to version 3.5.0.\u003c/p\u003e\n"]]],[],null,[]]