Search In
While taking backup our goal is to keep the application, database system, and web site, in running condition while we are taking the backup.
Database backup technique can be classified mainly into two categories:
- Hot Backup
- Cold Backup
This post describes the major differences between CTE, temp table and table variables.
1) CTE
CTE stands for Common Table expressions. These are simple select queries and they do not create physical space in tempDB. Unlike temporary table there
Function in SQL
There are two type of function in sql
SQL aggregate function
1) AVG() - Returns the average value
SELECT AVG(column_name) FROM table_name
2) COUNT() - Returns the number of rows
SELECT COUNT(column_name) FROM table_name
SQL injection is a technique that exploits a security vulnerability within the database layer of an application.Using this technique the attacker tries to run his own malicious query against the database.The key component of these malicious queries i
Welcome to Findnerd. In web development we need popup for different requirements then we start finding the third party jquery plugins which could meet our requirement.
but sometimes we puzzle with these plugins. Here we are describing one other way t
SQL JOIN is used to combine data from two or more different table based on a common field between them in a relational database.
There are 5 types of JOIN:
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
CROSS JOIN
INNER JOIN: This SQL query re
Chapter 1
Introduction to SQL
Introduction to SQL : SQL stands for Structured Query Language or we can call it as "sequel" or "S-Q-L" . SQL is a query Language used to accessing and modifying information in a database.There are some common SQL comm
<-- Chapter 4: SQL Distinct
Chapter 5
SQL Where
SQL Where : SQL Where clause extract or filters those records which matches the specified condition. Syntax for Where clause is used below
SELECT *
FROM tablename
WHERE condition
Here "condit
<-- Chapter 3: SQL Select
Chapter 4
SQL District
SQL District : District is a keyword which is used to fetch unique column values from database table OR we can simply say that ignores the column duplicate values. Syntax for district keyword is
<-- Chapter 5: SQL Where
Chapter 6
SQL IN Operator
Lets see an example from the below table "employees" :-
employee_id
name
code
designation
salary
101
ABC
E-101
Engineer
12000
102
DEF
E-102
Doctor
8000
103
GHI
E-103
Software Deve
