Recommended: parse code that uses ADO to connect to various databases A brief introduction to several ADO connection methods: ODBCDSN, ODBCDSN-Less, OLEDBProvider, and MSRemoteProvider. 1. ODBCDSN connection I.DSN oConn.OpenDSN=AdvWorks;_ UID=Admin;_ PWD=; Note: Since MDAC2.1, this method cannot be used, that is, only the DSN file name is placed in ConnectString
Cbool(string) converts to booleanCbyte(string) Convert to a value of byte type
Ccur(string) Convert to currency value
Cdate(string) Convert to a value of the day-old type
Cdbl(string) converts to double precision value
Cint(string) Convert to integer value
Clng(string) converts to long integer value
Csng(string) converts to single-precision value
Cstr(var) converts to string value
Str(var) value converted to string
Val(string) string to numeric value
*******************
*******************
Abs(nmb) returns the absolute value of the number
Atn(nmb) Returns the arc tangent of a number
Cos(nmb) Returns the Yuxuan value of an angle
Exp(nmb) Returns the power value of the natural index
Int(nmb) Returns the shaping (carry) part of the number
Fix(nmb) Returns the skeleton (discarded) part of the number
Formatpercent(expression) Returns percentage
Hex(nmb) Returns the hex number of data
Log(nmb) Returns natural logarithm
Oct(nmb) Returns the angular number of the number
Rnd returns a random number greater than 0 and less than 1
Sgn(nmb) determines the positive and negative signs of a number
Sin(nmb) Returns the Zhenghyun value of the angle
Sqr(nmb) returns the quadratic root of the number
Tan(nmb) Returns the tangent value of a number
Asc(string) Returns ASCII string
Chr(charcode) Return characters according to character code
Instr(string,searchstr) Returns the first character position of the searched string, string is a string, and searchstr is a string to be searched
InstrRev(string,searchstr) Same as above, just start searching from the right
Lcase(var) Change the string to lowercase
Left(string,nmb) Returns nmb strings starting from the left from string
Len(string) Returns the length of the string
Ltrim(string) Cut off the space on the left side of the string
Share: How to convert a string to an array with Split and get the array subscript value Using interval string storage can reduce the writing of several database fields, and it is also convenient for the extension of data in the future. For example: In the forum, the user's personalities include multiple personalities, optimistic, mature and steady, childish and naughty, gentle and considerate, etc. The corresponding values are 0, 1, 2, 3, and 4 respectively. When storing these data, use interval strings to store the data into a text.
2 pages in total Previous page 12 Next page