Title: Structured Query Language

Microsoft Navision DB Selection: C/SIDE or MS SQL Server - overview for IT Specialist

Published on Mon, 04 Jan 2010 16:52:00

Microsoft Business Solutions Navision serves both European and American megamarkets. It was originally written by Denmark-based Navision Software in its own proprietary language C/SIDE (Client/Server Integrated Development Environment). You should consider several factors in deciding on the database selection. Currently Navision is supported on two platforms - Navision native (C/SIDE) database and on Microsoft SQL Server. There are certain pluses and minuses in both cases and you should make you read more..

Crystal Reports - Geterogeneus databases: SQL Server, Oracle, Unidata, Btrieve – tips for developer

Published on Mon, 04 Jan 2010 16:49:00

Crystal Reports is the most flexible tool on the market and it has market recognition. Multiple software vendors offer Crystal Reports as the main reporting tool: Microsoft, Best Software, Oracle to name a few. Sometimes developers try to use Crystal directly to pull data from multiple database platforms - we understand the need to give you additional tips to increase Crystal report flexibility. Also common case when Crystal report should pull data from multiple database platforms. Assuming t read more..

Where can I get support PostgreSQL ?

Published on Thu, 17 Dec 2009 05:38:00

The main mailing list is: pgsql-general@PostgreSQL.org. It is available for discussion of matters pertaining to PostgreSQL. To subscribe, send mail with the following lines in the body (not the subject line): subscribe endto pgsql-general-request@PostgreSQL.org.There is also a digest list available. To subscribe to this list, send email to: pgsql-general-digest-request@PostgreSQL.org with a body of: subscribe endDigests are sent out to members of this list whenever the main list has read more..

Where can I get PostgreSQL?

Published on Thu, 17 Dec 2009 05:38:00

The primary anonymous ftp site for PostgreSQL is ftp://ftp.PostgreSQL.org/pub. For mirror sites, see our main web site. read more..

What non-Unix ports are available?

Published on Thu, 17 Dec 2009 05:37:00

ClientIt is possible to compile the libpq C library, psql, and other interfaces and client applications to run on MS Windows platforms. In this case, the client is running on MS Windows, and communicates via TCP/IP to a server running on one of our supported Unix platforms. A file win32.mak is included in the distribution for making a Win32 libpq library and psql. PostgreSQL also communicates with ODBC clients.ServerThe database server can run on Windows NT and Win2k using Cygwin, the Cygnus Uni read more..

What Unix platforms does PostgreSQL run on?

Published on Thu, 17 Dec 2009 05:37:00

In general, a modern Unix-compatible platform should be able to run PostgreSQL. The platforms that had received explicit testing at the time of release are listed in the installation instructions. read more..

What is the copyright on PostgreSQL?

Published on Thu, 17 Dec 2009 05:37:00

PostgreSQL is subject to the following COPYRIGHT:PostgreSQL Data Base Management SystemPortions copyright (c) 1996-2002, PostgreSQL Global Development Group Portions Copyright (c) 1994-6 Regents of the University of CaliforniaPermission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all co read more..

What is PostgreSQL? How is it pronounced?

Published on Thu, 17 Dec 2009 05:36:00

PostgreSQL is pronounced Post-Gres-Q-L.PostgreSQL is an enhancement of the POSTGRES database management system, a next-generation DBMS research prototype. While PostgreSQL retains the powerful data model and rich data types of POSTGRES, it replaces the PostQuel query language with an extended subset of SQL. PostgreSQL is free and the complete source is available.PostgreSQL development is performed by a team of developers who all subscribe to the PostgreSQL development mailing list. The current c read more..

SQL Scalar functions

Published on Thu, 17 Dec 2009 05:35:00

SQL scalar functions return a single value, based on the input value.Useful scalar functions: * UCASE() - Converts a field to upper case * LCASE() - Converts a field to lower case * MID() - Extract characters from a text field * LEN() - Returns the length of a text field * ROUND() - Rounds a numeric field to the number of decimals specified * NOW() - Returns the current system date and time * FORMAT() - Formats how a field is to be displayed read more..

