Contents contributed and discussions participated by adie afton - Software Tutorials for Visual Learners

MySQL 5.0 New Features: Triggers - 0 views

sqlserver-guide.blogspot.in/...-50-new-features-triggers.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached

adie afton on 20 Aug 12

Whenever I want to show actual code, such as something that comes directly from the screen of my mysql client program, I switch to a Courier font, which looks different from the regular text font.

<div class="cArrow"> </div><div class="cContentInner">Whenever I want to show actual code, such as something that comes directly from the screen of my mysql client program, I switch to a Courier font, which looks different from the regular text font. </div>

...

Cancel

MySQL 5.0 New Features: Data Dictionary - 0 views

sqlserver-guide.blogspot.in/...-features-data-dictionary.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached

adie afton on 20 Aug 12

MySQL now has a new "database" named INFORMATION_SCHEMA. It is a virtual database only; there will never be a need to create a file by that name, and the MySQL server itself creates and populates the tables therein.

<div class="cArrow"> </div><div class="cContentInner">MySQL now has a new "database" named INFORMATION_SCHEMA. It is a virtual database only; there will never be a need to create a file by that name, and the MySQL server itself creates and populates the tables therein. </div>

...

Cancel

mySQL 5.0 New Features - 0 views

sqlserver-guide.blogspot.in/...mysql-50-new-features.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached

adie afton on 20 Aug 12

MySQL user who wants to know "what's new" in version 5. The short answer is "stored procedures, triggers, views, and information schema".

<div class="cArrow"> </div><div class="cContentInner">MySQL user who wants to know "what's new" in version 5. The short answer is "stored procedures, triggers, views, and information schema". </div>

...

Cancel

MySQL Tip: How To Check, Repair & Optimize All Tables in All Databases - 0 views

sqlserver-guide.blogspot.in/...-to-check-repair-optimize.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached

adie afton on 20 Aug 12

mysqlcheck uses the SQL statements CHECK TABLE, REPAIR TABLE, ANALYZE TABLE, and OPTIMIZE TABLE in a convenient way for the user.

<div class="cArrow"> </div><div class="cContentInner">mysqlcheck uses the SQL statements CHECK TABLE, REPAIR TABLE, ANALYZE TABLE, and OPTIMIZE TABLE in a convenient way for the user. </div>

...

Cancel

How to start/stop MySQL server on Linux - 0 views

sqlserver-guide.blogspot.in/...top-mysql-server-on-linux.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached

adie afton on 20 Aug 12

This will kill the mysqld process. However the best way to stop (because it stops properly) is obviously

<div class="cArrow"> </div><div class="cContentInner">This will kill the mysqld process. However the best way to stop (because it stops properly) is obviously </div>

...

Cancel

How To Export MS Access Database To MySQL Database - 0 views

sqlserver-guide.blogspot.in/...ort-ms-access-database-to.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached

adie afton on 20 Aug 12

Here are few tips (with undocumented features) to help you export huge MS Access database (production database with real data) to MySQL

<div class="cArrow"> </div><div class="cContentInner">Here are few tips (with undocumented features) to help you export huge MS Access database (production database with real data) to MySQL </div>

...

Cancel

MySQL SQL Delete Notes - 0 views

sqlserver-guide.blogspot.in/...mysql-sql-delete-notes.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached

adie afton on 20 Aug 12

To delete duplicates from a MySQL database table I normally copy the duplicate data first to a temporary table and then use the copied id's to delete from the original table.

<div class="cArrow"> </div><div class="cContentInner">To delete duplicates from a MySQL database table I normally copy the duplicate data first to a temporary table and then use the copied id's to delete from the original table. </div>

...

Cancel

To make SQL Queries Case Sensitive - 0 views

sqlserver-guide.blogspot.in/...ql-queries-case-sensitive.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached

adie afton on 20 Aug 12

To make SQL Queries Case Sensitive using Collation.You can make SQL Queries Case sensitive at the column level or Table level or DataBase level.

<div class="cArrow"> </div><div class="cContentInner">To make SQL Queries Case Sensitive using Collation.You can make SQL Queries Case sensitive at the column level or Table level or DataBase level. </div>

...

Cancel

Getting all stored procedures from a database - 0 views

sqlserver-guide.blogspot.in/...ll-stored-procedures-from.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached

adie afton on 20 Aug 12

Here how you can get all the stored procedure from a database. Hey not only the name but the stored procedures definitions also.

<div class="cArrow"> </div><div class="cContentInner">Here how you can get all the stored procedure from a database. Hey not only the name but the stored procedures definitions also. </div>

...

Cancel

Difference between TOP clause in SQL 2000 and SQL 2005 - 0 views

sqlserver-guide.blogspot.in/...between-top-clause-in-sql.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached

adie afton on 20 Aug 12

