Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

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

  Hi Reader’s,   In this blog we will discuss about the concept of keys used in SQL SERVER. These keys play a very important role in database related task in SQL like retrieve data/record from the table according to the...

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...

NOT NULL Constraints in Sql

Not Null Constraints : In SQL server database, the data field in the table can hold null values that represents that it will be holding some garbage or unknown Value. If the data field in a table is empty or if we don't put some value ...

Cross Join In Sql

Cross Join: The Cross Join command helps to Join two Two table by a Cartesian method. Means that number of rows in the first table will get multiplied with the number of Rows in the Second table. The Cartesian method can be understood by ta...

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...

Alias

Alias is basically renaming a table temporarily for a sql statement. The rename is done only for a particular statement is temporory. ex The syntax of table alias is as follows SELECT column1, column2.... FROM table_name AS alias_n...
prev 1 3 6
Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: