Try Playground
Show / Hide Table of Contents

Enum CmdParamsType

Describes the type of parameters passed to the command.

Assembly: Alachisoft.NCache.Runtime.dll
Syntax
public enum CmdParamsType

Fields

Name Description
BigInt

System.Int64. A 64-bit signed integer.

Binary

System.Array of type System.Byte. A fixed-length stream of binary data ranging between 1 and 8,000 bytes.

Bit

System.Boolean. An unsigned numeric value that can be 0, 1, or null.

Char

System.String. A fixed-length stream of non-Unicode characters ranging between 1 and 8,000 characters.

Date

Date data ranging in value from January 1,1 AD through December 31, 9999 AD.

DateTime

System.DateTime. Date and time data ranging in value from January 1, 1753 to December 31, 9999 to an accuracy of 3.33 milliseconds.

DateTime2

Date and time data. Date value range is from January 1,1 AD through December 31, 9999 AD. Time value range is 00:00:00 through 23:59:59.9999999 with an accuracy of 100 nanoseconds.

DateTimeOffset

Date and time data with time zone awareness. Date value range is from January 1,1 AD through December 31, 9999 AD. Time value range is 00:00:00 through 23:59:59.9999999 with an accuracy of 100 nanoseconds. Time zone value range is -14:00 through +14:00.

Decimal

System.Decimal. A fixed precision and scale numeric value between -10 38 -1 and 10 38 -1.

Float

System.Double. A floating point number within the range of -1.79E +308 through 1.79E +308.

Int

System.Int32. A 32-bit signed integer.

Money

System.Decimal. A currency value ranging from -2 63 (or -9,223,372,036,854,775,808) to 2 63 -1 (or +9,223,372,036,854,775,807) with an accuracy to a ten-thousandth of a currency unit.

NChar

System.String. A fixed-length stream of Unicode characters ranging between 1 and 4,000 characters.

NVarChar

System.String. A variable-length stream of Unicode characters ranging between 1 and 4,000 characters. Implicit conversion fails if the string is greater than 4,000 characters. Explicitly set the object when working with strings longer than 4,000 characters.

Real

System.Single. A floating point number within the range of -3.40E +38 through 3.40E +38.

SmallDateTime

System.DateTime. Date and time data ranging in value from January 1, 1900 to June 6, 2079 to an accuracy of one minute.

SmallInt

System.Int16. A 16-bit signed integer.

SmallMoney

System.Decimal. A currency value ranging from -214,748.3648 to +214,748.3647 with an accuracy to a ten-thousandth of a currency unit.

Structured

A special data type for specifying structured data contained in table-valued parameters.

Time

Time data based on a 24-hour clock. Time value range is 00:00:00 through 23:59:59.9999999 with an accuracy of 100 nanoseconds.

Timestamp

System.Array of type System.Byte. Automatically generated binary numbers, which are guaranteed to be unique within a database. Timestamp is used typically as a mechanism for version-stamping table rows. The storage size is 8 bytes.

TinyInt

System.Byte. An 8-bit unsigned integer.

Udt

A SQL Server 2005 user-defined type (UDT).

UniqueIdentifier

System.Guid. A globally unique identifier (or GUID).

VarBinary

System.Array of type System.Byte. A variable-length stream of binary data ranging between 1 and 8,000 bytes. Implicit conversion fails if the byte array is greater than 8,000 bytes. Explicitly set the object when working with byte arrays larger than 8,000 bytes.

VarChar

System.String. A variable-length stream of non-Unicode characters ranging between 1 and 8,000 characters.

Variant

System.Object. A special data type that can contain numeric, string, binary, or date data as well as the SQL Server values Empty and Null, which is assumed if no other type is declared.

Xml

An XML value. Obtain the XML as a string using the System.Data.SqlClient.SqlDataReader.GetValue(System.Int32) method or System.Data.SqlTypes.SqlXml.Value property, or as an System.Xml.XmlReader by calling the System.Data.SqlTypes.SqlXml.CreateReader() method.

In This Article
  • Fields

Contact Us

PHONE

+1 (214) 764-6933   (US)

+44 20 7993 8327   (UK)

 
EMAIL

sales@alachisoft.com

support@alachisoft.com

NCache
  • NCache Enterprise
  • NCache Professional
  • Edition Comparison
  • NCache Architecture
  • Benchmarks
Download
Pricing
Try Playground

Deployments
  • Cloud (SaaS & Software)
  • On-Premises
  • Kubernetes
  • Docker
Technical Use Cases
  • ASP.NET Sessions
  • ASP.NET Core Sessions
  • Pub/Sub Messaging
  • Real-Time ASP.NET SignalR
  • Internet of Things (IoT)
  • NoSQL Database
  • Stream Processing
  • Microservices
Resources
  • Magazine Articles
  • Third-Party Articles
  • Articles
  • Videos
  • Whitepapers
  • Shows
  • Talks
  • Blogs
  • Docs
Customer Case Studies
  • Testimonials
  • Customers
Support
  • Schedule a Demo
  • Forum (Google Groups)
  • Tips
Company
  • Leadership
  • Partners
  • News
  • Events
  • Careers
Contact Us

  • EnglishChinese (Simplified)FrenchGermanItalianJapaneseKoreanPortugueseSpanish

  • Contact Us
  •  
  • Sitemap
  •  
  • Terms of Use
  •  
  • Privacy Policy
� Copyright Alachisoft 2002 - 2025. All rights reserved. NCache is a registered trademark of Diyatech Corp.
Back to top