Group items matching
in title, tags, annotations or url
SQL Perl/PL Overview - 0 views
-
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.
What's New in SQL Server 2005-Enhancements for Data Base Administrators. - 0 views
-
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.
SQL Server 2005 - Service Broker - 0 views
-
The process of sending and receiving asynchronous messages by different processes in SQL Server 2005 is enabled by the Service Broker.
MySQL Tip: How To Check, Repair & Optimize All Tables in All Databases - 0 views
-
mysqlcheck uses the SQL statements CHECK TABLE, REPAIR TABLE, ANALYZE TABLE, and OPTIMIZE TABLE in a convenient way for the user.
How to start/stop MySQL server on Linux - 0 views
-
This will kill the mysqld process. However the best way to stop (because it stops properly) is obviously
How To Export MS Access Database To MySQL Database - 0 views
-
Here are few tips (with undocumented features) to help you export huge MS Access database (production database with real data) to MySQL
MySQL SQL Delete Notes - 0 views
-
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.
To make SQL Queries Case Sensitive - 0 views
-
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.
Getting all stored procedures from a database - 0 views
-
Here how you can get all the stored procedure from a database. Hey not only the name but the stored procedures definitions also.
Difference between TOP clause in SQL 2000 and SQL 2005 - 0 views
-
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.
SQL Keys - 0 views
-
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.
Microsoft links free SQL database with ASP .Net - 0 views
-
Microsoft is enabling its free SQL CE (SQL Server Compact Edition) database to work within ASP.Net Web applications, thus providing a lightweight database option for ASP.Net Web development
Stored Procedures in MySQL 5.0 - 0 views
-
MySQL 5.0 introduced Stored Procedures which allow us to automate or program our way out of many tasks on directly on the server rather than having to write external scripts to do complex manipulation of data.
MySQL 5.0 New Features: Triggers - 0 views
-
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.
MySQL 5.0 New Features: Data Dictionary - 0 views
-
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.
mySQL 5.0 New Features - 0 views
-
MySQL user who wants to know "what's new" in version 5. The short answer is "stored procedures, triggers, views, and information schema".
How To Process MySQL Timestamp in PHP - 0 views
-
Many of us do not realize that MySQL's Timestamp is not the timestamp which PHP date() understands. In fact if you try to use MySQL timestamp directly in php date() function then you will get totally wrong dates. There is a simple way to use MySQL timestamp data in php.
MySQL 5.5 Milestone 2 improves replication and stored procedures - 0 views
-
The MySQL developers have released milestone 2 of MySQL 5.5, on the path to a general release in mid-2010. The new milestone release incorporates semi-synchronous replication in MySQL 5.5 based on patches to InnoDB developed by Google.
MariaDB 5.1.44b Released - 0 views
-
MariaDB 5.1.44b Linux and Solaris binaries, Ubuntu/Debian/CentOS packages, and source are now available for download.
‹ Previous
21 - 40 of 57
Next ›
Showing 20▼ items per page