90网络常用T-SQL语言命令函数集(国外英语资料).doc

90网络常用T-SQL语言命令函数集(国外英语资料) Commonly used T-SQL language command function set (1) data logging screening: Sql= select*from data table where field name = field value orderby field name [desc] Sql= select*from data table, where field name, like% field value,%orderby field name, [desc] Sql= selecttop10*from data table where field name orderby field name [desc] Sql= select*from data table where field name in (value 1 , value 2, value 3 ) Sql= select*from data table, where field name, between value, 1and value 2 (2) updating data records: Sql= update data table, set field name = field value, where conditional expression Sql= update data table, set field, 1= value 1, field 2= value 2 Field n= value nwhere conditional expression (3) deleting data records: Sql= deletefrom data table where conditional expression Sql= deletefrom data table (delete all data tables) (4) adding data records: Sql= insertinto data table (field 1, field 2, field 3... Values (value 1, value 2, value 3... ) Sql= insertinto target data table select*from source data table (to add the source data table record to the target data table) (5) data recording statistic function: AVG (field name) draws a table column average COUNT (*| field name) statistics on the data rows or on a column of data for the statistics of the number of values MAX (field name) gets the maximum value of a table column MIN (field name) gets the minimum value of a table column SUM (field name) adds the value of the data column Method of referencing the above functions: Sql= selectsum (field name), as alias, from data table, where conditional expression Setrs=conn.excute (SQL) Use RS (alias) to get the system value, and other functions use the same as above. (5) establishment and deletion of data tables: CREATETABLE data table name (field 1, type 1 (length), field 2, type 2 (length) ) Example: CREATETABLEtab01 (namevarchar (50), datetimedefaultnow ()) DROPTABLE data table name (permanently delete a data table) ==========================