Computer Programming Languages

Often, as a SQL DBA or Developer, there’s a need to write quick simple tasks to get something done. I’ve had the opportunity to write many of these types of procedures and I thought I’d share...

Making XML look pretty in a Microsoft SQL Server result set is moderately easy, given a proper set of tools and technique. Whether using SQL Server 2000, 2005 or 2008, producing easy-to-read,...

The purpose of a PL/SQL cursor is to query a database. This will gather a subset of information that you will use later in your code. In order to create a Cursor you must use it inside an...

Have you ever wanted to remain anonymous for something? Just as people can chose to be anonymous for various things sometimes in the coding language PL/SQL blocks can be anonymous or unnamed. ...

Oracle products use SQL, the industry standard relational database language that was defined by IBM Research but was first introduced to the commercial market by Oracle Corporation in 1979. Oracle...

The Oracle database allows you to use regular expressions in SQL queries with the REGEXP_LIKE, REGEXP_INSTR, REGEXP_SUBSTR, and REGEXP_REPLACE functions. These functions work like the LIKE, INSTR,...

Starting with Microsoft SQL Server 2000, Reporting Services has been a valuable tool for developers to create and deploy reports for end users. Microsoft SQL Server Reporting Services was...

One of the limitations of relational databases is that there is no easy way for end users to access their data. Starting with SQL Server 2000, Microsoft introduced SQL Server Reporting Services...

Deleting records from Oracle using SQL is a sensitive task. Accidentally deleting records can lead to a loss of data integrity and errors in applications. The delete syntax to remove records from...

Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. The language used to manage and administer the database server is SQL. Everything in a database ends...

Web databases comprise three essential components: the HTML web page interface, the server side script and the database. Users access databases through text input boxes, drop-down menus, text...

Database tables are structured in columns and rows. However, some data lends itself to switching row data as column data for expository purposes. The pivot operation in SQL allows the developer to...

SQL commands are used to query, input or modify information in a relational database. A query is used when you need to know specific information about the data, such as which students scored over...

Structured Query Language is the American National Standards Institute standard for manipulating data in a database. Pronounced "ess-que-el," basic language commands can be used on most databases,...

Structured Query Language, or SQL for short, is a powerful database creation language. SQL acts as the backend for creating, manipulating and storing information in databases. it is used for...

If you use a database for long enough, you will probably run into a situation where you want to drop a table if it exists. Often the reason you'll want to do this is because you need to create a...

Are you a hardcore MS Access SQL user? If you use the SQL view often, you may find the default font too small to easily work with. Using the fonts available on your computer, you can change it to...

SQL (Structured Query Language) is the ANSI/ISO standard programming language for relational database systems. Extracting specific data from a database involves a statement called a...

SQL is Structured Query Language, a standard programming language for use with databases. SQL allows you to access a database, make queries of the database, and retrieve data from a database. Your...

An SQL server database comes into play when large numbers of concurrent connections need to be made or when the ability to have the capacity for large numbers of records is necessary. To create an...