Congratulations - C# Corner Q4, 2022 MVPs Announced
Why Join
Become a member
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
TECHNOLOGIES
ANSWERS
LEARN
NEWS
BLOGS
VIDEOS
INTERVIEW PREP
BOOKS
EVENTS
Training
Live
JOBS
MORE
CAREER
MEMBERS
About SQL
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)
Pankaj Kumar Choudhary (6)
Naresh Beniwal (5)
Akshay Patel (5)
Jignesh Trivedi (5)
Sourav Kayal (4)
Rakesh Kalluri (4)
Amit Choudhary (3)
Sandeep Singh Shekhawat (3)
Mahesh Alle (3)
Gagan Sharma (2)
Syed Shakeer (2)
Abhishek Yadav (2)
Uday Dodiya (2)
Kirtesh Shah (2)
Raj Kumar (1)
Hemant Srivastava (1)
Dorababu Meka (1)
Jay Smith (1)
Jainish Shah (1)
Manikavelu Velayutham (1)
Richa Garg (1)
Mageshwaran R (1)
Gaurav Kumar Arora (1)
Aradhana Tripathi (1)
Priti Kumari (1)
Surjeet Yadav (1)
Kumar Saurabh (1)
Subal Mishra (1)
Monica Rathbun (1)
Naveed Zaman (1)
Akkiraju Ivaturi (1)
Mohammad Elsheimy (1)
Venkatesan Jayakantham (1)
Sudheendra Rao Bilamkar (1)
Deepak Middha (1)
Satyaprakash Samantaray (1)
Shashi Ray (1)
Ratnesh Singh (1)
Abhijit Patil (1)
Santosh Gadge (1)
C# Curator (1)
Ripon Datta (1)
Anupam Maiti (1)
Santosh Kumar Adidawarpu (1)
Narendra Singh (1)
Mahesh Chand (1)
Prakash Kumar Sahoo (1)
Deepak Tewatia (1)
Saineshwar Bageri (1)
Deepak Sharma (1)
John Charles Olamendy (1)
Jasminder Singh (1)
Lajapathy Arun (1)
Shivprasad (1)
Parthiban Selvaraj (1)
Shaili Dashora (1)
Vivek Kumar (1)
Arun Choudhary (1)
Sibeesh Venu (1)
Related resources for SQL
No resource found
How to Use Full Text Search in SQL Server
2/7/2023 10:29:47 AM.
This article demonstrates how to use a full-text catalog and full-text search in SQL Server.
System Views in SQL
2/7/2023 10:17:02 AM.
Views are very important and useful features of SQL. Let's learn what views are exactly.
Displaying Line Numbers In SQL Query Editor
2/7/2023 9:43:44 AM.
In this article, we will discuss about the option of displaying Line Numbers in the SQL Server Query editor.
Display Line Numbers in SQL Server Query Window
2/7/2023 9:24:41 AM.
In this article, we have a look at how to enable line numbers in the SQL Server Query Window.
How To Get SQL Server Database Size In C#
2/7/2023 8:58:25 AM.
This article shows how we can determine the size of an entire database using C# and the size of each and every table in the database using a single SQL command.
Implementing CRUD Operation in MySql Using Entity Framework
2/7/2023 8:52:11 AM.
In the last article I showed how we can implement CRUD operations using Entity Framework using SQL database, now I would like to show you how we can implement the same using MySql database.
SQL BETWEEN Statement
2/6/2023 3:57:46 AM.
In this article, you will learn how to use a SQL Between statement in SQL
SQL Cast And Convert Statement
2/6/2023 3:55:53 AM.
In this article, you will learn how to use Cast and Convert statement in SQL.
Using SQL in .NET: Part 1
2/3/2023 9:18:38 AM.
In this article, I will show you how to execute SQL queries from your C# applications.
SQL For Beginners - SELECT Statement
2/3/2023 8:59:03 AM.
This article will help you to learn about SELECT statements in SQL.
SQLCLR vs. T-SQL - Performance Comparison
2/3/2023 8:44:05 AM.
Before comparing the performance of SQLCLR and TSQL, just have a quick at the definition of SQLCLR.
Combining More Than One Rows Into a Single Row in SQL Server 2005
2/3/2023 8:22:33 AM.
In this article, I will explain how to merge multiple rows into a single row using SQL 2005.
Execute A Stored Procedure Programmatically
2/3/2023 8:10:44 AM.
In this article, I will explain how to create a Stored procedure (SP) and execute an SP programmatically.
Encrypt and Decrypt in SQL Server: Part 1
2/3/2023 8:00:29 AM.
In this article, we will discuss Service Master Key, backup, restore and alter Service Master Key.
CLR Stored Procedures in SQL Server
2/3/2023 7:57:46 AM.
In this article, we will learn about CLR Stored Procedures in SQL server.
Step-by-step Create CLR Stored Procedure
2/3/2023 7:12:36 AM.
In this article we will create a CLR stored procedure step by step.
Filtered Indexes in SQL Server
2/3/2023 6:28:25 AM.
SQL Server 2008 introduced Filtered Index. It is nothing but an optimized non-clustered index.
Indexes In SQL Server
2/3/2023 2:46:48 AM.
This article explains about Indexes and when and how to use them
SQL Magic: How to Use Select Distinct in SQL to Get Unique Results Every Time
2/2/2023 8:29:29 PM.
Learn about the SQL SELECT DISTINCT statement and its uses for retrieving unique data in SQL. Get expert insights on how to implement select distinct SQL queries
SSRS Parameter Validation Using Custom Code
2/2/2023 10:19:47 AM.
This article explains how to apply validation on an SSRS parameter and display a user-readable error message.
Dynamic Query to Search by Column Value in All Referencing Tables in SQL SERVER
2/2/2023 9:04:08 AM.
In this article I'll show you how to search a column value in all the referencing tables.
Compound Operators in SQL Server
2/2/2023 8:55:42 AM.
In this article, you will learn some basics about Compound Operators of SQL Server.
Explain SQL Joins
2/2/2023 7:22:37 AM.
In this article you will learn about Join statements of SQL server.
Out of Process Session State - In SQL Server
2/2/2023 6:23:59 AM.
In this article, I am explaining, with a sample demo, storing Session State in a local or remote SQL Server.
SQL-CLR For Beginners: Part-5: Call Function and Procedure From Other Procedure
2/2/2023 5:13:18 AM.
In today’s article, we will learn how to call store procedure and user-defined function ( UDF in Database) from store procedure.
PL/SQL Best Practices
2/2/2023 4:51:54 AM.
This article lists some important SQL Best Practices with examples.
Tempdb Performance Improvements in SQL Server 2022 are Dramatic
2/1/2023 3:31:54 PM.
Tempdb is always a topic for me whether it’s in my sessions or blogs I have written. However, I’ve never been so excited about it then I am when it comes to the dramatic performance changes introduced
Using Filter Settings Option in SQL Server
2/1/2023 10:32:17 AM.
In this article I provide a quick overview of how to use Filter Setting in SQL Server.
CASE Statement In Transact-SQL
2/1/2023 10:07:12 AM.
In this article, I am going to explain the case statement in Transact-SQL and how to sort table data using the case statement
Secured Connection Between SQL Server and C# Using Specific Port
2/1/2023 9:08:19 AM.
In this article, we will discuss how to get the port no of our own SQL Server instance and how to use that port in the SQL Server setting, and at the end how to use that port in your C Sharp applicati
Handling Concurrency Data Insertion Operations in MySQL
2/1/2023 8:41:12 AM.
This article discusses how to create databases and tables in MySQL. More emphasis is placed on how to get the details of the latest inserted ID and also the usage of appropriate functions in the case
Working with SQL Server BLOB Data in .NET
2/1/2023 6:48:33 AM.
In this article learn how to store and retrieve binary data in a SQL Server or Access 2007 databases.
How to Index a Table Variable in SQL Server
1/31/2023 9:15:33 PM.
In this article, you will learn how to use Index Table variables in SQL Server.
Creating Subquery in SQL Server
1/31/2023 3:14:25 PM.
This article shows how to create a subquery to a select statement in SQL Server.
SQL-CLR For Beginners: Part-4: Consume C# Class in Stored Procedure
1/31/2023 7:23:25 AM.
In this article we will learn how to use traditional C# class within SQL-CLR Application.
SQL CLR For Beginners: Part 3: Create Function in SQL-CLR
1/31/2023 6:53:49 AM.
In this article we will see how to create a simple function in a SQL-CLR Project.
Cursor and XML Strore Procedure in SQL
1/31/2023 6:41:16 AM.
How to use Cursor and XML together in SQL Stored Procedures.
Learn Membership Services Part 1: Installing ASP.NET Membership Services Database in SQL Server 2008
1/31/2023 6:32:05 AM.
In this article, we create a database in SQL Server and install ASP.NET membership services then install an ASP.NET Memberships Services Database.
How to Encrypt and Decrypt a Password
1/31/2023 6:03:32 AM.
How to Encrypt and Decrypt a Password using EncryptByPassPhrase and DecryptByPassPhrase.
Binary_Checksum the Alternate of NewID() to Fetch Random Records in SQL Server
1/31/2023 5:46:08 AM.
In this article I will demonstrate Binary_Checksum, the Alternate of NewID() to fetch random records in an SQL Server.
Complex SQL Queries With Split() Function in SQL
1/31/2023 5:18:03 AM.
In this article, you will learn about Complex SQL queries with the split() function in SQL.
Triggers in SQL Server: A Beginner's Guide
1/30/2023 9:18:49 PM.
Triggers are a powerful tool in SQL Server for automating database tasks. In this beginner's guide, you'll learn what triggers are and how they work. We'll cover the different types of tri
How to Create a Trigger in SQL
1/30/2023 9:17:56 PM.
SQL triggers are database objects, a particular kind of stored procedure, which “reacts” to certain actions we make in the database. Learn what is a trigger in SQL Server and how to create triggers on
Generate And Validate JSON Schema With JSON Response Using Postman
1/30/2023 9:50:28 AM.
In this article, you will learn how to generate and validate JSON Schema with JSON Response using POSTMAN.
Create, Delete, and Update Triggers in SQL
1/30/2023 9:44:38 AM.
This article discusses how to create and manage triggers in a database using SQL.
How To Add Primary Key To Existing Table In SQL
1/30/2023 9:26:38 AM.
In this article, you will learn how to add primary key in an existing table.
Computed Columns in SQL Server
1/30/2023 9:14:59 AM.
Computed columns are derived columns based on the other existing columns. Computed columns are data types can create based on the situation.
Computed Columns In SQL Server
1/30/2023 8:42:17 AM.
In this article, you will learn about Computed Columns in SQL Server.
XML Data Type In SQL Server
1/30/2023 7:31:44 AM.
In this article, we will read about XML data type and also some advantages and limitations of XML data type over relational data types.
XML Data Type in Microsoft SQL Server
1/30/2023 6:58:35 AM.
In this article, we will see about XML data type in Microsoft SQL Server 2005.
How to Encrypt and Decrypt Text
1/30/2023 6:36:15 AM.
This article explains how to Encrypt and Decrypt text.
Indexes in SQL Server
1/29/2023 6:30:08 AM.
A SQL Server Index is used on a database table for faster data access. In this article, learn what SQL Server Indexes are, why do we need them, and how to implement Indexes in SQL Server.
Generation of CAPTCHA Image Using Generic Handler for Login Page
1/27/2023 8:56:27 AM.
This article explains how to create a CAPTCHA image using a generic handler.
What Is Database Management
1/27/2023 8:06:15 AM.
In this article, you will learn what is Database Management.
SQL Server Index
1/27/2023 7:52:19 AM.
This article explains why SQL Server Index is so very important in the Database Management System.
How To Setup And Install PostgreSQL Database Locally
1/25/2023 6:57:38 AM.
This article demonstrates step by step approach on how to install and setup PostgreSQL db locally on windows machine.
Dynamic SQL Query Injection And Its Prevention Mechanism
1/25/2023 6:27:00 AM.
In this article, you will learn about dynamic SQL query injection and its prevention mechanism.
SQL Injection In Dynamic SQL
1/25/2023 6:15:42 AM.
In this article you will learn about SQL Injection in Dynamic SQL.
Tips to Increase SQL Server Query Performance: Part 2
1/25/2023 6:02:25 AM.
This article provides more tips to increase SQL Server query performance.
Temporal Tables In SQL Server
1/25/2023 6:00:01 AM.
A system-versioned temporal table is a type of table in SQL Server that automatically tracks the historical changes to the data in the table
What is SQL? Download Free SQL EBooks📘📕
1/25/2023 5:49:15 AM.
SQL stands for Structured Query Language, a query language to access and update relational databases. In other words, if you need to read, insert, update, or delete data to a relational database, you
SQL CLR For Beginners: Part 2: Create Trigger in SQL-CLR Project
1/25/2023 5:37:34 AM.
In this article we will see how to create a simple trigger in a SQL-CLR project. I hope you are already quite familiar with the concept of triggers in SQL Server (or some other database).
How To Delete A Column With Default Constraints In SQL Server
1/25/2023 5:19:10 AM.
This article let us know, how to delete a column that has a default constraint in SQL server.
Insert Rows Using User Defined Table Types
1/25/2023 4:49:30 AM.
In this article I am going to explain how to insert multiple rows using a user defined table type.
How To Get Today's Date In SQL Server
1/24/2023 1:45:16 PM.
In SQL, Today's date can be used in SELECT, INSERT, and UPDATE statements. It can also be used in conjunction with other functions and operators for calculations or comparisons. Additionally, toda
Insert and Update in SQL Using User-Defined Table Type and XML
1/24/2023 11:04:21 AM.
This article shows how to insert and update in SQL Server using user-defined table type and XML.
How to Store Date and Time in Separate Columns in SQL Server 2005
1/24/2023 8:58:40 AM.
In this article I will explain how to store Date and Time in SQL Server 2005 using a User Defined Type.
Distributed Database Management Systems
1/24/2023 7:34:26 AM.
I will illustrate the principles of Distributed Database Management Systems through this article.
SQL Server 2008 R2 on Windows 8 Error 17058 When Starting the Service
1/24/2023 7:09:43 AM.
Windows 8 is the newest operating system from Microsoft and now it's spreading through the development systems replacing Windows 7.
@@ Identity Vs ScopeIdentity Vs Ident_Current in SQL
1/24/2023 7:01:41 AM.
This article explains @@Identity, Scope_Identity() & Ident_Current('Table_Name') in SQL.
Differences Between SCOPE IDENTITY, IDENT CURRENT, and IDENTITY in SQL Server
1/24/2023 7:00:43 AM.
In this article you will learn what is Different between SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY in SQL 2008
Adding a Number in String in SQL Server
1/24/2023 6:33:53 AM.
In this article, I provide a quick overview of how to add a number in a string in SQL Server.
Dynamically Getting Database Collection From SQL Server Using C#
1/24/2023 5:39:19 AM.
In this article we are going to see how to get a database List dynamically using C#.
SQL INSERT INTO Statement
1/23/2023 5:47:30 PM.
In this article, you will learn how to use an INSERT INTO statement in SQL.
SQL Server - FAQ's
1/23/2023 11:55:21 AM.
In this article we will go through the most basic and frequently asked interview questions on SQL Server.
Types of Commands in SQL Server
1/23/2023 6:37:23 AM.
This article explains various types of SQL Server commands, like DDL, DCL, DML, and TCL etc.
SQL For Data Governance And Compliance In Regulated Industries
1/23/2023 6:29:07 AM.
In this article, we learn about how SQL is used for data governance and compliance in regulated industries.
SQL And Data Governance - How To Implement Data Governance In SQL
1/23/2023 6:26:26 AM.
In this article, we learn about how to implement data governance in SQL.
Working with Date and Time in SQL Server
1/20/2023 10:49:06 AM.
In this article, I would like to show the similarity of SQL Getdate function and the C# DateTime class.
Various Types of Transactions in SQL Server
1/20/2023 10:37:40 AM.
This article explains how to use the transactions and various way of writing the transactions in SQL Server.
Conversion Functions Using SQL Query in SQL Server
1/20/2023 10:30:19 AM.
In this article you will see how to use conversion functions using SQL Query in SQL Server.
Cast() and Convert() Functions in SQL Server
1/20/2023 10:00:52 AM.
In this article, we will see how to use the cast and convert functions in SQL Server 2012.
Uses of Merge Statement in SQL Server
1/20/2023 9:43:45 AM.
This article explains the Merge Statement in SQL Server.
SQL Server Merge Statement
1/20/2023 9:14:11 AM.
In this article, you will learn about the SQL SERVER MERGE statement.
Service Broker in SQL Server
1/20/2023 8:43:31 AM.
The SQL Server Service Broker helps developers to build scalable as well as secure database applications.
Configure Database Mail - Send Email From SQL Server Database
1/20/2023 6:51:31 AM.
In this article, you will learn how to send email from SQL Server database.
Encrypt and Decrypt in SQL Server: Part 5
1/19/2023 9:12:44 AM.
In this article, we will create a symmetric key and encrypt and decrypt string using this key.
Encrypt and Decrypt in SQL Server: Part 4
1/19/2023 9:00:52 AM.
In this article, we will encrypt plain text and decrypt encrypted text using the asymmetric key.
Encrypt and Decrypt in SQL Server: Part 3
1/19/2023 8:50:44 AM.
In this article, we will generate a certificate and using this certificate we will encrypt and decrypt the string.
Encrypt and Decrypt in SQL Server: Part 2
1/19/2023 8:34:02 AM.
In this article, we will discuss Database Master Key. The database master key is a symmetric key used to protect the private keys of certificates and asymmetric keys that are present in the database.
Concept of Join in SQL Server
1/19/2023 8:16:33 AM.
In this article we are show different types of joins in SQL Server. A Join in SQL is used to combine two or more tables. We use the Join operator to gather the data in a single query.
Types of Joins in SQL Server
1/19/2023 7:24:44 AM.
This article is about the concepts of using Joins with examples.
Joins in SQL Server. Everything You Need To Know About SQL Joins.
1/19/2023 6:51:47 AM.
Here I explain Joins in SQL Server. Joins in SQL Server are used to retrieve data from two or more tables with a joining condition.
Clustered Vs Non-Clustered Index
1/19/2023 5:46:27 AM.
In this article, you will learn about Clustered vs Non-clustered Index.
Unlock the Secrets of the Rank Function in SQL Server
1/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!
40 SQL Interview Questions Everyone Should Know In 2023
1/18/2023 10:07:55 AM.
SQL (Structured Query Language) is a language to access RDBMS. Here is a list of most popular SQL interview questions and answers.
Getting Date and Time Parts From DateTime in SQL Server
1/18/2023 9:21:27 AM.
In this article, I would like to show the functions Datepart, DateName, Year, Month and Day in SQL Server.
Multiple Grouping Sets in SQL Server
1/18/2023 6:35:38 AM.
This article explains multiple grouping sets in SQL Server.
Difference Between Grouping and Grouping_ID in SQL
1/18/2023 5:56:30 AM.
In this article, you will learn the difference between Grouping and Grouping_ID in SQL Server.
Supercharge Your Database: How Pivot in SQL Server Can Help You
1/17/2023 5:30:12 PM.
Are you looking to supercharge your database? Learn how you can use Pivot in SQL Server to take your database to the next level. Pivot can help you optimize your database performance, improve data an