SQL Aggregate Functions

Published on Thu, 17 Dec 2009 05:34:00

SQL aggregate functions return a single value, calculated from values in a column.Useful aggregate functions: * AVG() - Returns the average value * COUNT() - Returns the number of rows * FIRST() - Returns the first value * LAST() - Returns the last value * MAX() - Returns the largest value * MIN() - Returns the smallest value * SUM() - Returns the sum read more..

SQL Replication with Online Backup

Published on Sun, 06 Dec 2009 06:01:00

It is vitally important that every business have a disaster recovery plan for its electronic data stores. Your company's data includes more than simple Word documents and e-mail messages; it also includes you databases and web site information.One of the worst things that can happen to your business, whether it is large or small, is to lose any of your electronic data due to hardware failure, software corruption, or even to a natural disaster.Unfortunately each of these three things happens more read more..

SQL Best Practices

Published on Sun, 06 Dec 2009 05:59:00

Are you looking for SQL best practises, hints and tips to assist you in optimising your queries? A fast SQL Server is something that should be taken for granted, but, the vast majority of systems do not perform well.The reasons for this can vary, and include database design, hardware bottlenecks, poor coding, table size, poor indexing, an overloaded Server, inefficient configuration, insufficient space, and many more.If you search the web, you will find articles, forums, expert advice, hints and read more..

SQL Server Database Security

Published on Sun, 06 Dec 2009 05:58:00

A few years back, a deadly virus called the Slammer worm attacked a lot of SQL severs gaining access to millions of credit cards. Microsoft has been on the guard since then making efforts to create and develop software in better protection and security of our systems. The effort is bold and continuing in being dedicated to enhancing and preserving SQL server database security.SQL means Structured Query Language is actually an essential element of modern database systems. It is a definition by wh read more..

How To Use Structured Query Language (SQL)

Published on Thu, 19 Nov 2009 17:24:00

Structured Query Language (SQL) is a computer language for creating database and manipulating data. SQL is an ANSI (American National Standard Institute) standard and is supported by almost all Relational Data Base Management Systems (RDBMS) like Oracle, MySQL, SQLServer, MS Access, PostGreSQL etc. SQL has two parts:* Data Definition Language (DDL): to create, alter, or drop tables and indexes.* Data Manipulation Language (DML): to insert, update, retrieve or delete the data in the tables.Here's read more..

Directories

Published on Sun, 25 Oct 2009 05:33:00

Blogs DirectoryBlog DirectoryBlog-Search.com Wil's Domain Weblogvar s_sid = 529545;var st_dominio = 4;var cimg = 406;var cwi =165;var che =100; read more..

Link Exchange

Published on Sun, 25 Oct 2009 05:33:00

1.Link2Me SEO Link Exchange DirectoryQuality directory of webmasters actively seeking link exchange. Improve your search engine rankings and link popularity the easy way. Work clever not hard.2.Link Market - Free Link Exchange, Link Swap and Link Trade DirectoryHave you ever tried to exchange links, swap links, or trade links? Was it hard? Use link market instead; - it is easy to use, free and very smart. It will save you hours of work.3.The Link Exchange - Your ultimate resource for link exchan read more..

User-Named Exception Handlers

Published on Sun, 12 Jul 2009 11:56:00

The technique that is used to bind a numbered exception handler to a name using 'Pragma Exception_init()'.This binding of a numbered exception handler,to a name string, is done in the declare section of the PL/SQL block.All objects declared in the declare section of a PL/SQL block are not created until actually required within the PL/SQL block. However, the binding of a numbered exception handler to a name must be done exactly when declared not when the exception handler is invoked due to an ex read more..

Pre-determined Internal PL/SQL exceptions

Published on Sun, 12 Jul 2009 11:45:00

