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 uery
Share
facebook
twitter
linkedIn
Reddit
Topics
No topic found
Content Filter
Articles
Videos
Blogs
News
Complexity Level
Beginner
Intermediate
Advanced
Refine by Author
[Clear]
Abiola David (12)
Yogi S (6)
Mohammad Hussain (6)
Alpesh Maniya (4)
Monica Rathbun (2)
Jignesh Trivedi (2)
Pratik Somaiya (2)
Aradhana Tripathi (2)
Sabyasachi Mishra (2)
George (2)
Prashant Bansal (2)
Sandeep Singh Shekhawat (2)
Allam Purushotham (1)
Rathrola Prem Kumar (1)
Sarathlal Saseendran (1)
Rohini Parade (1)
Debasis Saha (1)
Geo J Thachankary (1)
Bryian Tan (1)
Sai Sherlekar (1)
Naveen Kumar (1)
Jean Paul (1)
Samir Behara (1)
Ajay Kumar (1)
Abhishek Yadav (1)
Dinesh Gabhane (1)
Rakesh (1)
Hadshana Kamalanathan (1)
Mrunali Sawant (1)
John Kocer (1)
Dr Gomathi (1)
Sanjeev Vishwakarma (1)
Subarta Ray (1)
Jaimin Patel (1)
Tural Suleymani (1)
Abhimanyu K Vatsa (1)
Harshal Limaye (1)
Mithilesh Kumar (1)
Jefferson S. Motta (1)
Deepak Tewatia (1)
Afsar Uddin (1)
Sriram Kumar Mannava (1)
Ahmad Mozaffar (1)
Simran Verma (1)
Jobin S (1)
Saravanan Ganesan (1)
Yatendra Sharma (1)
Shilpa Tanwar (1)
Vipin Yadav (1)
Vithal Wadje (1)
Scott Lysle (1)
Vipin Mittal (1)
Oscar Santos (1)
Satyaprakash Samantaray (1)
Jochen Bartlau (1)
Raj Bhatt (1)
Pragya Vats (1)
Dhanapal Chandran (1)
Asma Khalid (1)
Deepak Sharma (1)
Mahesh Chand (1)
Amit Mohanty (1)
Anand Lakshminarasimh (1)
C# Curator (1)
Mudita Rathore (1)
Ravi Raghav (1)
Vishal Babuks (1)
Jignesh Kumar (1)
Related resources for uery
No resource found
What Is Automatic Tuning In Azure SQL Database
3/28/2024 6:37:39 AM.
Microsoft has long given us DBA tools and suggestions to help tune databases, to fix queries with indexes, and many times they were of questionable merit. We have all seen the dreaded dta_index names
What Is Date Correlation Optimization?
3/28/2024 6:27:07 AM.
OK So, I am doing some digging and peaking around again in SQL Server and came across a database option called Date Correlation Optimization Enabled = False. Honestly, I had no clue what it did, so I
Deletion of Record using Power Shell Script with FetchXML Query in D365
3/23/2024 4:14:02 PM.
Deletion of Contact Record using Power Shell Script with FetchXML Query in D365
Why GraphQL Is An Alternative Over React API
3/21/2024 6:26:24 AM.
GraphQL offers a more flexible and efficient approach compared to traditional REST APIs, especially when integrated with React. With GraphQL, frontend developers can request only the data they need, r
Querying Azure SQL Databases In Databricks Spark Cluster
3/13/2024 8:44:48 AM.
We will see the entire steps for creating an Azure Databricks Spark Cluster and querying data from Azure SQL DB using JDBC driver. Later we will save one table data from SQL to a CSV file.
Benefits of Temporary Tables over Table Variables in SQL Server
3/10/2024 8:15:37 AM.
The article explores the advantages of utilizing temporary tables over table variables in SQL Server. It discusses how temporary tables offer better performance, scalability, and flexibility for handl
Leveraging Compiled Queries for Enhanced Performance in LINQ
3/9/2024 9:17:22 AM.
Compiled queries in LINQ allow developers to pre-compile LINQ queries into executable delegates, reducing the overhead of query compilation and optimization. By caching the compiled query execution pl
Entity Framework Core 5.0 - An Introduction To What's New
3/7/2024 11:26:50 AM.
Discover the latest features in Entity Framework Core 5.0, including improved performance, enhanced LINQ capabilities, migration enhancements, and streamlined database schema management.
New Features Of Entity Framework Core 2.0
3/7/2024 8:53:53 AM.
Entity Framework Core is a lightweight and extensible version of Entity Framework. It is based on an ORM (Object-Relational Mapper) which enables us to work with databases using .NET objects. This art
Shadow Properties In Entity Framework Core
3/7/2024 8:52:35 AM.
In this article, you will learn Entity Framework Core's shadow properties, and hidden fields in the model that aren't mapped to the database schema directly. Learn how to leverage them for met
ASP.NET MVC Tooltip with Web API, Bootstrap Popover, jQuery UI Dialog
3/7/2024 8:41:29 AM.
This article provides a detailed guide on dynamically adding help/tooltip icons to form elements using jQuery UI modal or Bootstrap popover. The tooltips are fetched from a centralized location via We
Practical Introduction To Entity Framework: Day 3
3/6/2024 10:32:09 AM.
Day 3 of this practical Entity Framework introduction delves into database transactions, query optimization, and advanced EF features. Learn to manage relationships, optimize data models, and fine-tun
Understanding FORMATMESSAGE() Function in SQL Server
3/6/2024 4:58:24 AM.
In this article, we will discuss how to use FORMATMESSAGE() function in SQL Server, its advantages and usages with example.
SharePoint 2010 Search Alerts
3/5/2024 10:24:14 AM.
This article explores the Search Alerts feature of SharePoint, which allows users to save queries and receive notifications via email or RSS feed when content matching the query is found. It discusses
SQL CTE to Rank Sales by Products using Fabric Data Warehouse
3/5/2024 5:03:37 AM.
This video shows how to author Common Table Expressions in Fabric Data Warehouse to Rank Sales by Products.
Improving SQL Performance Using Covering Indexes
3/4/2024 11:29:49 AM.
In this article we will try to understand what a covering index is, how to avoid the expensive key lookup operations, and how it can improve our T-SQL performance multi fold times.
SQL Tuning - Effective Strategies with Practical Examples
3/3/2024 5:01:15 AM.
SQL Tuning — Effective Strategies with Practical Examples
Effortless Pagination with jQuery DataTables and Bootstrap
2/28/2024 9:02:53 AM.
Effortless pagination with jQuery DataTables and Bootstrap offers seamless integration, providing a plug-and-play solution for front-end development. It enhances the user interface with responsive des
Quick SQL Refresher
2/28/2024 4:39:54 AM.
The Quick SQL Refresher provides a concise cheat sheet for SQL, covering essential concepts, keys, commands (DDL, DML, DQL, DCL, TCL), constraints, clauses, T-SQL fundamentals, joins, functions, excep
ASP.NET State Management
2/18/2024 5:38:25 AM.
State management in ASP.NET is vital for maintaining application state across requests. It's a common topic in interviews, catering to both novices and seasoned developers. ASP.NET offers various
Local Temp Tables, Global Temp Tables, Table Variables, and CTEs Comparison
2/12/2024 9:53:11 AM.
In SQL database management, optimizing data storage is vital for efficient query execution. Local and global temporary tables, table variables, and CTEs are versatile options for temporary data storag
Analysis of T-SQL and PL/SQL
2/12/2024 4:03:24 AM.
This article delves into the distinctions between Transact-SQL (T-SQL) and PL/SQL, examining their origins, syntax, functionality, and optimization strategies. Explore their unique features for effici
New Modifications and Improvements to the Azure Stream Analytics No-Code Editor
2/11/2024 8:22:36 AM.
Explore real-time analytics with Azure Stream Analytics, a Microsoft Azure service for processing and analyzing streaming data. Learn about input sources, SQL-like query language, output destinations,
The Amazing Adventure of MongoDB Queries
2/9/2024 9:21:46 AM.
This content provides an engaging analogy of MongoDB queries as an adventurous quest through a treasure-filled city. It introduces concepts like planning the query as preparing a treasure map, executi
Getting Started With ASP.NET Core And jQuery CRUD Using WEB API
2/9/2024 7:23:23 AM.
A lab exercise for you to demonstrate what have you learned from this training material to create your own Todo CRUD operation using TodoRepository included in this training material.
Supported File Types for Data Ingestion into KQL Database in Fabric
2/6/2024 10:04:20 AM.
This article is about Understanding the Supported File Types for Data Ingestion into the KQL Database in Fabric Real-time Analytics. Supported file types include JSON, CSV, XML, & Text. Note: XLSX
Mastering T-SQL Rank Functions
2/6/2024 9:28:41 AM.
SQL window functions like ROW_NUMBER, RANK, DENSE_RANK, and NTILE are vital for advanced data analysis. They organize, order, and rank data within result sets. ROW_NUMBER assigns unique sequential nu
Clean and Transform Data using M Code Stored in Text File
2/5/2024 8:32:26 AM.
In this video, I showed how to clean and transform data using M code stored in Text file in excel
Optimize SQL Database Performance
2/1/2024 8:40:21 AM.
"Unlocking Database Efficiency: A Guide to Performance Optimization in SQL" is a concise and insightful resource that provides practical guidance on enhancing the efficiency of SQL databases
Create a Workspace in Fabric
1/15/2024 5:12:14 AM.
This article explains how to create workspaces in Microsoft Fabric. In workspaces, you create collections of items such as lakehouses, warehouses, and reports.
Understanding Collection Types in C#
1/9/2024 4:35:29 AM.
Delving into collection types like IEnumerable and IQueryable in C# unveils their impact on data querying efficiency. While IEnumerable offers simplicity for in-memory operations, it might load unnece
Query to Find and Drop User-Defined Stored Procedure
1/3/2024 9:53:53 AM.
In this article, we will learn about dangerous SQL scripts that iterate through user-defined stored procedures, views, functions, and user-defined types, dropping them one by one. Caution: Do not run
Creating Dynamic PIVOT Query in SQL Server
12/23/2023 11:50:26 AM.
In this article, we are going to learn how to create dynamic PIVOT Query in SQL Server with some examples.
Inner Join SQL Query in Fabric Notebook using PySpark
12/22/2023 5:15:40 AM.
This video shows how to write inner join SQL Query in Microsoft Fabric Notebook using Spark.
Exploring Kusto Query Language (KQL): Uses, Queries, and Unique Features
12/1/2023 5:09:29 AM.
Kusto Query Language (KQL) is a potent tool developed by Microsoft for diverse data analytics needs. Uncover its applications across industries, from log analytics to IoT, and explore essential querie
New DAX Query View in Power BI Desktop
11/28/2023 4:15:58 AM.
This video showcases the new DAX query view in Power BI Desktop November 2023 updates.
Display Loading or Processing Message Inside DataTable
11/27/2023 6:52:34 AM.
displays a loading screen while data is being loaded into a DataTable using JavaScript, you can use a combination of HTML, CSS, and JavaScript. Below is a simple example demonstrating how you can achi
GraphQL in .NET: GraphQL queries
11/22/2023 7:02:01 AM.
Learn graphQL queries, resolvers, and annotation-based approach. This tutorial introduces GraphQL, emphasizing its benefits over REST, and explores querying in a C# ASP.NET Core environment using HotC
Fabric Data Warehouse: Save as Table and Analyze Result Functionalities
11/22/2023 3:53:08 AM.
In this article, we'll delve into the Microsoft Fabric Data Warehouse features: Save as Table and Analyze Result. These functionalities offer users and analysts several advantages in terms of data
Analyzing Sales Data with a Comprehensive SQL Query in Microsoft Fabric Data Warehouse
11/18/2023 4:28:22 AM.
This SQL query is a powerful tool for in-depth sales analysis, utilizing joins and aggregations to break down sales data by account manager, payment type, and region in Microsoft Fabric Data Warehouse
GET and POST Calls to Controller's Method in MVC
11/17/2023 9:53:06 AM.
In this article I am going to cover some really interesting material that is very useful today in web application development. You will learn how to make jQuery Ajax GET and POST calls to controller m
How To Use Query Parameters In Angular
11/15/2023 11:26:44 AM.
In this tutorial, we'll be looking at Query Parameters feature in Angular which lets you pass data from one route to another.
Cascading Dropdown List Of Country, State And City Using MVC, Web API And jQuery
11/15/2023 9:09:46 AM.
Today, in this article, I will explain how to create a Cascading dropdown list using MVC, Web API and jQuery.
Learn to Avoid Query Governor Cost Limit Error in SQL Server
11/13/2023 7:08:56 AM.
Learn to solve "The query has been canceled because the estimated cost of this query... "
Get IBM and Microsoft Daily and Weekly Historical Stocks Data from API
11/10/2023 6:43:11 AM.
Get IBM and Microsoft Daily and Weekly Historical Stocks Data from API.
Fetch Data from Azure Data Explorer of the Kusto Microsoft Fabric Database in Excel
11/7/2023 5:19:43 AM.
In this video, I demo how to fetch data from azure data explorer of the kusto Microsoft Fabric database in Excel.
What is SQL Server Management Studio (SSMS)
11/7/2023 4:14:32 AM.
SQL Server Management Studio (SSMS) is a tool used to manage and develop Microsoft SQL Server databases. It provides a graphical interface for connecting to servers, creating and modifying database ob
Sales Data Analysis using Power Query Expressions
11/3/2023 4:59:08 AM.
This video shows how to analyse sales data using power query expressions.
Improving SQL Table Data Performance
11/1/2023 12:11:56 PM.
This article discusses strategies and best practices for optimizing SQL table data performance. Topics covered include indexing, normalization, partitioning, data types, query design, monitoring, hard
How to Implement Continuous Querying with NCache?
10/20/2023 1:06:48 PM.
In this detailed article, let us discuss how we can implement continuous querying with NCache.
Creating a Calendar Table in Excel Power Query and its Benefits
10/20/2023 9:20:07 AM.
This blog is based on Creating a Calendar Table in Excel Power Query
Three Popular C# Interfaces
10/12/2023 11:53:45 AM.
In this article, you will learn about the most common interfaces in the C# Libraries that you can use to create robust classes and objects.
Model Binding in ASP.NET Core
10/11/2023 8:34:10 AM.
Model Binding in ASP.NET Core for Simplifying Data Interaction
jQuery PJAX Implementation In ASP.NET Core
10/11/2023 4:57:25 AM.
You can make an entire website work asynchronously using PJAX plugin of jQuery. I will show you how to implement it in ASP.NET Core.
Check/Uncheck All GridView Checkboxes With jQuery
10/11/2023 4:53:48 AM.
jQuery: Check and Uncheck all checkboxes inside GridView with parent checkbox.
How To Call Stored Procedure In Entity Framework
10/10/2023 8:44:08 AM.
In this article, I will demonstrate how to call a stored procedure in entity framework? There are many different way to call stored procedure from entity framework.
7 Ways To Avoid jQuery .each() Method With An Equivalent JavaScript .forEach() Method
10/5/2023 9:57:42 AM.
This tutorial explains the 7 important ways to work with the JavaScript .forEach() method so that you can replace your jQuery .each() method's code with it.
Calling A C# Function With jQuery AJAX In ASP.NET MVC
10/5/2023 9:54:04 AM.
This article explains how to use jQuery AJAX method in ASP.NET MVC.
Bind GridView Using jQuery Load In ASP.NET With No Page Reload
10/5/2023 4:53:51 AM.
This tutorial explains how to bind GridView with no page reloading, using jQuery Load method.
Understanding LINQ in C#: Query Syntax and Method Syntax
10/3/2023 8:28:47 AM.
This article is an informative and in-depth exploration of LINQ (Language Integrated Query) within the context of C#, a widely used programming language in the software development industry. The guide
Delete records from GridView without Page Reload using jQuery
10/3/2023 5:39:36 AM.
In this article, we will use jQuery to delete records from GridView so that their is no page reload. The codes developed here can be copied and used in any of your web application.
Calculating Sales Amount by Product Category in DAX and Power Query
9/27/2023 8:58:27 AM.
In this video, I demonstrated how to write the DAX formula and using the GUI in Power Query to calculate Sales Amount by Product Category.
Kusto Query Language (KQL) for Azure IoT
9/25/2023 10:18:00 AM.
Kusto Query Language (KQL) empowers Azure IoT projects with real-time data analysis, flexible exploration, aggregation, and seamless Azure service integration. It's pivotal in extracting insights
How To Use Query Strings In ASP.NET
9/25/2023 6:42:41 AM.
In this article, we will learn how to use Query Strings in ASP.NET Websites.
Power BI Query Folding
9/22/2023 5:21:57 AM.
Query Folding in Power BI is a performance-enhancing feature that optimizes data analysis. It pushes data transformations to the source, improving data refresh and incremental processes. Learn how it
Delegation in Power BI
9/18/2023 6:26:06 AM.
Delegation in Power BI streamlines data processing by shifting tasks to the data source, enhancing efficiency and scalability, especially with large datasets. Learn key aspects of this essential conce
GraphQL in Next.js
9/15/2023 11:43:53 AM.
Here we will give the description how to setup GraphQL with Next.js.
Power BI Data Transformation Basics for Insights
9/12/2023 10:29:21 AM.
Power BI Power Query Basics Transforming Data for InsightsPower Query is a data transformation tool in Microsoft's Power BI suite. It connects, cleans, and shapes data from diverse sources, enabli
Stored Procedure in SQL Server
9/12/2023 7:29:06 AM.
A stored procedure is a reusable collection of SQL statements stored on the database server. It simplifies code maintenance and execution. Stored procedures can be invoked by triggers, other procedure
Calling Any Stored Procedure In ADO.NET
9/10/2023 9:36:17 PM.
This one generic function can call any Stored Prodedure which take input parameters and return output parameters with the help of two-dimensions array. This is very helpful specially when you designin
Power BI Interview Question and Answer
9/8/2023 9:02:52 AM.
Power BI components, differences between Power BI Desktop and Service, query optimization techniques, DAX functions, report creation steps, data model optimization, design best practices, security mea
Creating AutoComplete TextBox In ASP.NET MVC 5
9/5/2023 6:55:22 AM.
In this article we will learn how to create the AutoComplete TextBox in ASP.NET MVC using jQuery UI .
Determine the Time since the Last Boot Up in C#
9/5/2023 5:26:06 AM.
This article describes an approach used to determine the time of the last system boot up and to display the time elapsed since boot up.
Conditional INSERT, UPDATE, DELETE with MERGE Query
9/4/2023 4:54:52 AM.
The MERGE statement is a versatile SQL command used for conditional INSERT, UPDATE, or DELETE operations, streamlining database management tasks efficiently in a single query.
Exploring Azure Cognitive Search's Power
9/2/2023 7:15:04 PM.
This article demonstrates the transformative prowess of Azure Cognitive Search, a technological marvel that is reshaping the way we interact with data in our data-driven world. With its advanced capab
Call Web API in .NET and Filter Data using Bootstrap Filters with Less Code
8/27/2023 12:14:42 PM.
We can filter records for each columns in table with single textbox or search. With less code and few mins, We can implement that feature to work on complex data.
Add And Delete HTML Table Rows Dynamically Using ASP.NET
8/24/2023 10:02:18 AM.
This article demonstrates how to add and delete HTML table rows dynamically at run time and save all the rows into the database.
CRUD Operations Using Ajax - Part 2
8/24/2023 9:56:41 AM.
This articles explains CRUD operations in ASP.NET using Ajax. It is part-2 of the series.
Using Langchain and OpenAI APIs in Python to Query Your Docs
8/23/2023 11:02:12 AM.
Using the APIs from OpenAI and the langchain project, it is quite easy to implement a bot that is fed with your documentation and other product information. The answers of the bot are then specific fo
Exploring the Diverse Flavors of LINQ with Examples
8/22/2023 11:52:01 AM.
LINQ is a powerful feature in modern programming languages like C# that allows developers to perform queries on different types of data sources using a consistent syntax. With LINQ, you can query and
Query Processing In DBMS
8/22/2023 6:35:27 AM.
Query Processing in DBMS is the approach of selecting the best strategy or plan which can be used to respond to a database request.
Power BI Data Mart: Features, Limitations, and Best Practices
8/22/2023 6:06:12 AM.
Power BI Data Mart: Features, Limitations, and Best Practices
How to Get Query String in JavaScript
8/22/2023 5:30:56 AM.
This article will discuss using JavaScript to get Query String from a Web Page.
Azure Stream Analytics Queries for Processing JSON Data
8/21/2023 7:26:36 AM.
Exploring Azure Stream Analytics Queries for Processing JSON Data
Set Status Bar Color for SQL Server Query Editor
8/18/2023 6:05:39 AM.
This article will discuss how to set status bar color for a SQL Server Query Editor
ASP.NET MVC 5 - Time Picker Plugin
8/16/2023 4:22:24 AM.
This article is about integration and basic usage of the Bootstrap Time Picker jQuery plugin in ASP.NET MVC5 platform.
How to Select Employees Who Were Born on the Last Day of the Month?
8/10/2023 7:24:21 AM.
To select employees who were born on the last day of the month from a database or employee records, you'll need to use SQL or a similar query language to filter the data based on the birth dates.
What Is A Network Database?
8/10/2023 7:00:36 AM.
Network databases represent data in a tree-like structure. In this article, we'll learn basics of hierarchical database management systems and how data is represented and stored in a hierarchical
Data Gateway in Power BI
8/7/2023 6:57:07 AM.
Unlock the potential of on-premises data with the Power BI Data Gateway. This comprehensive guide explores its core capabilities, installation, security, troubleshooting, and future roadmap for hybrid
How to Optimize SQL Server Query Performance
8/5/2023 10:16:35 AM.
How to Optimize SQL Server Query Performance.
Object Relational Mapping (ORM) Using NHibernate - Part 5 - A of 8
8/4/2023 11:39:30 AM.
This is Part 5A of the article series, which concentrates on Many-to-Many Entity Association with a commonly used example but the model and code is a little different.
Salesforce SOAP API: POST Request With SOQL Query Envelope [Custom SObjects]
7/30/2023 5:23:49 AM.
In this article, we will discuss the detailed steps on executing SOQL queries for Custom Salesforce SObjects using SOAP API. In this demo, we will look into how to query fields with lookup relationshi
Sliders in jQuery
7/28/2023 7:09:34 AM.
In this article we will see how to create a slider in jQuery with CSS. I explain the single Indicator slider that displays a value on movement.
jQuery Slider Examples
7/28/2023 6:57:13 AM.
In this article we look at how to create two-indicator Sliders and get values for both indicators, then how to set opacity of an image using a slider.
Salesforce SOAP API: POST Request With SOQL Query Envelope [Standard SObjects]
7/27/2023 11:11:56 AM.
In this article, we will discuss the detailed steps on executing SOQL queries for Standard Salesforce SObjects using SOAP API Query Envelopes.
50 SQL Server Interview Questions Guaranteed to Help You In 2023
7/25/2023 7:16:19 AM.
A complete guide of top SQL Server interview questions and answers that will help pass your SQL Server interview.
Model Validation in Backbone.js With jQuery
7/20/2023 6:37:46 AM.
This article explains Model Validation in Backbone with jQuery.
EF Core in .NET 7 API
7/13/2023 5:57:14 AM.
Using EF Core in .NET 7 API
Rest Assured API Automation Testing Concepts
6/29/2023 9:57:55 AM.
This article provides an overview of various concepts related to API automation testing using the Rest Assured library. It covers topics such as sending query parameters and path parameters, handling
Difference Between =, == And === In JavaScript
6/27/2023 10:50:54 AM.
In this article I am going to explain what is difference between =, == and === in JavaScript.