Queries Resources

Share

Related resources for Queries

How Recursive CTE Works in SQL Server4/18/2024 1:16:02 PM. Recursive Common Table Expressions (CTEs) in SQL Server enable querying hierarchical data structures efficiently. Using the WITH clause, recursive CTEs define anchor and recursive members, facilitatin
Select Data Using Complied Query4/18/2024 11:13:18 AM. Learn how to optimize data retrieval in your application by utilizing compiled queries. This technique, often employed in Entity Framework and LINQ, enhances performance by pre-compiling queries, resu
Select Stored Proc With Raw SQL Query Via EDF Framework4/18/2024 10:43:47 AM. Utilize Entity Data Framework (EDF) for selecting stored procedures with raw SQL queries. Enhance data access in your application by leveraging the power of SQL alongside EDF's object-relational m
Select Data With Enums Via EDF Framework 5.04/18/2024 8:46:39 AM. Utilize Entity Framework 5.0 to select data with enums. Employ LINQ queries for efficient data retrieval, leveraging strong-typed enums for enhanced code readability and database querying.
MySQL Queries Cheat Sheet4/18/2024 3:54:25 AM. In this article, we will learn about MySQL querying essentials, covering basic SQL commands, data manipulation functions, constraints, and frequently asked questions, providing valuable insights for b
Table-Valued Parameters in SQL Server4/16/2024 5:42:55 AM. Table-Valued Parameters in SQL Server enable passing multiple rows of data to stored procedures, enhancing performance for bulk operations. Utilizing user-defined table types, they streamline data man
CRUD Operation with Dapper Using ASP.NET Core4/13/2024 5:08:16 PM. Using Dapper for CRUD operations in ASP.NET Core is straightforward and efficient. Dapper is a micro ORM that provides simple methods to execute SQL queries and map results to objects. Here's a ba
Enhance SQL Server Queries with OPTION(RECOMPILE) Hint4/11/2024 6:56:49 AM. This article provides an in-depth exploration of the OPTION(RECOMPILE) hint in SQL Server, offering developers and database administrators a thorough understanding of its functionality, practical appl
How to Use Stored Procedure in PHP4/5/2024 5:42:14 AM. Using stored procedures in PHP involves connecting to a database using MySQLi or PDO, preparing and executing SQL queries that call the stored procedures. Utilize parameterized queries for security an
Advanced Joins In SQL Server 20174/3/2024 10:50:44 AM. Explore the intricacies of SQL Server 2017 with advanced join techniques. Master inner, outer, cross, and self joins to optimize database queries. Elevate your SQL skills with join algorithms and quer
Media Queries in CSS3/19/2024 6:12:44 AM. This article elucidates the significance and functionalities of media queries, a prominent module of CSS3. It highlights how CSS3 introduces a plethora of built-in modules, including media queries, th
Media Queries For Mobile, Laptop, Desktop And iPad For Making Responsive Website Design3/19/2024 6:11:59 AM. Media queries enable responsive web design by adapting layouts based on device characteristics like screen size. Tailoring designs for mobile, laptop, desktop, and iPad ensures optimal user experience
Responsive Web Design Using Media Queries3/19/2024 6:11:25 AM. Responsive web design utilizes media queries to adapt layouts and styles based on the user's device characteristics, such as screen size and orientation. This ensures optimal viewing experience ac
Building a Responsive Website Template: HTML5 & CSS3 Media Queries3/19/2024 5:20:40 AM. In this article, I'll explain the nuts and bolts of responsive web designing and media queries. What? When? Why? I'll explain these questions in this article.
Responsive Website Design Using Media Queries3/15/2024 11:06:26 AM. Create responsive website designs with media queries, adapting layouts and styles based on device characteristics like screen size and orientation. Optimize user experience across various devices thro
Common Approaches To Responsive Design3/15/2024 11:02:24 AM. This article, Explores various strategies for responsive design, including CSS media queries, flexible layouts, and mobile-first approaches. Adapt your website's design to different devices seamle
Leveraging Compiled Queries for Enhanced Performance in LINQ3/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
The Amazing Adventure of MongoDB Queries2/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
Calculating Total and Average Sales in Fabric KQL 2/8/2024 11:29:57 AM. This video shows how to calculate Total and Average Sales by Account Manager by writing Kusto Query Language code in Microsoft Fabric.
Top 10 Most Used SQL Queries2/6/2024 6:39:43 AM. In this article you will learn about the top 10 most used SQL Queries. SQL Server is an interface which helps to communicate with the system’s database using queries.
SQL Joins for Efficient Database Queries2/5/2024 5:54:13 AM. Explore SQL joins, including inner, natural, left outer, right outer, full outer, and cross joins. Learn their usage, syntax, and differences to master relational database querying for effective data
Securing Your .NET Applications With Examples1/20/2024 11:16:24 AM. In the realm of software development, security remains a paramount concern. This is especially true for .NET applications, which often handle sensitive data and interact with critical systems. By adhe
How to Build an Interactive and Responsive Form12/28/2023 5:03:01 PM. Discover the world of web development with our latest tutorial on building a responsive and interactive form using HTML5, CSS3, and JavaScript. From the fundamentals of HTML5 to styling with CSS3 and
Optimizing SQL Queries: CTE vs Temporary Tables for Speed12/17/2023 7:22:44 AM. In Microsoft SQL Server, there are different methods to enhance query performance: Common Table Expressions (CTE) and temporary tables.
Row Constructors in PostgreSQL12/13/2023 4:27:10 AM. Explore the power of row constructors in PostgreSQL, enabling efficient row-wise data manipulation. This guide covers syntax, applications in SELECT, INSERT, UPDATE, DELETE statements, and common use
Exploring Kusto Query Language (KQL): Uses, Queries, and Unique Features12/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
Exploring MongoDB: Applications and Essential Queries11/30/2023 10:36:04 AM. In this article, we will explore MongoDB and delve into its applications, accompanied by an in-depth look at some of the most commonly used MongoDB queries.
GraphQL in .NET: GraphQL queries11/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
SQL UPDATE with JOIN10/30/2023 8:24:41 AM. This tutorial will show you the concept of SQL UPDATE With JOIN.
Optional Parameters in SQL Server10/26/2023 12:57:13 PM. Optional parameters in SQL Server refer to the capability of defining parameters within SQL queries that can be left unspecified or set to default values if not provided by the user. This feature enha
Elements Of Responsive Web Design10/19/2023 12:10:03 PM. Responsive web design ensures that users can access a website effortlessly, whether they are using a desktop computer, laptop, tablet, or smartphone. By dynamically adjusting the layout and content pr
Writing Managed Stored Procedures using C#9/18/2023 10:43:36 AM. This article is trying to explain the simple and required steps that are require starting the creation of Manage Stored Procedure using C# and using them.
Optimizing API Performance in ASP.NET Core Web API with MiniProfiler and Glimpse9/1/2023 8:25:56 AM. ASP.NET Core Web API's performance using tools like MiniProfiler and Glimpse. These tools are excellent for profiling and gaining insights into your application's performance, which can help y
Executing Dynamic SQL Queries8/25/2023 4:29:06 AM. Dynamic SQL: Defining and Executing Queries
No Likes And Range Queries In Cassandra8/22/2023 4:44:36 AM. Cassandra's design philosophy emphasizes efficient distributed data storage and retrieval using partition keys and clustering columns. While it may not support arbitrary substring matching (No Lik
Azure Stream Analytics Queries for Processing JSON Data8/21/2023 7:26:36 AM. Exploring Azure Stream Analytics Queries for Processing JSON Data
Subqueries in MySQL8/8/2023 11:01:38 AM. In this article we discuss how to use Subqueries in MySQL.
Handling Complex API Filter Queries in ASP.NET Core8/7/2023 5:48:12 AM. From this blog, you will learn how to integrate my composite filter solution into your ASP.NET Core web applications.
SQL Commands : DDL, DQL, DML, DCL, TCL with Examples 7/25/2023 6:08:58 AM. Master the art of SQL DDL commands, DCL commands, DQL commands, DML commands, TCL commands for effective database management.
Recursive Queries in SQL7/13/2023 4:42:42 AM. In this article we learn about recursive queries in sql.
How to Use Group by in MySQL6/21/2023 7:31:13 AM. Group by is a powerful feature in MySQL that allows you to group rows based on a specific column or set of columns. It is commonly used for generating summary reports and performing aggregations on la
Create Dynamic PIVOT Queries in SQL Server5/26/2023 9:53:00 AM. This article shows how to create a dynamic PIVOT query in SQL Server.
Calling a Stored Procedure in ASP.NET Core5/22/2023 5:46:00 AM.
Common Table Expression In SQL Server3/31/2023 6:44:32 AM. This article provides a practical guide to SQL CTE (Common Table Expressions), complete with examples that demonstrate how to use this powerful SQL feature to improve query performance and simplify co
Optimization Of Queries In SQL Server - HEAP TABLES3/8/2023 2:02:52 PM. This article will help you to understand how to start to think on optimization of sql queries and why use indexes in tables
Handling SQL Queries Using XAMPP Server3/7/2023 6:56:51 AM. XAMPP is a Free full-fledged development environment that lets you install the Apache web server, MariaDB database, Perl, and PHP scripting languages in one installation. It is a free solution stack f
Database Backup Using SQL Queries And Its Type3/7/2023 6:41:21 AM. How to make a backup of database using SQL queries in compressed and uncompressed condition or restoring database from backup using SQL queries and Difference between Compressed and Uncompressed
Using For XML Clause In SQL Queries3/7/2023 6:20:11 AM. For XML clause is used to convert the SQL result set into XML format. It is a very much helpful clause when we need XML data from the SQL result set. The FOR XML clause can be used in top-level querie
INTERSECTION in SQL Server2/28/2023 8:53:06 AM. Sometimes, we want to get a common set of rows from 2 different result sets. For example, we have 2 queries, and both return employee records. If we want to find which employees are present in both re
Weird Thing With Inner Queries in Sql Server 2/28/2023 6:29:19 AM. This article helps you understand how inner queries work in relation to outer queries and what problems they can create if not used in a proper manner.
Structured Query Language: Part 22/21/2023 6:10:46 AM. This article describes the use of different query and operator of SQL.
Saving and Reusing Your Custom Queries as Template Using Template Explorer in SQL Server2/20/2023 9:12:18 AM. In this article, we are going to see how to save your custom queries as a template and reuse the queries instead of saving as a file.
SQL Basic Queries2/16/2023 9:38:51 AM. In this article I will explain some basic SQL queries.
Important Queries in SQL2/16/2023 8:48:04 AM. In this article we learn some interesting and useful SQL queries.
Optimizing Queries For Faster Performance In SQL Server - A Step-By-Step Guide With Examples2/14/2023 10:36:17 AM. In this article, you will learn about Query Optimization in SQL Server.
Top 5 Tricky/Important SQL Queries And Their Answers2/14/2023 10:36:03 AM. In this article, you will learn about SQL Server Top 5 tricky/ important SQL Query with their answers.
Using SQL in .NET: Part 12/3/2023 9:18:38 AM. In this article, I will show you how to execute SQL queries from your C# applications.
Creating Subquery in SQL Server1/31/2023 3:14:25 PM. This article shows how to create a subquery to a select statement in SQL Server.
Complex SQL Queries With Split() Function in SQL1/31/2023 5:18:03 AM. In this article, you will learn about Complex SQL queries with the split() function in SQL.
SQL Injection In Dynamic SQL1/25/2023 6:15:42 AM. In this article you will learn about SQL Injection in Dynamic SQL.
Unlock the Secrets of the Rank Function in SQL Server1/18/2023 3:14:41 PM. Unlock the power of SQL Server and learn the essential rank functions to optimize your database. Get tips and tricks you can use immediately to maximize your SQL Server performance!
Elasticsearch Boolean Queries1/12/2023 1:28:15 PM. In this article, we will see how to write Boolean queries and how it is working in Elasticsearch.
SQL Server Useful Queries1/12/2023 1:26:11 PM. In this article, you will learn about SQL Server Useful Queries.
How To Optimize SQL Queries1/11/2023 11:30:29 AM. In this article, you will learn how to optimize SQL Query.
SQL - Interesting Queries (2)12/23/2022 4:57:45 AM. This article will discuss interesting queries, more.
SQL - Interesting Queries12/23/2022 4:55:57 AM. This article will discuss several most popular, complex, and interesting SQL queries and their solutions.
The Most Important SQL Queries For Beginners12/17/2022 6:20:46 PM. How do you get the data from the table? How do you create or drop the table? How do you display the different records? Do you want to? You can easily do all of this by writing a simple SQL query.
50 Important Queries in SQL Server12/8/2022 6:56:11 AM. In this article, you will learn about 50 Important Queries in SQL Server. EXEC sp_helpdb, exec sp_helptext, EXEC sp_updatestats, EXEC sp_MSforeachtable, SQL query for version name of SQL Server, Enabl
T-SQL Subqueries In Practice7/21/2022 8:17:52 PM. This article will demonstrate the two types of subqueries and their practical usage.
Advanced Entity Framework Core Tips In Practice: Context pooling, Lazy vs Eager loading, Single vs. Split Queries, Tracking vs. No-Tracking Queries1/11/2022 3:13:22 AM. Advanced Entity Framework Core Tips In Practice: Context pooling, Lazy vs Eager loading, Single vs. Split Queries, Tracking vs. No-Tracking Queries
Advanced Entity Framework Core - Output EF SQL Queries To The Console And Tips To Setup Dbcontext With The Development In Mind1/11/2022 3:12:51 AM. When you work with abstractions over SQL Database you may be wondering what does Entity Framework constructs from your Linq queries. To get a clue on it here are 3 options. Tips to setup DbContext wit
SQL Interview Questions - MSSQL7/1/2021 3:32:42 AM. Here is a list of the most popular MSSQL interview questions and answers explained. These SQL interview questions are for both beginners and professional MSSQL developers.
Important Queries In MySQL6/30/2021 11:19:35 AM. A list of Important Queries In MySQL. These queries are very useful whenever we face any difficulty in MySQL.
Detect Poor Performing Queries In Entity Framework 6.x1/6/2021 8:57:35 AM. In this article you will learn how to detect poor performing queries in Entity Framework 6.x.
Filters in MDX Queries10/30/2020 4:53:25 AM. This article explains filter conditions in MDX queries. There are so many conditions in MDX since we have SQL.
LINQ Queries9/2/2020 2:54:10 PM. In this article, you will learn about LINQ Queries.
Optimizing LINQ Queries In C#.NET For MS SQL Server 8/13/2020 7:44:03 AM. In this article, you will learn about some aspects of LINQ query optimization for MS SQL Server.
Delta Queries In Microsoft Graph API Using C#8/9/2020 11:34:28 PM. This article discusses Delta Queries in Microsoft Graph using C#.
Use Append Queries Feature In Power BI7/31/2020 7:55:38 AM. In this article, you will learn how to use the append queries feature in Power BI.
Media Only Queries in CSS35/7/2020 5:26:16 AM. CSS3 has added media queries functionality to media=screen that was added to CSS2. This article explores the media queries functionality.
SQLite Database in Android3/30/2020 5:12:22 AM. This article introduces SQLite databases in Android.
Executing SQL Queries And SQL Stored Procedure With ODBC10/4/2019 8:54:04 AM. In this article, you will learn how to execute SQL queries and SQL Stored procedure with ODBC.
Adding Subquery in a Select Statement in SQL Server 20126/20/2019 6:09:57 AM. Today, I have provided an article showing you how to add a subquery to a select statement in SQL Server 2012.
Useful SQL Queries6/13/2019 6:59:07 AM. In this article, we'll learn some basic but useful SQL queries.
Spatial Queries In Entity Framework Core6/3/2019 8:43:12 AM. In this article, you will learn about spatial queries in Entity Framework Core.
Most Asked SQL Queries In Interviews5/27/2019 9:20:20 AM. Do you wonder what the most frequently asked SQL queries are in interviews? Here is a list of most asked SQL queries interview questions.
Top 30 Important SQL Queries For Developers4/1/2019 9:21:52 AM. In this SQL article, I will introduce you to some important SQL queries and technical points. This article is a guide for you to learn the concepts related to SQL. It starts with the basic SQL queries
Sub Queries In SQL Server1/23/2019 11:43:58 AM. In this write-up, we will learn about subqueries in SQL Server. Subqueries are also termed as Nested queries.
Writing Complex Queries Using LINQ And Lambda6/26/2017 7:54:53 AM. I am writing this article based on request by some developers regarding how to write some complex queries using LINQ & Lambda expression which consist of joins / groupby / aggregate functions
LINQ Basic To Advanced - MVC Demo Application5/17/2017 5:44:49 PM. Here, in this post, we are going to see some basic and advanced LINQ queries
Cross Database Queries In Azure SQL5/6/2017 11:54:20 AM. In this article, you will learn about cross database queries in Azure SQL.
Accessing SQL From Entity Framework Core Queries In ASP.NET Core2/4/2017 2:17:14 AM. In this article, you will learn how to access SQL from Entity Framework Core Queries in ASP.NET Core.
Compile Queries And Execute SQL Queries Using LINQ To SQL1/8/2017 11:18:03 PM. In this article, you will learn how to compile queries and execute SQL queries, using LINQ to SQL.
How To View LINQ To SQL Generated SQL Queries And Using Stored Procedures With LINQ To SQL 1/2/2017 8:51:02 AM. In this article, you will learn how to view LINQ to SQL generated SQL queries and use stored procedures with LINQ to SQL.
How To Run Interactive Spark SQL Queries On Apache Spark Hdinsight Linux Cluster12/31/2016 12:21:23 PM. In this article, you will learn how to run Interactive Spark SQL queries on Apache Spark HDinsight Linux cluster.
SharePoint 2013 - Important SQL Queries On SharePoint Content Databases - Part Two12/12/2016 11:18:47 AM. This second part of this article presents you with some more of the important queries that you can use to query SharePoint content databases.
SharePoint 2013 - Important SQL Queries On SharePoint Content Databases - Part One12/8/2016 11:24:43 AM. This article presents you with some of the important queries that you can use to query SharePoint content databases.
Learn MySQL Queries With Examples6/23/2016 11:21:20 AM. In this article, you will learn select, update and delete statements in MySQL queries with examples.
MongoDB Tutorial - Queries: Part Two6/7/2016 11:45:58 AM. In this article, we will see some MongoDB specific queries.
Basic SQL Queries For Beginners6/3/2016 12:06:38 AM. In this article you will learn Basic SQL Queries for Beginners.

Topics