1. DUP_VAL_ON_INDEX: Raised when an insert or update attempts to create two rows with duplicate values in columns constrained by a unique index.2. LOGIN_DENIED: Raised when an invalid username/password was used to log onto Oracle.3. NO_DATA_FOUND: Raised when a select statement returns zero rows.4. NOT_LOGGED_ON:Raised when PL/SQL issues an oracle call without being logged onto Oracle.5. PROGRAM_ERROR: Raised when PL/SQL has an internal problem.6. TIMEOUT_ON_RESOURCE: Raised when Oracle has been read more..

Exception Handler

Published on Sun, 12 Jul 2009 07:49:00

An Exception Handler is nothing but a code block in memory that will attempt to resolve the current exception condition. The Oracle engine can recognize every exception condition that occurs in memory. To handle very common and repetitive exception conditions the Oracle engines uses Named Exception Handlers.The Oracle engine has about fifteen to twenty named exception handlers. In addition to this the Oracle engine uses more than twenty thousand numbered exception handlers. These exception handl read more..

Error Handling In PL/SQL

Published on Sun, 12 Jul 2009 07:39:00

Every PL/SQL block of code encountered by the Oracle is accepted as a client. Hence the Oracle engine will make an attempt to execute every SQL sentence within the PL/SQL block. However while executing the SQL sentence anything can go wrong and the SQL sentence can fail.When an SQL sentence fails the Oracle engine is the first to recognize this as an Exception condition.The Oracle engine immediately tries to handle the exception condition and resolve it. This is done by raising a built-in Except read more..

Logical Operators - Pattern Matching

Published on Sun, 07 Jun 2009 07:09:00

The use of the LIKE predicate:The comparison operators discussed so far have compared one value, exactly to one other value. Such a precision may not always be desired or necessary. For this purpose Oracle provides a predicate LIKE.The LIKE depreciate allows for a comparison of one string value with another string value, which is not identical. This is achieved by using wildcard characters. Two wildcard characters that are available are:For character data types: 1. The Percent sign (%) matches a read more..

Range Searching

Published on Sun, 07 Jun 2009 06:57:00

In order to select data that is within a range of values, the BETWEEN operator is used. The BETWEEN operator allows the selection of rows that contain values within a specified lower and upper limit. The range coded after the word BETWEEN is inclusive.The lower value must be coded first. The two values in between the range must be linked with the keyword AND. A BETWEEN operator can be used with both character and numeric data types. However, one cannot mix the data types that is the lower value read more..

Logical Operators - NOT Operator

Published on Sun, 07 Jun 2009 06:52:00

The Oracle engine will process all rows in a table and display the result only when row of the conditions specified using the NOT operator are satisfied.Example: Retrieve specified client information for the clients who are NOT in "Hyderabad" OR "Bangalore".SELECT client_no,name,address1,address2,city,pincode FROM client_master WHERE NOT ( city='Hyderabad' or city='Bangalore');The oracle engine will not display the rows from the client_master table where the value of the field city is either Hyd read more..

Logical Operators - OR Operator

Published on Sun, 07 Jun 2009 06:45:00

The Oracle engine will process all rows in a table and display the result only when any of the conditions specified using the OR operator are satisfied.Ex: Retrieve client information like client_no,address1,address2,city and pincode for all the clients where the field pincode has the value 400065 or 500089;SELECT client_no,name,address1,address2,city,pincode From client_master WHERE (pincode=400065 OR picode=500089);The contents of the fields client_no,name,address1,address2,city,pincode satisf read more..

Logical Operators - AND Operator

Published on Sun, 07 Jun 2009 06:11:00

Logical Operators that can be used in SQL sentence are:AND Operator: Oracle engine will process all rows in a table and display the result only when all of the conditions specified using and AND operator are satisfied.Example: Retrieve the contents of the columns product_no,description,profit_percent,sell_price from the table product_master where the values contained in the field profit_percent is between 10 and 20 both inclusive.SELECT product_no,description,profit_percent,sell_price From produ read more..