This shows you how to insert a row in sql using asp. strq1 = "INSERT INTO crs_job_listing (job_title, job_category, job_description) VALUES " strq = strq1 & "('" & job_title & "','" & job_category & "','" & job_description & "')" cnnConn.Execute...

This code will show you how to move a row from one table to another using ASP. This involves delete and insert into. strq = "INSERT INTO archive SELECT * FROM user_requests WHERE db_id =" & objGetForm("db_id") & ";" strq1 = "DELETE FROM user_requests WHERE db_id =" &...

How to read a table in SQL using ASP. Set objGetForm = cnnConn.Execute("SELECT * FROM crs_applicants") SHARETHIS.addEntry({ title: "Select statement with sql using asp", url: "http://code.netexceed.com/asp/select-statement-with-sql-using-asp/" });

This shows you how you can connect to a sql database using asp. It’s better to put this code in a seperate file and use a include statement. Set cnnConn = Server.CreateObject("ADODB.Connection") FilePath="DRIVER={SQL Server};SERVER=*****;UID=*****;PWD=*****;DATABASE=database_name" cnnConn.open...

This is how you update a row in SQL using ASP. strq = "UPDATE crs_applicants SET education_completed = " & education_completed & ", graduate = " & graduate & "" strq = strq & " WHERE tdb_id=" & tdb_id & ";" cnnConn.Execute strq SHARETHIS.addEntry({...

This is how you create a stored procedure in SQL. CREATE PROCEDURE update_new_insurance @first_name varchar(50), @last_name varchar(50), @ins_assign Integer, @db_id Integer AS UPDATE insurance_db SET first_name = @first_name, last_name = @last_name, ins_assign...

Here is how to order by ASC or DESC in sql. Use ASC for ascending and DESC for Descending. Set objGetSort1ENTCensus = cnnConn.Execute("SELECT * FROM qxSQLCensusBasicView ORDER BY occupancy DESC") SHARETHIS.addEntry({ title: "ORDER command in SQL using ASP", url: "http://code.netexceed.com/asp/order-command-in-sql-using-asp/"...

Shows you how to read the date fields in SQL or Access files through ASP. SELECT * FROM main_ca WHERE date_submit BETWEEN #MMdatefrom# AND #MMdateto# ORDER BY id_stamp DESC SHARETHIS.addEntry({ title: "Reading dates into SQL from ASP", url: "http://code.netexceed.com/asp/reading-dates-into-sql-from-asp/"...