Search In
SQL Update statement is used to modify the records in table in database . We can modify either by change data or deleting data or to update the existing data .
We can modify the rows based on condition and condition come with where clause .
Syntax :
SQL Join query is used to join the two tables i.e add or combine two or more tables .
This clause take data from two or more table in database and then combine them to produce new table .
Joining is based upon the common fields from the tables .
Adva
In this Join all the content of both table will come in resultant table either they will be matched or not .
Outer Join are of two types :
1) Left Outer Join -> It is also known as left join . In left join all the content of left table will come i
In full join all the records of both the table will come in resultant table , it doesn't depend on matching the fields . It is the combination of both left and right join . If matches not found then it will return null .Sometime it is also called Ful
2) Right Outer Join -> It is also known as Right join . In right join all the content of right table will come in resultant and from the left table only matching rows will come . If no rows is matched from left table then null value will be return
These operators are used where we want to get records based on more than one condition .
And : From this operator we can get data if both the condition ( i.e first and second condition ) are true .
Or : From this operator we can get data if either th
This operator is used when we want specific pattern from a column in a table .
% : This is called wildcards , it is used before and after the pattern .
Syntax :
select column_name1 .......column_nameN from table_name where column_name like pattern ;
What is IP Address ?
IP is an address which is given to each and every device in a network.
It's a logical address given to devices in a network.
It Works in Network layer
IP Versions:
1> IPv4
- 32 bits(represented by 0 and 1)
- IP a
Store Procedure:-- These are set of SQL Statements which are grouped in such a way that they execute to do a certain task and make processing of our application fast.
Advantages:- They are stored in precompiled format and therefore are fast.
Only
How to use Transaction and Try Catch in Stored Procedure
Suppose you are working on multiple table in a database eg updating, deleting and inserting on multiple table then it is always a good practice to maintain Transaction property as using this w
