To make SQL Queries Case Sensitive - 0 views
-
adie afton on 20 Aug 12To make SQL Queries Case Sensitive using Collation.You can make SQL Queries Case sensitive at the column level or Table level or DataBase level.
Group items matching
in title, tags, annotations or url
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.
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 - 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 Get CONSTRAINT of Database or Table - 1 views
-
In this post, we are going to explain how you can list all CONSTRAINT of database or table in SQl Server. When you are working on database sometimes you need to check or get the CONSTRAINT on database or table. Using below given query we can get the CONSTRAINT of table or database quickly.
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.
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
-
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 - 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". The long answer is the MySQL 5.0 New Features series, and this book is the third in that series.
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.
Reporting Services - 0 views
-
Reporting Services is a Web service-based solution for designing, deploying, and managing flexible, dynamic Web-based reports, as well as traditional paper reports. These reports can contain information from virtually any data source.
Analysis Services - 0 views
-
Analysis Services delivers Online Analytical Processing (OLAP) and Data Mining functionality for business intelligence applications.
Top 10 PostgreSQL Performance Optimization Tips - 0 views
-
PostgreSQL performance optimization is a widely discussed issue on the most forums. Although PostgreSQL is shipped with a solid default configuration aimed to fit most setups, it requires fair amount of performance optimization to offer the best.
Database files in SQL Server 2000 - 0 views
-
SQL Server 2000 allows three types of database files
Data Types in SQL Server - 0 views
-
Data type means the type of data which users provided to specific column in Sql Server
‹ Previous
21 - 40 of 43
Next ›
Showing 20▼ items per page