Subscript
Select * from goodswhere (Range = '') and ([Year] = '2004') and (Goods_name <> 'Pathern)
'Delete Field ALTER TABLE CC DROP COLUMN BB
'Delete all the data of the table, ID Auto number Reset Truncate Table Company_INFO
'Remove Table Drop Table TableName
'ONCLICKοnclick = "javascript: window.location.href =' Products.asp id = 1? '" Οnclick = "javascript: window.location.replace (' Products.asp id = 1 '?)" Οnclick = "javascript: window .open ('products.asp', 'mytitle', 'width = 200, height = 60, scrollbars = no')
'Open Record
Set conn = sever.createObject ("adoDb.connection")
Conn.open "Driver = {Microsoft Access Driver (* .mdb)}; dbq =" & Server.mappath ("/ datebase.mdb")
Conntr = "provider = SQLOLEDB.1; password = capslockshift; persist security info = true; user id = sa; initial catalog = chinatvshopping; data source = server; connection timeout = 15"
Conn.open connStr
SET RS = Server.createObject ("AdoDb.Recordset")
SET RS = conn.execute ("Select * from table")
Rs.open "SELECT * from MyTable", CONN, 1
Rs.close
Conn.close
SET RS = conn.execute ("SELECT ID, TIM DBO.NEWS WHERE (category = 1710)")
1. The window is topped in Body joins οnblur = "Window.focus ()" allows the window to top
1.1ShowModaldialog ("Company_Manage_Query.asp", S, "Dialogwidth: 300px; Status: No; Dialogheight: 425px");
