Skip to main content

Home/ Software Tutorials for Visual Learners/ Group items tagged database

Rss Feed Group items tagged

adie afton

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
Hostforlife Hosting

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.
adie afton

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
adie afton

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.
adie afton

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.
adie afton

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, a Microsoft official said this week.
adie afton

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.
adie afton

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.
adie afton

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.
adie afton

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.
adie afton

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.
adie afton

Database files and File groups - 0 views

  •  
    A database file is nothing but an Operating system file. A database spans at least two, and possible several database files.
adie afton

SQL Server 2008's Database Engine - 0 views

  •  
    The Database Engine is the primary component of SQL Server 2008. It is the Online Transaction Processing (OLTP) engine for SQL Server, and has been improved and enhanced tremendously in this version.
adie afton

Top 7 Free Open Source Database Server - 0 views

  •  
    After an extensive research we sorted out the top 7 Open Source Server based database management systems, have a look.
adie afton

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.
adie afton

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

  •  
    Here is a simple command to auto repair, check and optimize all the tables in all databases running on a MySQL server:
anoosha234

SQL server dba online course Bangalore | best opportunity to prove your self - 0 views

  •  
    SQL Database is Microsoft's Database as a service offering.This course will help you take advantage of your existing SQL Server Skills and learn about managing.we are providing SQL Server DBA online course Bangalore. Learn Sql server dba Online course Bangalore with the help of experienced faculty and Get a Practical Knowledge with Real Time Project support and settle for a job with Job Placement assistance, Contact 9550102466
adie afton

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
adie afton

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.
adie afton

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.
1 - 20 of 45 Next › Last »
Showing 20 items per page