TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
C# Corner
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
About SQL Query
Share
facebook
twitter
linkedIn
Reddit
Topics
No topic found
Content Filter
Articles
Videos
Blogs
News
Complexity Level
Beginner
Intermediate
Advanced
Refine by Author
[Clear]
Rohatash Kumar (7)
Vijay Prativadi (5)
Saravanan Ponnusamy (2)
Sachin Kalia (2)
Pankaj Kumar Choudhary (2)
Jignesh Trivedi (2)
Vinod Kumar (2)
Veena Sarda (2)
Iftikar Hussain (2)
Hemant Srivastava (2)
Dhananjay Kumar (2)
Amit Choudhary (2)
Tushar Dikshit (1)
Shakti Singh Dulawat (1)
Rahul Bansal (1)
Santosh Kumar Adidawarpu (1)
Akshay Phadke (1)
Bhuvanesh Mohankumar (1)
Gagan Sharma (1)
Anil Kumar (1)
Rakesh (1)
Vineet Kumar (1)
Amit Tiwari (1)
Ahmar Husain (1)
Biswa Pujarini Mohapatra (1)
Abhijit Patil (1)
Ehtesham Mehmood (1)
Syed Shanu (1)
Sandeep Singh Shekhawat (1)
Lakshmanan P (1)
Gaurav Chauhan (1)
Parthiban Selvaraj (1)
Shivprasad (1)
Lajapathy Arun (1)
Ajit Kanada (1)
Related resources for SQL Query
No resource found
35 Essential Basic-Advanced SQL Query-Questions Asked In Technical Interviews
9/19/2017 2:12:56 PM.
These are all query-based questions asked in tech interviews, including some simple looking tricky one liner SQL statements and joins.
Azure Cosmos DB With SQL Query Cheat Sheet PDF
9/8/2017 2:26:14 PM.
Microsoft Azure Cosmos DB supports querying documents using SQL (Structured Query Language) as a JSON query language. Cosmos DB is truly schema-free. By its commitment to the JSON data model directly
Construct Readable XML Output From SQL Query From Two Or More Tables Using “For XML PATH” Statement
9/4/2017 12:25:58 AM.
In my previous article I discussed about how to get a XML format output from query and process that by using XML AUTO statement, and I give different types of “for XML”.
Transform XML Output Of SQL Query To HTML Using "For XML" AUTO Statement With XSLT In C#
8/21/2017 4:37:24 PM.
Normally, we execute the query using ExecuteNonQuery statement and fill the output into data table. This article describes how to transform the XML output of SQL query statements using FOR XML AUTO to
Find The 3rd Or Nth Highest Salary In A Table Via SubQuery
8/1/2017 2:03:54 AM.
This article describes how to find the 3rd or Nth highest salary in a table. To find the Nth highest salary, we need to create a table in the database containing some data and to do this use the follo
Dynamic SQL Query Injection And Its Prevention Mechanism
6/20/2016 10:23:13 AM.
In this article, you will learn about dynamic SQL query injection and its prevention mechanism.
SQL Query Plans Each Developer Should Know
5/26/2016 12:59:28 PM.
In this article you will learn about SQL Query Plans for each Developer.
How To Optimize SQL Queries
4/24/2016 10:04:28 PM.
In this article you will learn how to optimize an SQL Query.
Displaying Line Numbers In SQL Query Editor
12/4/2015 11:34:11 AM.
In this article we will discuss about the option of displaying Line Numbers in the SQL Server Query editor.
Execute Long Running SQL Query Or Stored Procedure From .NET
10/21/2015 8:19:13 AM.
This article describes the asynchronous call to MS SQL statements from .NET environment using C# to avoid UI or main thread freezing.
Various Approaches to Find Nth Salary in SQL Server 2008R2
8/28/2015 3:23:25 PM.
This article describes various approaches to find the nth salary in SQL Server 2008R2.
Difference Between ROW_NUMBER () OVER () & PARTITION BY Clause
7/29/2015 4:50:14 PM.
In this article you will learn the difference between ROW_NUMBER(), OVER() and PARTITION BY clauses in SQL Server.
Tips to Increase SQL Server Query Performance: Part 2
6/15/2015 6:49:30 PM.
This article provides more tips to increase SQL Server query performance.
Important Queries in SQL
6/8/2015 5:16:56 AM.
In this article we learn some interesting and useful SQL queries.
SQL Server Database Basics Query Command
5/3/2015 1:46:08 PM.
This article provides some SQL Server database basic information including database creation, data table creation and basic query information.
SQL Query Performance - Functions and Indexes
4/3/2015 11:29:51 AM.
In this article we will learn why functions should be avoided on indexed columns in where clauses of select statements.
Get Months Within a Date Range With SQL Query
2/11/2015 11:28:25 PM.
This article shows how to get the months within a date range with SQL Query.
Transact SQL Query Performance Tuning Tips
9/26/2014 9:15:49 AM.
In this article, I will discuss some T-SQL query performance tips and tricks for SQL server programmers. The tips mentioned in this article may sound obvious to most of you, but I have seen professional developers who don't think before using them.
Query Notification in SQL Server
6/11/2014 2:41:46 PM.
This article explains QueryNotification and SQLCacheDependency in SQL Server.
Import Data From Database Using Native SQL Query in Microsoft Excel 2013
3/15/2014 2:48:46 PM.
This article shows the powerful features of Excel 2013 to import data from a database.
Tools in SQL Server Management Studio
3/4/2014 1:00:33 PM.
This article shows how to use Tools in SQL Server Management Studio.
LINQ To SQL
2/24/2014 5:45:33 PM.
Today in this article I will teach you the most interesting and new features of the C# programming language, LINQ-To-SQL.
Inventory Management Using SQL Trigger
12/30/2013 9:58:41 PM.
In this Article I explain how to create a simple Inventory Management transaction Using Insert, Update and Delete Trigger.
Query Notification in SQL Server
12/12/2013 3:35:57 PM.
Thisarticle dscribes Query Notification in SQL Server.
Publishing MySQL Data With PDO Extension In PHP
11/16/2013 8:24:05 PM.
This article is explain publishing MySQL data with PDO extension in php.
SQL Query to Get Details of Index Fragmentation in SharePoint
7/26/2013 2:07:37 AM.
This article explains how to get the details of index fragmentation in SharePoint and provides a script that can be used to rebuild and reorganize indexes.
SharePoint SQL Query to Get Details on Disk Utilization and IO
7/24/2013 2:34:55 PM.
In this article I will demonstrate SharePoint SQL Query to get details of Disk Utilization and IO.
Some Important Tips For SQL Query Performane
7/1/2013 1:13:56 PM.
This article provides some important tips for SQL Query Performane.
Searching, Sorting and Paging Using SQL Query
6/25/2013 4:41:14 PM.
This article shows how to use a SQL query to perform searching, sorting and paging by one query.
Finding Duplicates Among Multiple Columns in SQL
5/15/2013 1:12:05 PM.
Here I show how to find duplicates and their frequency among multiple columns using the GROUP BY clause.
MySQL Fetch Array Function in PHP
5/11/2013 5:07:57 PM.
In this article I explain the "MySQL_Fetch_Array()" function in PHP.
DATABASEPROPERTYEX Function in SQL Server
5/1/2013 5:16:35 PM.
In this article, I would like to show how to extract the metadata about a database in SQL Server.
Working With Date and Time in SQL Server and C#
4/11/2013 3:29:24 PM.
In this article, I would like to show the similarity of SQL Getdate function and the C# DateTime class.
Getting the Name of the Server and Databases in SQL Server
3/19/2013 1:27:58 PM.
In this article, I would like to show how to get the name of the server and databases in SQL Server.
Getting Some Useful Date and Time Information From Getdate Function in SQL Server 2012
3/6/2013 4:10:55 PM.
In this article, I would like to show the utility of Getdate functions in SQL Server.
Insert and Update Stored Proc With Raw SQL Query Via EDF Framework
12/31/2012 4:49:04 PM.
Today, in this article let's play around with one of the interesting and most useful concepts in EDM Framework.
Delete and Update Data With Raw SQL Query Via EDF Framework
12/31/2012 4:33:20 PM.
Today, in this article let's play around with one of the interesting and most useful concepts in EDM Framework.
Select Stored Proc With Raw SQL Query Via EDF Framework
12/31/2012 12:28:56 AM.
Today, in this article let’s play around with one of the interesting and most useful concepts in EDM Framework.
Insert Data With Raw SQL Query Via EDF Framework
12/31/2012 12:27:14 AM.
Today, in this article let’s play around with one of the interesting and most useful concepts in EDM Framework.
Delete Stored Proc With Raw SQL Query Via EDF Framework
12/29/2012 12:40:30 PM.
Today, in this article let’s play around with one of the interesting and most useful concepts in EDM Framework.
Calculating Factorial of a Number in SQL Server 2012
12/3/2012 12:48:17 PM.
Here, I have constructed a query that provides a solution in SQL Server to determine the factorial of a specified number.
Count(All) vs Count(Distinct) in SQL Server 2012
12/1/2012 3:52:42 PM.
In this article, you will see the SQL aggregate function count in two forms, Count(All) and Count(Distinct).
On vs Where Clause in SQL Server 2012
11/29/2012 2:14:54 PM.
Here, I will explain the difference between the On and Where clauses when used with a left join in SQL Server.
Find Nth Highest Salary in SQL Server
11/6/2012 4:49:33 PM.
In this article I am explaining various ways to get the Nth highest salary from an EMPLOYEE table.
Using LINQ to SQL Query
9/30/2012 3:08:05 AM.
Here in this article, you will get very basic idea of LINQ to SQL Query using code.
Executing SQL Query Using LINQ to SQL
9/30/2012 2:21:00 AM.
In this article, I will discuss how we can execute a SQL Query directly from LINQ.
Modifying a Database Checkpoint in QTP in Testing
8/21/2012 4:12:26 PM.
In this article we discuss how to modify a Database Checkpoint in QTP.
Delete Files with a SQL Job in SQL Server 2008
8/8/2012 12:28:37 AM.
Here I am going to discuss deleting files using SQL Job.
Conversion Functions Using SQL Query in SQL Server
7/2/2012 2:22:09 AM.
In this article you will see how to use conversion functions using SQL Query in SQL Server.
SQL Query Optimization FAQ Part 1 (With video explanation)
5/20/2012 4:20:41 AM.
In this article we will first try to understand what is a SQL plan, how is it created and then we will move towards understanding how to read the SQL plan. As we read the SQL plan we will try to understand different operators like table scan, index seek scan, clustered scan, RID lookup etc. We will also look in to the best practices associated with clustered and non-clustered indexes and how they function internally. We will practically see how indexed views increase performance and in what scenarios we should use the same.
Database Objects Information Using SQL Query in SQL Server
4/22/2012 12:34:18 PM.
In this article we will see how to get the Database objects Information using a query.
Using Temp Table in SQL Server And Adding Columns Dynamically
7/16/2011 12:26:04 PM.
In this article we'll see how to use the Temporary tables, what are the necessary step to be taken while using them and moreover sometimes it's required to add column in Temporary tables dynamically.
Dynamic Query to Search by Column Value in All Referencing Tables in SQL SERVER
7/12/2011 12:30:36 PM.
In this article I'll show you how to search a column value in all the referencing tables.
LINQ to SQL Stored Procedure
7/1/2011 3:19:16 AM.
In this Video you will see how to use LINQ to SQL Stored Procedure.
SQL Server Database Explorer
12/16/2005 5:18:36 AM.
This application connects to a running SQL Server 2000 and displays all the available databases in it.