Search In
Today i will discuss one interesting topic NOWAIT in SQL Server and would explain how to use it.
As we know about the transaction in SQL it is unit of work which is to be executed as whole. Suppose we are updating some records in
Rank()
This function assigns a row id to each row returned by the sql query fired. It provides distinct row id to distinct values, similar values have similar row id, the next row id is calculated as number of occurrence of previous r
In a computer network, there are links and nodes, which help workstations connect to each other. Such a pattern is referred to as a network topology.
It is divided into physical topology and logical topology. When one is talking about the
The SELECT TOP clause is used to return specific number of records with thousands of records. It is used to select top N number of records from a table. We can use number or percent to select record.
TOP clause is not supported by all the databases.
EXISTS simply tests whether the inner query returns any row. If it does, then the outer query proceeds.
If not, the outer query does not execute, and the entire SQL statement returns nothing.
The general syntax for the Exist stateme
Inline view in SQL is like a select statement that contains everything in the From clause.
View is temporary table that is created for data manipulation.
In this we don't specify the table name instead of that th
CONCAT function is mysql plays a vital role. The CONCAT() function combine or concatenate the list of strings together .
We have 2 types of concat function ->
CONCAT() – This function will concate list of string together without any sepa
A common problem encountered during SQL server development is to check if a particular table exists or not. There are different approaches to solve this problem and in this blog we will list out these approaches. For illustration purpose we will be u
By default, all results that satisfy the conditions specified in the SQL statement are returned. However, this may not always be what we want, as sometimes we only want to retrieve a subset of records.
In MySQL, this is accomplished using th
TRUNCATE:
Truncate command will remove all the rows from a table, there will be no WHERE clause in TRUNCATE command and there will be no data in the table after we run the truncate command.
TRUNCATE i