Generally TOP clause is used to perform SELECT on top n results. This feature of TOP is extended in SQL 2005 so that we can also use expression apart from int, bigint and percent to perform query and also extended to be used in UPDATE and DELETE statements.

<div class="cArrow"> </div><div class="cContentInner">Generally TOP clause is used to perform SELECT on top n results. This feature of TOP is extended in SQL 2005 so that we can also use expression apart from int, bigint and percent to perform query and also extended to be used in UPDATE and DELETE statements. </div>

...

Cancel

SQL Keys - 0 views

sqlserver-guide.blogspot.in/...sql-keys.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached

adie afton on 20 Aug 12

In SQL, keys are used to maintain referential integrity among relations. Put simply, this means keys allow tables to reference each other, and each reference will be "correct" every time.

<div class="cArrow"> </div><div class="cContentInner">In SQL, keys are used to maintain referential integrity among relations. Put simply, this means keys allow tables to reference each other, and each reference will be "correct" every time. </div>

...

Cancel

SQL Perl/PL Overview - 0 views

sqlserver-guide.blogspot.in/...sql-perlpl-overview.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached

adie afton on 20 Aug 12

The following examples make use of PostgreSQL's implementation of PL/Perl, but the examples should be relevant and similar to other procedural language extensions in most databases that support such additions.

<div class="cArrow"> </div><div class="cContentInner">The following examples make use of PostgreSQL's implementation of PL/Perl, but the examples should be relevant and similar to other procedural language extensions in most databases that support such additions. </div>

...

Cancel

What's New in SQL Server 2005-Enhancements for Data Base Administrators. - 0 views

sqlserver-guide.blogspot.in/...whats-new-in-sql-server.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached

adie afton on 20 Aug 12

The SQL Server Management Studio is a one point access to a number of services - the relational database, the Integration services, Analysis services, Reporting services, Notification Services and SQL Mobile.

<div class="cArrow"> </div><div class="cContentInner">The SQL Server Management Studio is a one point access to a number of services - the relational database, the Integration services, Analysis services, Reporting services, Notification Services and SQL Mobile. </div>

...

Cancel

SQL Server 2005 - Service Broker - 0 views

sqlserver-guide.blogspot.in/...erver-2005-service-broker.html

sql db2 database design structured query language database 'mysql opensource server 2000 ms microsoft programming mySQL guide

shared by adie afton on 20 Aug 12 - No Cached

adie afton on 20 Aug 12

The process of sending and receiving asynchronous messages by different processes in SQL Server 2005 is enabled by the Service Broker.

<div class="cArrow"> </div><div class="cContentInner">The process of sending and receiving asynchronous messages by different processes in SQL Server 2005 is enabled by the Service Broker. </div>

...

Cancel

Why Software Engineers Use Interface Testing - 0 views

adie afton on 19 Aug 12

In software development, testing is a crucial part of the whole process. Many software engineers have considered interface testing as one of the most important tests they have to conduct in order to guarantee the quality of their products.

<div class="cArrow"> </div><div class="cContentInner">In software development, testing is a crucial part of the whole process. Many software engineers have considered interface testing as one of the most important tests they have to conduct in order to guarantee the quality of their products. </div>

...

Cancel

Frame Work - 0 views

adie afton on 19 Aug 12

Frame work is a Generic work designed by an expert and followed by many people to perfom a particular task in an effective , efficient and optimized way.

<div class="cArrow"> </div><div class="cContentInner">Frame work is a Generic work designed by an expert and followed by many people to perfom a particular task in an effective , efficient and optimized way. </div>

...

Cancel

Modular Frame work - 0 views

adie afton on 19 Aug 12

This is also a general frame work that can be used by some people.

<div class="cArrow"> </div><div class="cContentInner">This is also a general frame work that can be used by some people. </div>

...

Cancel

Batch testing - 0 views

adie afton on 19 Aug 12

Batch testing is a process of executing a group of tests at a time.

<div class="cArrow"> </div><div class="cContentInner">Batch testing is a process of executing a group of tests at a time. </div>

...

Cancel

Keyword Driven frame work - 0 views

adie afton on 19 Aug 12

This is also a general frame work that can be used by most of people.

<div class="cArrow"> </div><div class="cContentInner">This is also a general frame work that can be used by most of people. </div>

...

Cancel

Software Interface Testing and Other Types of Software Testing - 0 views

adie afton on 19 Aug 12

Software interface testing is just one among the many types of software testing that are used by software engineers for software development. Automated testing is one of the most common software test approaches these days. With this, engineers would not have to perform tests or quality assurance manually.

<div class="cArrow"> </div><div class="cContentInner">Software interface testing is just one among the many types of software testing that are used by software engineers for software development. Automated testing is one of the most common software test approaches these days. With this, engineers would not have to perform tests or quality assurance manually. </div>

...

Cancel