|
| |
| | SQL from FOLDOC |
 | | SQL was developed by IBM in the 1970s for use in System R. | | | The first SQL standard, in 1986, provided basic language constructs for defining and manipulating tables of data; a revision in 1989 added language extensions for referential integrity and generalised integrity constraints. | | | Development is currently underway to enhance SQL into a computationally complete language for the definition and management of persistent, complex objects. |
|
http://foldoc.org/foldoc/foldoc.cgi?SQL
(310 words)
|
|
| |
| | SQL Help and Tutorial |
| | SQL is the language used to access the data and structures within a relational database. | | | I have tried to keep the SQL examples as generic as possible and much of this information applies to any SQL RDBMS but some of this information is for an Oracle environment. | | | Each RDBMS has an inbuilt query optimiser which parses your SQL statements and works out the optimum path to the required data. |
|
http://www.ilook.fsnet.co.uk/ora_sql/sqlmain.htm#RIGHTS
(775 words)
|
|
| |
| | SQL Tutorial |
| | SQL also allows users to define the data in a database, and manipulate that data. | | | 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. | | | This document can be used for free by any Internet user, but cannot be included in another document, published in any other form, or mass produced in any way. |
|
http://www.geocities.com/SiliconValley/Vista/2207/sql1.html
(171 words)
|
|
| |
| | SQL Server Information at SQLTeam.com |
| | It does require SQL Server 2005 on the computer where it runs since it uses SMO to query the trace file. | | | It reads a trace file and summarizes the SQL to identify the statements and stored procedures that use the most resources. | | | It appears Microsoft won't be releasing a version that will read SQL Server 2005 trace files. |
|
http://www.sqlteam.com
(912 words)
|
|
| |
| | Java 2 Platform SE v1.3.1: Package java.sql |
| | In a typical implementation, the programmer would simply supply the name of the SQL UDT, the name of the class to which it is being mapped, and the names of the fields to which each of the attributes of the UDT is to be mapped. | | | A table of data representing a database result set, which is usually generated by executing a statement that queries the database. | | | Defining the class in the Java programming language to which the SQL UDT will be mapped. |
|
http://java.sun.com/j2se/1.3/docs/api/java/sql/package-summary.html
(1373 words)
|
|
| |
| | Quest : Products : SQL Navigator® : Overview |
| | SQL Navigator® is a PL/SQL development solution that streamlines workflow by adding a drag-and-drop, graphical user interface to the PL/SQL development environment. | | | The SQL Navigator® Suite includes all of the features and functionality of SQL Navigator Xpert plus DataFactory® Developer Edition, Benchmark Factory® for Databases and QDesigner™ PhysicalArchitect. | | | Optional Add-on Modules: Extend the reach of SQL Navigator with powerful add-ons designed to provide intelligence and optimize PL/SQL server-side development. |
|
http://www.quest.com/sql_navigator
(259 words)
|
|
| |
| | SQL Server Developer Center |
| | SQL Server 2005 Books Online has been updated with new information. | | | Download the SQL Server 2005 180-day trial software and start using its new features and enhanced capabilities today. | | | Hi I understand that I do not need to use /PAE on Windows Server 2003 x64bits as it is not supported. |
|
http://msdn.microsoft.com/sql
(845 words)
|
|
| |
| | SQL Server Database Coding Conventions, Best Practices and Programming Guidelines |
| | For example, if you create a table in SQL Server or a database that has a case-sensitive or binary sort order, all references to the table must use the same case that was specified in the CREATE TABLE statement. | | | Another major disadvantage of using dynamic SQL is that it requires users to have direct access permissions on all accessed objects, like tables and views. | | | In your applications, process all the results returned by SQL Server immediately so that the locks on the processed rows are released, hence no blocking. |
|
http://www.sql-server-performance.com/vk_sql_best_practices.asp
(2886 words)
|
|
| |
| | SQL Training - Online |
| | The SQL syntax and data types may be different in other databases but students would manage to learn them very quickly once they have the foundation knowledge gained from this SQL course. | | | Structured Query Language (SQL) is a very important data manipulation language. | | | In this course, students will learn how to use SQL to retrieve, store or update data in Microsoft Access. |
|
http://www.hwg.org/services/classes/sqltraining.html
(426 words)
|
|
| |
| | SecuriTeam™ - SQL Injection Walkthrough |
| | A SQL Injection attack is a result of manipulating the standard SQL query language (used by nearly all DB products), and bad coding practices by the web developer. | | | With SQL Injection, it is possible for us to send crafted user name and/or password field that will change the SQL query and thus grant us something else. | | | Being able to inject SQL command usually mean, we can execute any SQL query at will. |
|
http://www.securiteam.com/securityreviews/5DP0N1P76E.html
(3437 words)
|
|
| |
| | SQL Injection Attacks by Example |
| | For simple queries this might be only a minor benefit, but as the operations become more complicated (or are used in more than one place), having a single definition for the operation means it's going to be more robust and easier to maintain. | | | Though quotesafing is a good mechanism, we're still in the area of "considering user input as SQL", and a much better approach exists: bound parameters, which are supported by essentially all database programming interfaces. | | | If we get a server error, it means our SQL is malformed and a syntax error was thrown: it's most likely due to a bad field name. |
|
http://www.unixwiz.net/techtips/sql-injection.html
(4623 words)
|
|
| |
| | SourceCodeCentral.com |
| | Order By is used when we want to format the output of an sql query. | | | Primary keys are very important because they reduce the redundancy of data that is stored in a table. | | | In other words, the results of our query will be displayed in alphabetical order. |
|
http://www.sourcecodecentral.com/sql.asp
(591 words)
|
|
| |
| | SQLSecurity.com > Home |
| | Suddenly, you see a parameter being passed in a URL and throw a single quote up there just to see if the software is well written. | | | So far, SQLPing and SQLRecon don't seem to have any problem identifying the new SQL Server version assuming you have the appropriate level of host access for the selected scan types. | | | Both are in progress and should be operational shortly. |
|
http://www.sqlsecurity.com
(931 words)
|
|
| |
| | SQL Task |
| | The following connects to the database given in url as the sa user using the org.database.jdbcDriver and executes the SQL statements contained within the files data1.sql, data2.sql and data3.sql and then executes the truncate operation on some_other_table. | | | The following example does the same as (and may execute additional SQL files if there are more files matching the pattern | | | Connects to the database given in url as the sa user using the org.database.jdbcDriver and executes the two SQL statements inserting data into some_table and truncating some_other_table |
|
http://ant.apache.org/manual/CoreTasks/sql.html
(662 words)
|
|
| |
| | SQL Server Central - Microsoft SQL Server community with 334,613 Microsoft SQL Server users |
| | This project was done using SQL Server 2005 Enterprise Edition (with SP1 beta) using the BULK INSERT command with 60 parallel input files, each of approximately 16.67 GB. | | | The more granular scope of transactions, which now can be assigned to arbitrarily designated Control Flow tasks and containers, makes it is possible to limit their impact or execute several of them in parallel. | | | One of the major problems in the database field is when people store sensitive data unencrypted into SQL Server. |
|
http://www.sqlservercentral.com
(947 words)
|
|
| |
| | SQL in TutorGig Tutorials |
| | sql to vba creating vba recordsets from a query (a.k.a. | | | account new releases best sellers subjects publishers promotions articles log in microsoft sql server all 116 results: sort by: best match best seller title: a to z... | | | addition to the library of anyone that needs to work with sql. |
|
http://www.tutorgig.com/t/SQL
(848 words)
|
|
| |
| | SQL |
| | Although not as full-featured as some commercial tools, version 1.0 of SQL Developer, Oracle's free PL/SQL development IDE, is complete enough to use as the development platform for a complex PL/SQL project. | | | Using an index on a computed column, you can implement complex business rules or just give your SQL Server queries a performance boost. | | | Traditionally, database performance has been represented by the speed of data retrieval, but that is not always the case. |
|
http://www.devx.com/dbzone/Door/10616
(934 words)
|
|
| |
| | Oracle FAQ: SQL*Plus |
| | Use the "WHENEVER SQLERROR..." command to trap SQL and PL/SQL errors, and the "WHENEVER OSERROR..." to trap operating system errors. | | | If you are familiar with other databases, sqlplus is equivalent to "sql" in Ingres, "isql" in Sybase and SQLServer, "db2" in IBM DB2, "psql" in PostgresQL, and "mysql" in MySQL. | | | This will print an explain plan and high level trace information after your query results. |
|
http://www.orafaq.com/faqplus.htm
(1971 words)
|
|
| |
| | Comparison of different SQL implementations |
| | A start-pos of 1 is the first character in the input string. | | | As MySQL's namespaces don't match the SQL standard fully, the standard queries mentioned above will not work. | | | The goal of this page — which is a work in progress — is to gather information relevant for people who are porting SQL from one product to another and/or are interested in possibilities and limits of 'cross-product' SQL. |
|
http://troels.arvin.dk/db/rdbms
(6465 words)
|
|
| |
| | SQL Server Developer Center: T-SQL |
| | Find all you need to know about using Transact-SQL with SQL Server, from basics such as connecting to the database to advanced concepts like summarizing data. | | | In this introduction to SQL Server stored procedures for.NET developers, you’ll discover the pros and cons of using stored procedures, take a look at related Visual Studio.NET 2003 tools, and more. | | | Get more information on using Transact-SQL (T-SQL) to work with SQL Server data. |
|
http://msdn.microsoft.com/SQL/sqlreldata/TSQL/default.aspx
(469 words)
|
|
| |
| | Amazon.com: SQL Bible: Books: Alex Kriegel,Boris M. Trukhnov |
| | Whether you want to learn database programming from scratch, you’d like to sharpen your SQL skills, or you need to know more about programming for a heterogeneous database environment, this book provides the complete menu. | | | An example in code form is included for the command being referred to. | | | Tutorials and code examples in each chapter make it an indispensable reference for every level of expertise. |
|
http://www.amazon.com/exec/obidos/tg/detail/-/0764525840?v=glance
(1178 words)
|
|
| |
| | Database Journal: Daily Database News, Information and Tutorials for the Database Professional |
| | They built a business intelligence data warehouse hosted on Microsoft SQL Server 2005, resulting in the agility to identify problems faster, enhanced quality through use of non-warranty data, easier regulatory compliance, and lower TCO. | | | Intel Software can help you understand, optimize, and use multi-core technology to your advantage. | | | Learn how to use Dynamic Management Views and Functions and how you can simplify your ability to retrieve system information. |
|
http://www.databasejournal.com
(881 words)
|
|
| |
| | sql recovery - Database Recovery |
| | Third party SQL recovery and utility programs can cause damage beyond our ability to recover the files so please don't try anything on the original files. | | | For database repair and/or scavenging, it will save time if you can furnish us with the database structure (perhaps an empty database or backup) and a list of prioritized tables. | | | Most companies use RDBMS (relational database management system) and store their data in SQL databases. |
|
http://database-recovery.bloghi.com/2006/01/07/sql-recovery.html
(478 words)
|
|
| |
| | SQuirreL SQL Client Home Page |
| | SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc, see Introduction. | | | For all changes see Changelog, for an overview of all features see SQuirreL's help. | | | JFaceDbc is another SQL client tool which uses the low level SQL code from SQuirreL. |
|
http://squirrel-sql.sourceforge.net
(589 words)
|
|
| |
| | SQL Server Database Performance Tuning And Other Articles |
| | Audit for SQL injection, XSS and other web attacks with Acunetix Web Vulnerability Scanner. | | | If you don't want to receive these offers, you can opt out of them using your e-mail software. | | | Download any of Idera's tools for SQL Server before June 30 and be registered to win a Sony PSP with a Superhero game! |
|
http://www.sql-server-performance.com
(203 words)
|
|
| |
| | MySQL AB :: MySQL: The World's Most Popular Open Source Database |
| | In my first article on partitioning, I demonstrated that you can get some pretty impressive performance benefits when you properly design partitioned tables to match the SQL queries that are routinely shot across the bow of your database server. | | | I’d now like to continue in that vein and show you how easy and efficient partitioning is in terms of managing how partitions are created and removed within tables. |
|
http://dev.mysql.com
(351 words)
|
|
| |
| | Technorati Tag: sql |
| | SQL: HP Solutions HP StorageWorks Consolidation -Streamline Your Storage Environment. | | | Buy Microsoft SQL Server 2000 Microsoft SQL Server 2000 is the complete database and analysis offering for rapidly delivering the next generation of scalable e-commerce, line-of-business and data warehousing solutions. | | | Microsoft SQL Server 2005 Data management and analysis for your enterprise. |
|
http://www.technorati.com/tag/sql
(398 words)
|
|
| |
| | SQL Help, SQL Tutorials, SQL Programming, SQL Code, SQL Design |
| | Structured Query Language is a specialized language for sending queries to databases. | | | SQL Help, SQL Tutorials, SQL Programming, SQL Code, SQL Design | | | Developed by IBM, SQL, pronounced "sequel," originated on mainframes, but is now popular on PCs. |
|
http://www.devarticles.com/c/b/SQL
(558 words)
|
|
| |
| | Zlatko Michailov |
| | Therefore, a manager's job is to create and preserve a positive environment that stimulates good attitude and that creates incentives for commitment. | | | Z-SQL also implements some useful features typical to programming languages - defining script constants and types, and including other source files. | | | It utilizes the SQL Server schema/ownership model to create a new paradigm - package. |
|
http://michailov.freeservers.com
(580 words)
|
|
| |
| | SQL Support in Mozilla |
| | Be sure to read the bug writing guidelines so you can understand the process of filing a bug. | | | A web application no longer needs to pass information through a scripting language, such as Perl or Python, in order to receive information it can use. | | | There is a test app checked into the mozilla/extensions/sql/sqltest directory. |
|
http://www.mozilla.org/projects/sql
(178 words)
|
|
| |
| | SQLCourse2 - Advanced Online SQL Training |
| | Intel Software can help you understand, optimize, and use multi-core technology to your advantage. | | | This unique SQL Tutorial is the "sequel" to the highly successful SQLCourse.com site and will provide you with more advanced easy-to-follow SQL Instruction and the ability to practice what you learn on-line with immediate feedback! | | | This continuation course will provide you with critical need-to-know advanced features and clauses of the SELECT statement that weren't supported in the previous SQLCourse.com site. |
|
http://www.sqlcourse2.com
(170 words)
|
|
| |
| | SQLCourse - Interactive Online SQL Training for Beginners |
| | Learn about the importance of multi-port network adapters in a virtual server environment. | | | This unique introductory SQL tutorial not only provides easy-to-understand SQL instructions, but it allows you to practice what you learn using the on-line SQL interpreter. | | | You will be able to create your own unique tables as well as perform selects, inserts, updates, deletes, and drops on your tables. |
|
http://www.sqlcourse.com
(156 words)
|
|
| |
| | Oracle SQL |
| | before and after any SQL DDL (Data Definition Language) statement (even if this DDL statement fails). | | | Note that timing data may be affected by external factors such as system load, etc. | | | For each table, there can be only one |
|
http://www-db.stanford.edu/~ullman/fcdb/oracle/or-nonstandard.html
(1373 words)
|
|
| |
| | Hughes Technologies : The home of Mini SQL (mSQL) |
| | Changes include minor bug fixes and portability enhancements. | | | Mini SQL database OEM license application redistribution light weight embedded web server http library web server library http server httpd embedded scripting language embedded system develoment internet IP traffic monitoring billing ATM ethernet vpdn cisco SNMP ip acounting vlan | | | Bug fixes and new features in this release! |
|
http://www.hughes.com.au
(98 words)
|
|
|
