Display :
Did not find what you want,
Be the first to write article on Database
Category: Database

Types of SQL backup with details on their procedures

There are several methods by which SQL Backups can be created. These can include a complete set or a few data with some logs created for transaction. SQL backup methods are mostly the area of interest of Database Administrators (DBA) and System Administrators (SA).

Category: Database

Displaying and working with Number values:

SQL normally displays numbers with as many digits as required for accuracy, up to a standard display width of 10. But you can choose a different format for any number column by using a format model in a column command. The COLUMN command identifies the column you want to format and the model you want to use:

Column Format model,

To make a query that displays SAL in dollar format, enter:

COLUMN SAL FORMAT $99.999

SELECT ENAME, SAL COMM FROM EMP WHERE JOB = ‘Salesman’

Category: Database

What are SQL, MySQL, and TSQL?

SQL, MySQL, TSQL? What are these? If you’re not a geek, you will get confused with these three. Here are some information to guide you. Here are some information to guide you.

SQL (Structured Query Language)

Category: Database

Must Know About ODBC & DCOM

ODBC (Open Database Connectivity) is Microsoft's answers in favor of processing database in a variety of their programming languages. ODBC is a poor optional (non-object oriented) API for processing database. Open Database Connectivity supports the same application interface for processing database management systems (DBMS). Designers aimed to make it a sovereign of database systems, programming language, and OS. There is no Java corresponding to ODBC.

Category: Database

SQL Server: From the Past to the Future

The SQL Server was originally a joint project between, Microsoft, Sybase, and Ashton-Tate. In 1995, they parted ways and version 6.0 was the first edition released without input from Sybase. From version 7 onwards, Microsoft has rewritten the code, so as not to have to credit Sybase any longer, and be able to drop the Sybase copyright notices; which previously had to be included as an indication of its origin.

SQL Server 7.0

Category: Database

Flavors of SQL and its differences

To become a SQL expert, what are all that you need to learn? What are all the flavors in SQL and the differences between each? What is a database and what are the benefits and all sorts of details?

Starting-Up:

In this session /exercise you will prepare your computer to run SQL*plus

To Start Up:

Category: Database

Best Practices for using the Structured Query Language (SQL)

SQL (Structured Query Language) is an exceptionally high-performing database, universally accepted for its simplicity and well developed querying features that makes it distinct from its competitors in the industry. It facilitates the user with a structured organization of table structures and a relatively simple English language to query them.

Category: Database

Database Types

Database Definition:

A Database is an organized collection of information. An ORACLE database consists of tables, views, queries, and reports that are based on the tables. In an ORACLE database, you enter information you might otherwise put in a list, table, or forms. The entries information may be words, number, dates, or pieces of text. Thus, you can use an ORACLE database for organizing.

Category: Database

Communications Solutions Best Business Management

In the world of computers and information technology, communication is a very vital aspect. A major aspect in this field is Unified Communications. Unified Communication is a major collection of services that include all forms of calls and media messaging that are integrated into one system and can be easily managed by an individual or an organization.

Category: Database

Shrinking a Database in SQL server 2005

Introduction:

One important function of a database maintenance plan is to keep an eye on the size of your database. Database administrators use different techniques to maintain the size of the database.

One of the techniques is known as database shrinking.

In this article we will discuss how to shrink a database in SQL server 2005 and what are the different techniques of reducing primary and secondary databases, and log file size. Plus, what are the features introduced in SQL server 2005 that has helped in reducing the size of databases.

Database Shrinking: