Shared Tutorials
Tutorials Shared by the Internet Community
Advertisements
| Top Tutorials | New Tutorials | Submit | Login | Register |
Tutorial Basic Detail
Executing Transact-SQL INSERT statement
In this example, we will add some records to a database.http://www.dotnetindex.com/articles/50_Executing_Transact_SQL_INSERT_statement.asp
Total Hits: 3163
Total Votes: 36 votes
Average Rating: 2.5 out of 5
Category: ASP/Database Concepts
Description:
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 &" )")
%>
Rating Detail
| Stars | Percentage | Total Vote |
|---|---|---|
![]() |
![]() ![]() 16.67% |
6 |
![]() ![]() |
![]() ![]() 16.67% |
6 |
![]() ![]() ![]() |
![]() ![]() 16.67% |
6 |
![]() ![]() ![]() ![]() |
![]() ![]() 16.67% |
6 |
![]() ![]() ![]() ![]() ![]() |
![]() ![]() 16.67% |
6 |




16.67%

16.67%

16.67%

16.67%

16.67%