update2.asp

ASP论坛2000

<%@ LANGUAGE="VBSCRIPT" %>
<%option explicit%>
<!--#include file="conn.inc"-->
<%
  response.buffer=false
  '----------------------------------------------
  ' this file  create "essence" table structure
  '----------------------------------------------
  on error resume next  
  dim sql
  reponse.write "create 'essence' table structure...<br>"
  sql="create table board( id counter CONSTRAINT id PRIMARY KEY,announceid int, boardid int, username varchar(50) , useremail varchar(255) ,url varchar(255) , urlTitle varchar(255) ,urlPic  varchar(255) ,Topic  varchar(255) ,Body memo ,dateAndTime varchar(50) , hits int,length int)"
  conn.execute sql
  response.write "Update OK"
%>