stored procedure in SQL & its Connectivity

 stored procedure in SQL & its Connectivity

With the help of SQL server we will be to increase the value (stored procedure in SQL & its Connectivity)or to extend of the business. SQL defined as “Structured Query Language”. SQL is an ANSI. ANSI stands for “American National Standards Institute”. SQL can be used in various types of method such as it can be execute queries against a database, it can be insert records in a database, it can be delete records from a database, it can be create new database, it can be insert new table in a database, etc. (stored procedure in SQL & its Connectivity)SQL can also be create to stored procedures in a database. If you want to build a web site that shows form a database. We can to use a server-side scripting language, PHP or ASP, HTML or CSS to build a web site that shows form a database. My Access, SQL Server, My SQL are the programs of the RDBMS Database. The “RDBMS Database” stands for “Relational Database Management System”. RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL and Microsoft Access. The data in RDBMS is stored in database objects called tables. The “Tables” is collection of entries data in columns vice also rows vice. A database most often contains one or more tables. Each tables identify by a name. We need to performed on a database are done with SQL statement(stored procedure in SQL & its Connectivity). Semicolon is the standard way to separate each SQL statement in database systems that allow more than one SQL statement can be executed in the same call to the server. There are various types of commands using in SQL such as Select, Update, Insert Into, Delete, Create Database, Alter Database, Create Table, Alter Table, Drop Table, Create Index, Drop Index, etc.

The “Select command” is used to extracts data from a database. The “Update command” is used to update any data in a database. The “Insert Into command” is used to insert new data into a database. The syntax of the “Insert Into commands” is ((INSERT INTO table_name), (Values (value1,value2,value3….);).The “Delete command” is used to delete data from a database. The “Create Database command” is used to create new database. The “Alter Database command” is used to modify a database. The “Create Table” is used to create new table. The “Alter Table command” is used to modify a table. The “Drop Table command” is used to delete a table. The “Create Index command” is used to create an index (search key). The “Drop Index command” is used to delete an index. The SQL create database syntax is “CREATE DATABASE dbname;”. (stored procedure in SQL & its Connectivity)The “Select Statement” is used to select data from a database. The result is stored in a result table is called the “Result- Set”. There are two operators can be used in SQL such as “AND Operator” and “OR Operator”. The “AND Operator” display a records if both the first condition AND the second condition is true. The “OR Operator” display a records if either the first condition OR the second condition is true. If you want to used combining operators “AND” or “OR” operators you can it. (stored procedure in SQL & its Connectivity)The “ORDER BY Keyword” is used to sort the result-set by one or more columns. The “Like Operator” is used to search for a specified pattern in a column. Now, I talk about the Database Management System (DBMS) and DB2. DBMS and DB2 both are different. “DBMS” are computer software applications that interact with the user, and the database itself to capture and analyze data. A “database” is an organized collection of data, tables, etc.

DB2 is a family of relational database management system (RDBMS) that server a number of different operating system platforms developed by IBM. It is a main difference between a database management system (DBMS) and DB2. We know that MYSQL, Microsoft SQL Server Oracle, IBMDB2, etc are including of the DBMS’s. There are classified four types of function of the database management system are: Data definition, Update, Retrieval, Administration. The “Data definition” is defined as creation, modification and removal of the organizations of the data. The “Update” is defined as creation, modification, and removal of the actual data. The “Retrieval” may be made available in the form basically the same as it stored in the database or in a new form obtained by altering. The “Administration” is defined as the registering and monitoring users, enforcing data security, dealing with concurrency control, etc. There are various types of application of the database management system are used in areas such as Banking, Airlines, Universities, Credit card transaction, finance, etc. The application of the database management area of the banking is used for customer information, accounts and loans, and banking transaction. The application of the database management system area of the airlines is used for reservation and schedule information. The application of the database management system area of an universities is used for student information, course registrations, and grades. There are three types of level of the database management system of the database are: External level, Internal level, and Conceptual level.stored procedure in SQL & its Connectivity

The “External level” defines how each group of end-users sees the organizations of data in the database. The “Internal level” is defined as the internal organization of data inside a DBMS. It is concerned with cost, performance, and other operational matters, it known as “internal level”. The “Conceptual level” is defined as the various external views into a compatible global view. The database and most its DBMS reside remotely in the “cloud”. In the mid of 1960’s of the term database coincided with the availability of the direct access storage. Using of a primary key, Navigating relationships from one record to another, Scanning all the records in a sequential order these are three methods of the database management system. In 1970’s, Edgar Codd worked at IBM in San Joss, California, in one of their offshoots offices that was primarily involved in the development of hard disk system. There are so many languages are used in database management system. The “Query language” are used to allow searching for information and computer derived information.

Today, there are three main product family of DB2 are: DB2 for Linux, UNIX and Windows. The VM / VSE also a fourth product of DB2 is available. IBM produce a plateform-specific DB2 produced for each of its major of the operating system. In 1974, the IBM Scan Jose Research center developed a relational DBMS, System R. to implement cod’s concept. A key development of the system R project was SQL. DB2 can be administered from either the command-line or a GUI.stored procedure in SQL & its Connectivity DB2 supports both XQuery and SQL. DB2 is an error handling. The “Positive number” is represent as successful execution with one or more warnings. The “Negative number” represents unsuccessful with an error. In the end I say that “MYSQL is also a most popular database software for web sites” DB2 is making to easier to use for people with Oracle Database skill.