Find Nth highest salary using RANKING functions

Suppose you want to find nth highest salary from a table,Then
you can use DENSE_RANK() function.Here i show some example that...

Partitioning Table in SQL Server:

Partitioning Table in SQL Server: When your database has large tables. Then partitioning will be beneficial
in terms of performance, scalability and maintainability....

Sending Querying Data on Mail as Attached File

Sending
Querying Data on Mail:

Sometimes we need to send data fetched from query on
mail automatically. You can 
create report and after running...

Linked Server setup with Oracle

Linked Server
Setup with Oracle in SQL Server:
Suppose you want to access data from
oracle or other database products using T-SQL via...

Basics of Indexes in SQL Server

Querying Microsoft SQL Server : Basics of Indexes in SQL Server: Indexes in SQL Server: If you see a book, in...

Basics of Triggers in SQL Server

Querying Microsoft SQL Server : Basics of Triggers in SQL Server: SQL Triggers:  A trigger is a procedural code like stored...

Connection String from Visual Studio

Querying Microsoft SQL Server : Connection String from Visual Studio: Connection String: A connection string contains connection information need to connect...

Data Types in SQL Server

Querying Microsoft SQL Server : Data Types in SQL Server: Data Type Description Remarks BIGINT Used for large Integer data.(Range -2^63 ...

Error Handling in T-SQL

 Error Handling in T-SQL: Error handling in T-SQL: Error handling in T-SQL is similer to other programming languages as C#,C++,Java.A...

Functions in SQL Server

 Functions in SQL Server: Functions in SQL Server In SQL Server functions are subrotienes that encapsulate a group of T-SQL...