[SQL] [ASP] - DELETE

Cancellare dati da una tabella in SQL e ASP.

CNN=Application("CNN")
set conn=Server.CreateObject("ADODB.Connection")
conn.open CNN

qry="DELETE * FROM nome_tabella WHERE id= "& id &" ;"

'response.Write qry (in caso di errori)

conn.execute(qry)
conn.close
set conn=nothing