Executing Transact-SQL UPDATE statement

Top Tutorials

New Tutorials

Submit

Login

Register

Tutorial Detail

• Total Hits: 2791

• Average Rating :
  

•  

• Total Votes: 36 votes

• Category: ASP/Database Concepts

• Submitted on: 2008-03-06 09:15:31

• Submitted By: Devesh Khanna

• Set as Favorite

Description:

In this example, we will edit some records from a database. This source code helps us to edit records to database without slowing down database

dim strConnection
strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db/our_db.mdb")
'strConnection = "Provider=SQLOLEDB;Server=ASP;User ID=sa;Password=;Database=MY_DB;"

Set objConn = Server.CreateObject ("ADODB.Connection")
objConn.open strCon
objConn.execute("Update myTable Set field1 = '"& some_value &"' Where id = "& ID &"")    More detail...

Rating Detail

Stars	Percentage	Total Vote
	16.67%	6
	16.67%	6
	16.67%	6
	16.67%	6
	16.67%	6

Caste Your Vote

Rating	Selection	Guidelines
Poor:		Very disappointing, useless.
Fair:		Below average, disappointing but not useless.
Good:		About average in its class.
Very Good:		Above average for its category.
Excellent:		One of the best Tutorials in its category.

---