SQL queries Resources

Share

Related resources for SQL queries

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
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
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
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 UPDATE with JOIN10/30/2023 8:24:41 AM. This tutorial will show you the concept of SQL UPDATE With JOIN.
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.
Executing Dynamic SQL Queries8/25/2023 4:29:06 AM. Dynamic SQL: Defining and Executing Queries
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.
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
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
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
Structured Query Language: Part 22/21/2023 6:10:46 AM. This article describes the use of different query and operator of SQL.
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.
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.
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!
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
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.
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.
Useful SQL Queries6/13/2019 6:59:07 AM. In this article, we'll learn some basic but useful SQL queries.
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.
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.
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.
Basic SQL Queries For Beginners6/3/2016 12:06:38 AM. In this article you will learn Basic SQL Queries for Beginners.
Useful SQL Queries For SharePoint Practitioners3/11/2016 9:45:15 AM. In this article you will learn useful SQL Queries for SharePoint practitioners.
SQL Basic Query1/31/2016 11:43:06 PM. In this article I will explain some basic SQL queries.
CRUD Operations In SQL Server 200810/5/2015 2:32:33 AM. In this article l will show you how to make CRUD operations in SQL Server 2008 by using simple SQL queries.
Some Practical Useful SQL Queries For SharePoint Adminstrator2/26/2014 12:36:55 PM. In this article, I will share some very practical and useful SQL queries that a SharePoint administrator will require.
Generate LINQ, SQL Queries With LINQPad7/2/2013 2:26:56 PM. In this article I am sharing how to generate a LINQ query with a very facilitative tool, LINQPad.
Adding Editor, and Deleting data in Web Forms using ADO.NET 2/11/2010 12:35:31 AM. In this article I will explain Adding Editor, and Deleting data in Web Forms using ADO.NET.
Data Access through Web Services, Stored Procedures and SQL Queries12/16/2005 7:46:57 AM. Web Services has been the most revolutionary aspect of the .NET framework developed by Microsoft. This article presents the three different modes through which data can be accessed viz. through Web services, stored procedures and SQL query using the power of ADO.NET and XML.

Topics