NEW LISTINGS 
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
Executing Transact-SQL DELETE statement
2529
Executing Transact-SQL DELETE statement
http://www.dotnetindex.com/read.asp?articleID=52
In this example, we will delete some records from a database. This source code helps us to deleting records to database without slowing down database.
ASP > Tips and Tutorials > Database-related
Oct 10, 2006
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
||
| Bookmark Executing Transact-SQL DELETE statement: |
|||
Other links at ASP > Tips and Tutorials > Database-related
This is called a singleton query. ADO.Net has specific functions for singleton queries, but not ADO (ActiveX Data Objects). This article describes how to use an ADO command object to perform faster singleton queries.
Category:
Allowing multiple choices of data elements enables people to customize views of your data and adds value to your applications. The following example utilizes our db on the career statistics of Hammerin? Hank Greenberg. The year and team he played with are already part of the sql request to the db. User inputted choice(s) are added to the basic sql statement to draw them from the db. Since the input from the dropdown menu comes through comma delimited it is simply written into the statement without modification. Two simple for next loops determine which elements are part of the record set and displays them accordingly.
Category:
Learn how to select a record from database. First we need to calculate how many records we have in our table. Using randomize function, we generate a random number between 0 to count of records in database.
Category:
So you want to learn ASP, well hopefully you will find some of the tutorials and articles in this section of Web Wiz Guide useful.
Category:
Now everybody can connect to a database. Simple database access is a huge feature of ASP and one of the most widely used by developers but when you are first learning, it's hard to separate the database stuff from the rest of the code so I made this example
Category:
Main Category
185
2034
801
286
174
1803
1129
909
1161
7393
70
905
59
2200
174
Join Mailing List
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.
Top 10
Directory Statistics
Links: 19263
Categories: 1275
Registered Users: 734
Mailing List Subscribers: 2043
Unique Outgoing Hits: 228297
Pagerank Statistics
PHP News