ASP & Writing a Stored Procedure  - This article is designed to tell you how to begin writing stored procedures and then how to call them via ASP. I am using
Microsoft SQL Server 7.0, but these examples should work in any SQL version. URL: http://www.4guysfromrolla.com/webtech/111499-1.shtml
|
|
Avoiding Bottlenecks with Temporary Tables - Were you aware that the act of populating a SQL Server temporary table can cause system-wide performance bottlenecks on your server? Problems can occur both with SQL Server 6.5 and 7.0 in different ways, and in this article I will discuss how best to avoid them. URL: http://www.sql-server-performance.com/nb_avoid_bottlenecks.asp
|
|
Database Developer's Guide with Visual Basic 4, Second Edition - This revised and updated edition of a bestseller shows developers how to optimize their applications for desktop and client/server databases, write queries in ANSI SQL and Access SQL with Visual Basic code, and create front end databases using MIDI forms.
Disk contains a data dictionary application, cross tab query generator, multiform graphical front end, and DDE and OLE applications with Excel 5.
Provides in-depth coverage of networking issues surrounding databases.
Explains how to use third-party, data-aware custom controls to add flexibility to applications URL: http://www.cs.tuiasi.ro/library/vbdbase/index.htm
|
|
Dealing with apostrophes in SQL strings - If you are using SQL strings in your database operations, chances are you have come across problem with strings in SQL statement. One apostrophe screws up the SQL string, causing the SQL statement to fail. URL: http://www.kamath.com/codelibrary/cl003_apostrophe.asp
|
|
Eliminate the Use of Temporary Tables For HUGE Performance Gains - As queries become more complex, temporary tables are used more and more. While temporary table may sometimes be unavoidable, they can often be sidestepped by using derived tables instead. In brief, a derived table is the result of using another SELECT statement in the FROM clause of a SELECT statement. By using derived tables instead of temporary tables, we can boost our application's performance. Let's find out more. URL: http://www.sql-server-performance.com/jg_derived_tables.asp
|
|
How to Join Multiple SQL Tables - This time around, we’re focusing on the core of relational databases, that is, joining multiple tables together by their key fields to create different views of sets of data. In essence, we’re going to take the language tools introduced in the last installment and use them to do real work. URL: http://webreview.com/pub/2000/02/25/dbdev/index.html
|
|
How to Join Multiple SQL Tables - Part 2: Types of Joins - There are three types of table joins in SQL, all of which derive from matrix algebra (you may occasionally hear terms like "the Cartesian product of two tables"). I’ll cut the suspense and list them here followed by a brief discussion of each. Inner join; Outer join (left and right); Self join. URL: http://webreview.com/pub/2000/02/25/dbdev/index2.html
|
|
How to Profile Transact-SQL Code in Stored Procedures and Triggers - Profiling is used to tune code to make it more efficient or faster. Profiling is done by timing and counting the number of times a piece of code is executed, and recording the results so that the slow parts of the code can be identified. Then the code can be rewritten to be faster and more efficient. Profiling Transact-SQL code in SQL Server is sometimes difficult. However, profiling can provide the following information, which is sometimes necessary: URL: http://support.microsoft.com/support/kb/articles/Q172/1/17.asp
|
|
Inquiry.com: Ask the SQL Server Pro - Inquiry.com helps software developers and IT professionals get answers to tough development questions. Inquiry.com's Ask the Pros family of technical Q and A forums match users with technical experts and peers. Use of inquiry.com is free. URL: http://www.inquiry.com/techtips/thesqlpro/
|
|
Precision, Scale, and Length (T-SQL) - Precision is the number of digits in a number. Scale is the number of digits to the right of the decimal point in a number. The number 123.45 has a precision of 5 and a scale of 2. Length for a numeric data type is the number of bytes used to store the number. Length for a character string or Unicode data type is the number of characters. The length for binary, varbinary, and image data types is the number of bytes. The int data type has a precision of 10, a length of 4, and a scale of 0. The precision and scale of the numeric data types besides decimal are fixed. The rules of data type precedence define the data type of the result. The precision and scale for any expression that is not decimal is the precision and scale defined for the data type of the expression. The result precision and scale have an absolute maximum of 38. When a result precision is greater than 38, the corresponding scale is reduced to prevent the integral part of a result from being truncated. URL: http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/da-db_3.htm
|
|
Put Advanced SQL Server Features To Work - SQL is the lingua franca of server-side Web data apps. Some of the advanced features of SQL joins, views, rankings, and computed columns can drastically simplify your code. URL: http://www.microsoft.com/mind/0399/advSQLfeatures/advSQLfeatures.htm
|
|
SQL Glossary - UCSD - Glossary of SQL terms and concepts. URL: http://www-act.ucsd.edu/trn/datawhse/glossary.html
|
|
SQL Index - Just wanted to let you all know about a neat, new web site, SQL Index. SQL Index is similar to ASP-In, except SQL Index is an index of on-line SQL references. If you have questions about SQL, or are looking for answers to your
questions, be sure to visit SQL Index to find SQL information on the Net! URL: http://www.sqlindex.com/
|
|
SQL Queries Explained - The definitive quick-n-dirty SQL query reference. URL: http://asp-help.com/database/db_sql.asp
|
|
SQL Server Professional: December 2000 - Tip: Derived Tables - Have you ever used derived tables? If not, you might want to consider them. A derived table is simply a table that contains the results of a query. It's similar to a view, but it's not created and stored in the database. Encapsulated within the SELECT statement, it's dynamic and temporal. To use a derived table, define a query (SELECT statement) and give it an alias name. The SELECT statement can't contain INTO, ORDER BY, COMPUTE, or COMPUTE BY clauses. URL: http://www.pinnaclepublishing.com/SQ/SQmag.nsf/WebIndexOfFreeTips/14776FD31CF42B99852569A7007E4B52?opendocument
|
|
SQL Tutorial: Introduction to Structured Query Language - This page is a tutorial of the Structured Query Language (also known as SQL) and is a pioneering effort on the World Wide Web, as this is the first comprehensive SQL tutorial available on the Internet. SQL allows users to access data in relational database management systems, such as Oracle, Sybase, Informix, Microsoft SQL Server, Access, and others, by allowing users to describe the data the user wishes to see. SQL also allows users to define the data in a database, and manipulate that data. This page describes how to use SQL, and gives examples. The SQL used in this document is "ANSI", or standard SQL, and no SQL features of specific database management systems will be discussed until the "Nonstandard SQL" section. URL: http://w3.one.net/~jhoffman/sqltut.htm
|
|
SQLTeam.com: Temporary Tables - Creating SQL Server Temporary Tables. URL: http://www.sqlteam.com/item.asp?ItemID=2029
|
|
Stump the SQL Guru! - Got a tough SQL question that you think no one can answer? Well, now's your chance to ask away, because we have a bonefide, genuine SQL master who's ready to answer your most difficult questions. His name is Sean Baird, and he's coauthored four books on SQL Server. URL: http://www.4guysfromrolla.com/webtech/sqlguru/
|
|
Surviving SQL - SQL is by far the most popular query language for databases today. Microsoft Access provides a surprisingly powerful implementation of SQL for a desktop database. SQL provides a powerful way to ask computationally complex questions of a database using relatively concise descriptive expressions. That is, assuming that the database was organized following the principles of relational design. If the database is poorly designed, and there are a lot of them, then surviving SQL can truly be a harrowing prospect. On the other hand, a thoughtful design will allow even novice SQL users to easily retrieve useful information from a database.
Contents: Using Indexes Effectively; Null < = > + - * / % \ Null Is Null; Key Issues; Programming Access Dates (in ...Eternity (Almost)). URL: http://www.accesshelp.net/survival/sursql.cfm
|
|
T-SQL Datatypes - In Microsoft® SQL Server™, each column, local variable, expression, and parameter has a data type. The set of system-supplied data types is shown below. User-defined data types, which are aliases for system-supplied data types, can also be defined. For more information about user-defined data types, see sp_addtype and Creating User-defined Data Types. URL: http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/da-db_1.htm
|
|
T-SQL Functions - The Transact-SQL programming language provides three types of functions: Rowset functions.)
Can be used like table references in an SQL statement. For more information about a list of these functions, see Rowset Functions. Aggregate functions.) Operate on a collection of values but return a single, summarizing value. For more information about a list of these functions, see Aggregate Functions. Scalar functions.) Operate on a single value and then return a single value. Scalar functions can be used wherever an expression is valid. URL: http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/fa-fz_15.htm
|
|
The WDVL: Introduction to Databases for the Web - Great General Reference covering: Retrieving Data, Wildcards, Where, [And, Or, and Not], Between, In, Like, Null, Order by, Performing math, Maximums and Minimums, Counting Records, Distinct, Averages, Joins, Subquerries, Adding Data, Modifying Data, and Deleting Data. URL: http://wdvl.internet.com/Authoring/DB/Intro/toc.html
|
|
Use New SQL Server 2000 Datatypes - SQL Server 2000's three new datatypes help you store data in new ways. URL: http://www.vbpj.com/upload/free/features/vbpj/2000/11nov00/ss0011/ss0011.asp
|
|
Using Stored Procedures in SQL Server - If you’re a programmer, you know that SQL is becoming more and more prevalent. Here’s a guide to one of its basic building blocks the stored procedure. URL: http://www.microsoft.com/mind/0399/sql/sql.htm
|
|
What are the SQL reserved words? - I grep'd the following list out of the sql docs available via anonymous ftp to speckle.ncsl.nist.gov:/isowg3. SQL3 words are
not set in stone, but you'd do well to avoid them. URL: http://epoch.cs.berkeley.edu:8000/sequoia/dba/montage/FAQ/SQL.html#SQL4
|
|
ZDNET d e v h e a d: SQL: The Universal Database Language - An introduction to creating and manipulating relational databases. URL: http://www.zdnet.com/devhead/stories/articles/0,4413,355971,00.html
|
Acrobat
MS Word
Excel
PowerPoint
WordPerfect
Zip File
Accessibility · Disclaimer · Website
Privacy Policy · Freedom
of Information Act · Kid's Page · Contact 