Featured
-
Find out a particular column throughout the database in Postgresql
Previously got a situation where I needed to get t
by Nitika.Verma
Tags
What makes SQL servers have really slow response times
Troubleshooting SQL server performance can be tricky if you are not familiar with the kinds of issues that can commonly crop up in this operating environment.
Thankfully plenty of other people have encountered and tackled the problem...
What is MSBI and Its Advantages?
MSBi is an extraordinary business intelligence suite that can provide several ultimate solutions to execute data mining and business queries. It can provide various types of data access to the companies with the help of which they can make variou...
Trigger Execution Order Fired Under Different Events in SQL Server
The automatic execution of stored programs when a specific event occurs are triggers. Triggers are database object binded to a table and are called implicitly. They find their usage while accessing and checking data before and after DDL and DML q...
SQL Server : Difference between @@IDENTITY, SCOPE_IDENTITY () and IDENT_CURRENT
Difference between @@IDENTITY, SCOPE_IDENTITY () and IDENT_CURRENT
@@IDENTITY
Syntax : SELECT @@IDENTITY
The keyword "@@IDENTITY" in current session is capable of returning newly inserted or last r...
SQL SERVER Case Sensitive SQL Query Search using Collate
SQL SERVER – Case Sensitive SQL query search using Collate
SQL SERVER is not case sensitive therefore there are scenarios in which SQL query search may provide same result for various inputs which only differ with respect to ...
SQL SERVER: Copy structure of an existing table without data into new table
SQL SERVER: Copy structure of an existing table without data into new table
Create a table named "tblStudents" in database and insert some dummy data into it.
CREATE TABLE tblStudents
(
StudentId INT NO...
How to convert XML data to SQL database table
How to convert XML data to SQL database table
Step 1 : Create a table named "tblStudent" in database by following query in which xml data is to be inserted
CREATE TABLE tblStudent
(
StudentId INT,
Stud...
Auto Generated Auto Incremented Alphanumeric Sequential Code in SQL SERVER
Create a table tbEmployeeMaster by following query :-
CREATE TABLE tbEmployeeMaster
(
EmpId INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
EmpName VARCHAR(100),
EmpCode VARCHAR(15)
)
...
SQL Injection Attacks
SQL Injection Attacks
The sensitive information in database of an organization can be stolen through sql injection attack by hackers. These attacks are often referred to as front end attack which takes place due to inapprop...
Indexes In Sql
Index in SQL can be thought of as index of a book. Suppose, We have a book of 50 pages and we don't have indexes. Now if we have to navigate to a random topic then we have to start with first page and then second and so on, No problem here we...
SQL Server : How to find a stored procedure containing specific text
Many times during SQL server development we need to search for a stored procedure containing a specific text. This helps in checking for dependencies for objects in stored procedures or sometimes we might be simply interested in searching for a h...
SQL Server : List all trigger associated with a table with SQL Server
During management of SQL server database many times we need to get list all triggers in SQL Server database with table name and table's schema . Following query can be used to get the desired result.
SELECT
sysobjects....
Exception handling in SQL
Exception handling in SQL
Whenever an exception occurs our code gets disrupted. Exception handling is a way to handle these disruptions, Like we may log when an exception occurs or we may raise error when any exception occurs. We can use...
Difference between TRUNCATE, DELETE commands
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.
...
TRIGGER IN MSSQL
TRIGGERS IN MS-SQL
Triggers are special kind of stored procedures that triggers automatically when an event occur. Triggers are written to fire when a specific event on table occurs. Following are the events that may force trigger-:
1) DML ...
SQl Server : Check table existence
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 ...
SQl Server : Get size of tables in database
Many times when we manage SQL server databases we need to determine how much space each table is consuming on disk. In this blog we will learn two approaches for solving this frequently encountered common problem.
Approach 1:
We...
Some general purpose SQL queries
Some general purpose SQL queries syntax
1) To get text of stored procedures, views and triggers
sp_helptext 'Object_Name'
2) To get all stored procedures of a related database
Sele...
MySql: Display last conversation between multiple users in Inbox
Retrieve last message between multiple users and display it in inbox
Hello friends today I am going to tell you how to display last conversation in Inbox. For example: In whatsapp chat list we can see the last conversation of each us...
Wildcard with LIKE operator in SQL
In SQL, LIKE clause is basically used to search the homogeneous data using wildcard from a database. The LIKE operator is used to find out the particular string from a table's field into database.
Some wildcard examples are give...
Use of constraints in SQL
Constraints in SQL are used to define rules for the table and columns in a database and also make sure that data are accurate and trusted in the database. Constraints are responsible for the termination of action if any violation is found.
...
Normalization in database
Hi Reader's,
In this blog we are going to discuss about the Normalization process with in the database.Database Normalization can be defined as a technique which is used to organize the data within the database. Databas...
Different Types of SQL Keys
SQL Keys play a very important role in database related task in SQL like retrieve data/record from the table according to the requirement. A key can be defined as a single or combination of multiple fields/columns in a table. With the help ...
SQL Inbuilt Functions
Hi Readers,
In this blog, we will discuss the inbuilt functions of SQL which are used to perform calculations on data. All inbuilt functions are provided to make the task easier to do and we can easily complete a complex task with the help...
SQL Basic Commands
SQL stands for Structured Query Language. SQL is a language which allow us to access data or modify data from the database. Before proceeding towards the SQL we should also know about database. DataBase can be defined as the collection of multipl...
SQL Server : Best Practices
Following is a list of best practices for SQL Server
1) Use correct formatting
Following is a sample select query for reference:
SELECT
X.column...
Except Clause in SQL
Except Clause:
It combines two select statements and return tuples from first SELECT statement which are not returned by second SELECT statement. It is used to achieve Distinct and Not In queries operation in a single clause(Except).
S...
How to insert value in an auto incremented column in SQL
How to insert value in an auto incremented column in SQL
Sometimes we have situation to insert value in an auto incremented column. Let's discuss this with a simple example.
Example
1) Here is my table structure.
CREATE TABLE St...
Avoid Concat function in SQL
While writing queries in stored procedures we manipulate with the string data type columns in which concatenating string is very common.
So we all are very familiar with the function CONCAT provided by the SQL Server for joining/merg...
DATEADD function in SQL
While manipulating with the date and time data of the SQL columns we have requirements where we want to alter the date or time based on some condition or for checking validation in our application.
For doing such kind of operation in...
Cursor In SQL
Cursor In SQL
Cursor is used to iterate within a table. It is a pointer which iterates within a table to fetch rows.
Life cycle of cursor
1)DECLARE
...
What is STUFF in SQL Server
STUFF():-
STUFF is SQL SERVER function which is used to insert the string in another string. It deletes the specified number of characters from first string and insert the new string in the plac...
What is COALESCE in SQL Server
COALESCE():-
COALESCE is a function in SQL Server which returns the first non NULL expression amongst its parameter. If all the parameters are evaluated to NULL, It will return NULL
Syntex:-
CO...
How to use SQL Min () Function ?
Hi Reader's,
Welcome to FindNerd, today we are going to discuss how to use SQL Min () Function in Sql.
SQL Min () Function is used for getting the minimum value from the selected field.
Syntax of SQL Min ():
se...
MySQL CONCAT Functions
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...
Pivoting in sql
Pivoting in sql
Pivoting in sql means changing rows to columns and columns to rows. We often need to change rows to columns in some scenario. Supp...
Limit Keyword in SQL
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 ...
How to use Sql Avg () Function ?
Hi Reader's,
Welcome to FindNerd, today we are going to discuss how to use Sql Avg () Function in Sql ?
So, basically this function is used for returning the average of numeric column.If in a table there is null value t...
SELECT TOP Clause in MySQL
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 data...
How to use SQL Max () Function ?
Hi Reader's,
Welcome to FindNerd, today we are going to discuss how to use SQL Max ( ) Function in Sql ?
Basically, SQL Max () Function is used to get the maximum value from the selected field.
&nb...
How To Install and Use PostgreSQL on Ubuntu 14.04 ?
About PostgreSQL
PostgreSQL is a relational database management system. It is having advanced features so it is used in many small and large projects.
I am writing this blog which will let you know how to install Postgres on an Ubuntu 14.04...
INTERSECT Clause
INTERSECT Clause:
It works similar like union clause as it is used to combine two SELECT statements, but it returns tuples only from first SELECT statement which are common to tuples in the second SELECT statement.
Syntax:
S...
Difference between Dense_Rank() and Rank().
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 prev...
What is NOWAIT in SQL Server
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 rec...
Difference between ROW_NUMBER() and RANK().
ROW_NUMBER()
This function is used to assign a unique id to each row returned by the sql query fired.
RANK()
This function is similar to ROW_NUMBER() with the only difference it leaves a gap between the groups i.e this fun...
what is NOLOCK in SQL Server
Hi guys, I want to tell you the use of NOLOCK with simple example but before this lets discuss some terms
Lock:-
When multiple users or applications access the non-shareable resource at the same time, Locking allows to access the ...
Truncate and drop difference
Truncate and drop both are similar to each other as they are used to delete the complete data of a table.
The difference between them is this truncate only delete the data of the table where as the table structure is there but when we drop the...
Distinct keyword
It is used for conjunction with the select statement to eliminate the all the duplicate record and fetch only the unique record.
There are many situation that we found duplicate data on the database and better to get unique ones.
SELECT D...
How to limit data in MYSQL
The LIMIT clause in MySQL helps to get multi pages results or pagination through SQL Databases. This LIMIT clause is very useful on large tables its because returning the large numbers of records through MYSQL will be difficult to read and analyz...
SQL wildcards
It is used with the like operator to compare the values of the type similar.
It support two wildcards type
1. The percent sign (%)- It match to one or more character.
2. The underscore (_)- It match to one character.
The per...
