How do you delete a record in SQL Server

How do you delete a record in SQL Server

Delete a record in SQL Server

In order to delete record (s) from SQL Server use the following codes.

Set conn = Server.CreateObject("ADODB.Connection")

cn.Open "DSN=myDSN;UID=sa;PWD=;DATABASE=pubs"

Set rs = Server.CreateObject("ADODB.Recordset")

SQLstr = "Delete * from employee where EmpID=" & request.form("employeeid")

Rs.open SQLstr, conn, 1,3