The need for a database originates from the fact that computers are dumb devices having batman like abilities which can be smartly be utilised by feeding it the right content. That is, for example, consider...
Stored Procedures
Functions
Stored procedures may or may not return a value
Function should return a value
Stored procedure should be executed by ‘EXECUTE’...
DBMS
RDBMS
Stored data in a file
Stored data in a table
As it is stored in a file, there is no relationship concept
Data in one table may be relationship with data in another table...
SQL tips 4:Avoid INDEX, unless you need to retrieve information quickly. Index will slower insert and update data query.The another way is using sub querySelect MAX(salary)FROM employeeWHERE salary IN(Select...