Add to Favorites    Make Home Page 33379 Online  
 Language Categories  
 Our Services  

ASP » Tips and Tutorials » Database-related » SQL In Simple English - Part 1

A D V E R T I S E M E N T

Search Projects & Source Codes:



Title SQL In Simple English - Part 1
Platform n/a
Price
Author Visit Author Website
Website Visit Website of - SQL In Simple English - Part 1
Category ASP » Tips and Tutorials » Database-related
Hits 524
Description Article describes what is SQL? what it is used for? how to SELECT, INSERT, UPDATE and DELETE records from the database? and more.

A D V E R T I S E M E N T




Google Groups Subscribe to SourceCodesWorld - Techies Talk
Email:

Free eBook - Interview Questions: Get over 1,000 Interview Questions in an eBook for free when you join JobsAssist. Just click on the button below to join JobsAssist and you will immediately receive the Free eBook with thousands of Interview Questions in an ebook when you join.


Scripts Related to - SQL In Simple English - Part 1

Script Name

Connecting to your SQL Database

If you have an SQL database set up with your web host, a useful tip to know is how to connect to your SQL database via Enterprise Manager. The advantage of knowing how to do this is that you will be able to manage your SQL Server database via Enterprise Manager over TCP/IP, yourself.

Real Time Data Grid Part 2/2

This article wraps up the details of the real time data grid that started in part one of this two-part article. It looks at the JavaScript code that contacts our database server and allows us to update data in a database without actually refreshing the page.

Real-Time Data Grid Part 1/2

The part one of this two-part article shows how to create an ASP class that allows us to work with our databases through a web browser. It will allow us to update and delete records dynamically using JavaScript and XMLHTTP, without ever having to refresh the page.

Creating DTS Packages With SQL Server 2000

Data Transformation Services (DTS) were added to SQL Server 7 and allow us to combine several data-related tasks into one common object. This article shows us how to create a DTS package with SQL Server 2000 that will access a database and email the results of a query to some sales executives. It also shows us how to execute and error trap DTS packages from within an ASP script.

Compact & Repair Access Database

Compact and repair your access database online from ASP code. This is example code of how this can be done.

Using MyODBC To Access Your MySQL Database Via ASP

MySQL is the most popular open source database system available today, and is currently installed on over two million servers worldwide. This article takes a look at using the free MyODBC driver to talk to a MySQL database from an ASP script.

Two Ways To Connect To SQL Server 2000 Via ASP

This article will show you two different methods that you can use to connect to a Microsoft SQL Server 2000 database: System DSN's and the OLEDB connection string. It will also explain the positives and negatives of each method, along with some examples to get you started.

Grabbing Data On The Fly

When we∆re querying a database, we will usually need to press a submit button on a form to pass data to another ASP page, which would generate the query, and return the results. In some situations, this page refresh is just plain annoying and takes too long to complete. This article will describe another way to query a database using a combination of web technologies.

Analyzing Duplicate Records

This is the first of the four-part "Advanced SQL Techniques" series, which describes a quick and efficient way to delete duplicate records from a table.

Using Triggers to Track Database Action History

This article describes how to use Microsoft SQL Server triggers to automatically record all updates and inserts for a particular database table in a customized history table.

Google Search

Google

Source Codes World.com is a part of Vyom Network.

Vyom Network : Web Hosting | Dedicated Server | Free SMS, GRE, GMAT, MBA | Online Exams | Freshers Jobs | Software Downloads | Interview Questions | Jobs, Discussions | Placement Papers | Free eBooks | Free eBooks | Free Business Info | Interview Questions | Free Tutorials | Arabic, French, German | IAS Preparation | Jokes, Songs, Fun | Free Classifieds | Free Recipes | Free Downloads | Bangalore Info | Tech Solutions | Project Outsourcing, Web Hosting | GATE Preparation | MBA Preparation | SAP Info | Software Testing | Google Logo Maker | Freshers Jobs

Sitemap | Privacy Policy | Terms and Conditions
Copyright ©2003-2019 SourceCodesWorld.com, All Rights Reserved.
Page URL: http://www.sourcecodesworld.com/scripts/SQL-In-Simple-English-Part-1-2394/Default.asp


Download Yahoo Messenger | Placement Papers | Free SMS | C Interview Questions | C++ Interview Questions | Quick2Host Review


 Advertisements