asp,Set conn = Server.CreateObject("ADODB.Connection"),conn.Open "your_connection_string",Set rs = conn.Execute("SELECT * FROM your_table"),Do While Not rs.EOF, Response.Write(rs("column_name") & ""), rs.MoveNext,Loop,rs.Close,conn.Close,Set rs = Nothing,Set conn = Nothing,
``vbscript,Dim ms,ms = DatePart("ss", Now()) * 1000 + DatePart("ns", Now()) / 1000000,Response.Write(ms),
``CREATE TABLE
语句结合 SELECT
语句。假设你要复制一个名为 account_table
的表,新表命名为 account_table_copy
,可以这样做:,,``sql,CREATE TABLE account_table_copy AS SELECT * FROM account_table;,
`,,这条 SQL 语句会创建一个新表
account_table_copy,并将原表
account_table` 中的所有数据复制到新表中。global.asa
文件或默认页面(如index.asp
),找到``标签并编辑其中的内容。Powered By Z-BlogPHP 1.7.3