Stored Procedures are precompiled objects which are compiled for first time and its compiled format is saved which executes (compiled code) whenever it is called. But Function is compiled and executed every time when it is called. Functions and Stored Procedures serve different purposes.
SQL and Databases questions and answersMost popular interview questions on SQL and databases technologies. SQL is a programming language designed for managing data held in a relational databases.
SQL join is an instruction to a database to combine data from more than one table. There are different kinds of joins, which have different rules for the results they create. In most SQL implementations you may find such joins as inner join, left join, right join, full join and also language implementation specific ones.
Often abbreviated DB, a database is basically a collection of information organized in such way that a computer program can quickly select desired pieces of data. You can think of a database as an electronic filing system. You can not only store, but also insert, update and delete data from DB.
SQL is Structured Query Language used for relational database management. Originally based upon relational algebra and tuple relational calculus, SQL consists of a data definition language, data manipulation language, and a data control language. Read basic definition of SQL here.
SQL stands for Structured Query Language. Basically, SQL is used to communicate with and manipulate a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. The scope of SQL includes data insert, query, update and delete, schema creation and modification, and data access control.