Executing Transact-SQL INSERT statement

Home
Web Development
News Center
Security
Databases
Web Hosting
Web Design
Programming
Software

Executing Transact-SQL INSERT statement

by Scud Saturday, November 26, 2005 Rating:

Vote this news:

Printable View | Email Story | Write Comment

In this example, we will add some records to a database. This source code helps us to adding 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("Insert Into myTable (field1, field2) VALUES ("& some_data &", "& some_data2 &" )")
%>

Linkware Applications:
Active News Manager
Easy Download Manager
Giga Rss Reader
Ikon AdManager
QMail Mailing List Manager
Professional Download Assistant

ASP

¤ Methods of Session Object
¤ Simple XML/RSS Parser - Part II
¤ Selecting random record from database
¤ Uploading Images to Database Using Persist AspUpload
¤ Simple XML/RSS Parser

Most Viewed
Most Rated

ASP Chat Box
Free User Registration Form
VBScript Examples : DatePart Function
Encoding URL strings
List of Locale ID (LCID) Values as Assigned by Microsoft