SQL Resources

Share

Related resources for SQL

How to Use Full Text Search in SQL Server2/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 SQL2/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 Editor2/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 Window2/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 Framework2/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 Statement2/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 Statement2/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 12/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 Statement2/3/2023 8:59:03 AM. This article will help you to learn about SELECT statements in SQL.
SQLCLR vs. T-SQL - Performance Comparison2/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 20052/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 Programmatically2/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 12/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 Server2/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 Procedure2/3/2023 7:12:36 AM. In this article we will create a CLR stored procedure step by step.
Filtered Indexes in SQL Server2/3/2023 6:28:25 AM. SQL Server 2008 introduced Filtered Index. It is nothing but an optimized non-clustered index.
Indexes In SQL Server2/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 Time2/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 Code2/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 SERVER2/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 Server2/2/2023 8:55:42 AM. In this article, you will learn some basics about Compound Operators of SQL Server.
Explain SQL Joins2/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 Server2/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 Procedure2/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 Practices2/2/2023 4:51:54 AM. This article lists some important SQL Best Practices with examples.
Tempdb Performance Improvements in SQL Server 2022 are Dramatic2/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 Server2/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-SQL2/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 Port2/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 MySQL2/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 .NET2/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 Server1/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 Server1/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 Procedure1/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-CLR1/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 SQL1/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 20081/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 Password1/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 Server1/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 SQL1/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 Guide1/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 SQL1/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 Postman1/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 SQL1/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 SQL1/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 Server1/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 Server1/30/2023 8:42:17 AM. In this article, you will learn about Computed Columns in SQL Server.
XML Data Type In SQL Server1/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 Text1/30/2023 6:36:15 AM. This article explains how to Encrypt and Decrypt text.
Indexes in SQL Server1/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 Page1/27/2023 8:56:27 AM. This article explains how to create a CAPTCHA image using a generic handler.
What Is Database Management1/27/2023 8:06:15 AM. In this article, you will learn what is Database Management.
SQL Server Index1/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 Locally1/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 Mechanism1/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 SQL1/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 21/25/2023 6:02:25 AM. This article provides more tips to increase SQL Server query performance.
Temporal Tables In SQL Server1/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 Project1/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 Server1/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 Types1/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 Server1/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 XML1/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 20051/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 Systems1/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 Service1/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 SQL1/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 Server1/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 Server1/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 Statement1/23/2023 5:47:30 PM. In this article, you will learn how to use an INSERT INTO statement in SQL.
SQL Server - FAQ's1/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 Server1/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 Industries1/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 SQL1/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 Server1/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 Server1/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 Server1/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 Server1/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 Server1/20/2023 9:43:45 AM. This article explains the Merge Statement in SQL Server.
SQL Server Merge Statement1/20/2023 9:14:11 AM. In this article, you will learn about the SQL SERVER MERGE statement.
Service Broker in SQL Server1/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 Database1/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 51/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 41/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 31/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 21/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 Server1/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 Server1/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 Index1/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 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!
40 SQL Interview Questions Everyone Should Know In 20231/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 Server1/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 Server1/18/2023 6:35:38 AM. This article explains multiple grouping sets in SQL Server.
Difference Between Grouping and Grouping_ID in SQL1/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

Topics