|
 Home : Computers & Internet : Databases : SQL
 A Brief SQL Tutorial
This introductory tutorial is aimed to teach beginners the building blocks of SQL, Structured Query Language.
A Gentle Introduction to SQL
An interactive introduction to SQL. Type in the query and get the answer!
Accessing Identity Values
How to access the value of an identity column after inserting a row into a table.
Adding Discussion Forums using SQL Server & ASP
Part II of our Community Building Series provides shows you how to implement discussion forums.
Adding Site Registration using SQL Server & ASP
We show you how to quickly and easily add site registration to your web-site.
An Efficient String Concatenation Component
This tutorial is aimed toward ASP/SQL developers who are looking to help speed the concatenation of strings, such as SQL query strings.
Building Input Lists From Your Database
A simple ASP script that generates input lists from a database recordset.
Case Sensitive Comparison in SQL Server
It is not uncommon that you need to write a query to do case sensitive comparison in SQL Server. Here is the solution of how to do case sensitive comparison in case insensitive SQL Server becomes.
Common SQL Server Tricks
For SQL Server there are certain things that we often overlook or just take them for granted. Below I will try to show a few things that you must take note when you design and program for your database.
Constraint Failures in Transactions
Show how failure of a constraint affects a multiple-statement transaction declared by the user. The biggest misconception is that any error, such as a constraint failure, automatically aborts and rolls back the entire transaction. Rather, after an error is raised, it`s up to the transaction to either proceed and ultimately commit, or to roll back.
Creating Databases and Tables in SQL
Just getting started with the Structured Query Language? This tutorial walks you through the process of creating tables and databases in SQL databases.
Database transfer to webserver
How to transfer database to the web server from the development site.
Databases and Data Access: A Primer
Basic database concepts, connecting to a database, understanding the Recordset object.
Display a searchable table from most any valid SQL statement
I will provide a function that will display a sortable, paged table with boolean searching on all fields. Also included will be the ability to export data to an excel spreadsheet. The article will explain how to use and customize the functions.
Email from MS SQL using CDO
Lets you send simple email message from MSSQL using CDO.
How to Do SQL Server Log Shipping
This tutorial explains log shipping and how to implement it in Microsoft SQL Server 7.0.
Implementing SQL Server in an OLTP Environment
Learn the basics of how to performance tune OLTP applications in Microsoft SQL Server.
Importing Log
The focus of this tutorial is on how to store Performance Monitor data in Microsoft SQL Server.
Interactive SQL Tutorial with Live Practice Database
This unique tutorial allows one to practice what they learn on-line with immediate feedback. Users can create their own unique tables, perform inserts, updates, deletes, selects, drops, etc. Use the skills learned here with any SQL database such as Oracle, SQL Server, Sybase, Informix, mySQL, Access, etc.
Introduction to Microsoft SQL Server Performance
Learn the fundamentals of Microsoft SQL Server performance tuning.
Introduction to SQL Queries Part 1
This article (part 1 of a multi-part series on SQL Queries) introduces the SQL SELECT Statement to those who have little or no knowledge of SQL.
Learn SQL by Easy Examples. Find everything about SQL.
Learn SQL with easy examples. An easy introductory SQL tutorial with SQL Compiler-Interpreter & Live Database
Open any table up for complete modification!
This function will open up any table for complete modification with one function call. Searchable and sortable table with automatically generated and validated forms!
Part 2 of 3 - The ADO recordset, and UPDATEs
Using ADO and the SQL UPDATE method to update a record.
Professional SQL Server 2000 Programming Part 1 - Simple Views
The syntax for a view, in its most basic form, is a combination of the basic CREATE statement, plus a SELECT statement.
Professional SQL Server 2000 Programming Part 2 - More Complex Views
Even though I use the term "complex" here - don`t let that scare you. The toughest thing in views is still, for the most part, simpler than most other things in SQL.
Professional SQL Server 2000 Programming Part 3 - Editing Views
The main thing to remember when you edit views with T-SQL is that you are completely replacing the existing view.
Professional SQL Server 2000 Programming Part 4 - Auditing: Displaying Existing Code
What do you do when you have a view, but you`re not sure what it does? The first option should be easy at this point - just go into EM like you`re going to edit the view.
Professional SQL Server 2000 Programming Part 5 - Protecting Code: Encrypting Views
If you`re building any kind of commercial software product, odds are that you`re interested in protecting your source code. Views are the first place we see the opportunity to do just that.
Professional SQL Server 2000 Programming Part 6 - Indexed (Materialized) Views
This one is brand new with SQL Server 2000 and is, unfortunately, only supported in the Enterprise Edition (OK, the Developer and Evaluation Editions also support it, but you aren`t allowed to use these in production systems). Simply put, this is a spectacular new feature.
Sending an Automated Newsletter
We show you how we are automating our weekly newsletter.
Setting Up A Data Source Name (DSN) for SQL 6.5
Creating a DSN is the first step for any ASP process that accesses a database. In this example we use a MS SQL 6.5 database.
SQL Fundamentals
The Structured Query Language provides the foundation for all relational database systems. Join us as we explore the fundamental concepts behind this powerful language.
SQL Reference
The complete SQL reference for the ASP newbie.
SQL School
After you have studied this school you will know what SQL is, and how to use it.
SQL Server Lock Contention
Learn everything about SQL Server Lock Contention Tamed: The Joys Of NOLOCK and ROWLOCK in this in tutorial.
SQL Tutorial by Josh Grant
An SQL tutorial that teaches you by example. You will work with the same database throughout the tutorial.
Updating tables across a many-to-many relationship
Learn about updating tables across a many-to-many relationship.
Uploading & Retrieving images from SQL Server with ASP
Need to have your users upload files into your database, then need to display them back? Too many articles focus on one part or the other - this article will give you the whole nine, code and all.
Using COM DLLs in SQL Server
T-SQL is great, but it has lots of limitation. Sometimes, you may want your stored procedures to do some complicated jobs, such as file manipulation, complex math calculations, using Windows API functions, and etc. T-SQL can not do this for you.
Using Performance
This is part one of a four part series on how to use the Performance Monitor to track Microsoft SQL Server Performance. The focus of this tutorial is on how to use Performance Monitor.
Using sets in SQL Server
Sets are a nice way to simplify your code by breaking it down into logical sections. They can be used in the SELECT, FROM, and WHERE clauses to create a dataset that could otherwise only be created with a very complex SQL query.
Using SQL to Write VB Code for You
When you`re writing a COM object or VB application to interface with SQL stored procedures, there`s often a lot of typing to define command parameters. Here`s some T-SQL code to write the code for you!
© Copyright 2005 CoolGrandma.com
|
Arts & Humanities
