<% Openbconnsql = "select * from dbo.sysObjects where id = Object_id (n '[dbo]. [Tuiguang]') And ObjectProperty (ID, n'uSERTABLE ') = 1" Creatersrs.Open SQL, CONN, 1, 1
IF f.eof or rs.bof dam
Create Tuiguang (Website Promotion Table) SQL = "Create Table [DBO]. [Tuiguang] (" & _ "[Id] [INT] Idnessity (1, 1) Not Null," & _ 'ID Identity "[TNAME] [VARCHAR ] (100) collate chinese_prc_ci_as null, "& _ 'name" [content] [ntext] collate Chinese_prc_ci_as null, "& _' product description" [PIC] [varchar] (100) collate chinese_prc_ci_as null, "& _ 'picture" [price] [INT] NULL, "& _ 'price" constraint [PK_TUIGUANG] Primary Key Clustered ("& _" [ID] "& _") on [primary] "& _") on [primary] "& _ rs.close
CONN.EXECUTE (SQL)
Response.write "Create Tuiguang Table Success
"
Elseresponse.write "existing" rs.closendiff
SET RS = NothingCloseDbconN%>
