- ALTER the Database in SQL
ALTER the Database in SQL
in SQL with 2000 database db2 design language microsoft ms mysql opensource programming query server sql structured
- Analysis Services
Analysis Services delivers Online Analytical Processing (OLAP) and Data Mining functionality for business intelligence applications.
in Public bookmarks with 2000 database db2 design language microsoft ms mysql opensource programming query server sql structured
- create a TABLE in SQL
create a TABLE in SQL and Sytax
in SQL with 2000 database db2 design language microsoft ms mysql opensource programming query server sql structured
- Crystal Reports - Geterogeneus databases: SQL Server, Oracle, Unidata, Btrieve – tips for developer
MySQL user who wants to know "what's new" in version 5. The short answer is "stored procedures, triggers, views, and information schema".
in Public bookmarks with 2000 database db2 design language microsoft ms mysql opensource programming query server sql structured
- Data Definition Language
" Data definition level language which includes the following statements. A) CREATE Statement B) ALTER Statement C) DROP Statement D) TRUNCATE Stat "
in SQL with 2000 database db2 design language microsoft ms mysql opensource programming query server sql structured
- Data Types in SQL Server
Data type means the type of data which users provided to specific column in Sql Server
in SQL with 2000 database db2 design language microsoft ms mysql opensource programming query server sql structured
- Database file properties in SQL
Each database file has five properties
in SQL with 2000 database db2 design language microsoft ms mysql opensource programming query server sql structured
- Database files and File groups
A database file is nothing but an Operating system file. A database spans at least two, and possible several database files.
in SQL with 2000 database db2 design language microsoft ms mysql opensource programming query server sql structured
- Database files in SQL Server 2000
SQL Server 2000 allows three types of database files
in SQL with 2000 database db2 design language microsoft ms mysql opensource programming query server sql structured
- Difference between TOP clause in SQL 2000 and SQL 2005
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.
in Public bookmarks with 2000 database db2 design language microsoft ms mysql opensource programming query server sql structured
- DROP DATABASE DATABASENAME in SQL
DROP DATABASE DATABASENAME in SQL
in SQL with 2000 database db2 design language microsoft ms mysql opensource programming query server sql structured
- Getting all stored procedures from a database
Here how you can get all the stored procedure from a database. Hey not only the name but the stored procedures definitions also.
in Public bookmarks with 2000 database db2 design language microsoft ms mysql opensource programming query server sql structured
- How To Export MS Access Database To MySQL Database
Here are few tips (with undocumented features) to help you export huge MS Access database (production database with real data) to MySQL
in Public bookmarks with 2000 database db2 design language microsoft ms mysql opensource programming query server sql structured
- How To Process MySQL Timestamp in PHP
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.
in Public bookmarks with 2000 database db2 design language microsoft ms mysql opensource programming query server sql structured
- How to start/stop MySQL server on Linux
This will kill the mysqld process. However the best way to stop (because it stops properly) is obviously
in Public bookmarks with 2000 database db2 design language microsoft ms mysql opensource programming query server sql structured
- Integration Services
SQL Server Integration Services (SSIS) is Microsoft’s new enterprise class data Extract, Transform, and Load (ETL) tool. SSIS is a completely new product built from the ashes of SQL Server 2000’s Data Transformation Services (DTS).
in Public bookmarks with 2000 database db2 design language microsoft ms mysql opensource programming query server sql structured
- MariaDB 5.1.44b Released
MariaDB 5.1.44b Linux and Solaris binaries, Ubuntu/Debian/CentOS packages, and source are now available for download.
in Public bookmarks with 2000 database db2 design language microsoft ms mysql opensource programming query server sql structured
- Microsoft links free SQL database with ASP .Net
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
in Public bookmarks with 2000 database db2 design language microsoft ms mysql opensource programming query server sql structured
- MySQL 5.0 New Features: Data Dictionary
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.
in Public bookmarks with 2000 database db2 design language microsoft ms mysql opensource programming query server sql structured
- MySQL 5.0 New Features: Triggers
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.
in Public bookmarks with 2000 database db2 design language microsoft ms mysql opensource programming query server sql structured
Next »
opensource from all users