MySQL supports a large number of column types, which can be grouped into 3 categories: numeric types, date and time types, and string (character) types. This section first gives an overview of the available types, summarizes the storage requirements
The Caption property (that is, the caption) of a Field object in an Access database is used to set the caption for the data field. In the normal database design in order to maintain the convenience of maintenance, many developers have the field name
Process
Pl/sql is a mainstream application programming language based on Oracle, which is characterized by a combination of SQL statements and procedural development languages to achieve more complex business logic. This article mainly discusses the
server|sqlserver| function
1. String function
Length and analytical use
DATALENGTH (char_expr) returns the string contains the number of characters, but does not contain the trailing spaces
SUBSTRING (expression,start,length) Don't say much, take
Ado
DropShadow Property
The DropShadow property is intended to add shadow effects to an object. The effect it does looks like leaving the original object out of the page and then displaying the object's projection on the page. Take a look at its
Css
The value of a length consists of an optional plus "+" or minus sign "-", followed by a number, and two letters indicating the unit. There is no space in the value of a length, for example, "1.3 em" is not a valid length value, but "1.3em" is
JavaScript does not support multidimensional arrays, but because arrays can contain objects (arrays are also objects), arrays can be nested to implement functions similar to multidimensional arrays.
1. Understanding Arrays
An array is a collection
Commonly used check regular expression, need to be difficult to find, the collection of it.
Verify Number: ^[0-9]*$Verify the N-bit number: ^\d{n}$Verify at least n digits: ^\d{n,}$Verify the number of m-n bits: ^\d{m,n}$Verify numbers beginning
Grammar | regular
A regular expression is a literal pattern consisting of ordinary characters (such as characters A through Z) and special characters (called metacharacters ). This pattern describes one or more strings to be matched when looking
Object
Math ObjectProperty
LN10 (natural logarithm of 10)
PI (3.1415926 ...)
Sqrt1_2 (square root of 1/2)
Method
ABS (x) returns the absolute value of X
ACOs (x) returns the arc cosine value of X
ASIN (x) returns the arc sin value of
Reference | object | The natural logarithm of the array LN10 10 (approximately equal to 2.302)
LOG2E the logarithm of the 2-base e (about 1.442)
LOG10E the logarithm of a 10-base e (approximately equal to o.434)
Value of Pi∏ (approximately equal to 3
function | date ' Date function Package Datapackage
%>
'**********************
' Purpose: Convert date to standard date string
' Input: Date
' Output: Date string, such as: 2002-12-22
'**********************
Function Getdatestr (ddate)
Dim strtmp
Function
Many functions in ASP, we should focus on learning functions: function name, function function, function return value and example.
1. Function Array ()Function: Create a number of variablesFormat: Array (list)Parameters: The list is the
Function
24. Function LCase ()
Function: Change the character of a character type to a small write character.
Format: Lcase (String)
Parameters: String is the number of string changes
Example:
Str= "This is lcase!"
Response.Write Lcase
Program | Connection Database ' ******* connection Database tree Graph generator ********
'*****************************
' Suppose you have established the SQL Server database Unittree and created tables in the library:
' Units (ID Unit ordinal
rss| page |rss Many times when we use the Asp+ database to program a website, when a record is read and other variables are calculated, a null value may result in the program returning an error, if each read statement is followed by a judgment
Program | Vote for the survey to understand the site visitors to the specific issue of the position, we can set up a polling site, site visitors directly choose the answer, the program automatically to all the answers to statistics and
Stored procedure | Stored Procedure 1 This is also the simplest method, with two input parameters and no return value:
Set connection = Server.CreateObject ("Adodb.connection")
Connection.Open SOMEDSN
Connection.Execute "ProcName varvalue1, Varvalue2
Return, break, and contiue are language constructs, like if statements, but exit is a function. 1.exit function: Output A and terminate the current script outputs a message and terminates the existing scripts. If a piece of text includes
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.