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 T-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]
Tural Suleymani (7)
C# Corner Live (4)
Mohamed El-Qassas (Mvp) (3)
Monica Rathbun (3)
Sreenath Kappoor (2)
Jitendra Mesavaniya (2)
Siddhesh Chavan (2)
Pratik Somaiya (2)
John Charles Olamendy (2)
Emiliano Musso (2)
Jignesh Trivedi (2)
Vijai Anand Ramalingam (2)
Ravinder Sharma (2)
Ai Fortytwo (2)
Ahmad Farazmand (2)
Mushtaq M A (2)
Artur M (2)
Nirav Gandhi (2)
Kailash Chandra Behera (1)
Rohatash Kumar (1)
Naveen Kumar (1)
Vikas Singh (1)
Sundaram Subramanian (1)
Deepak Middha (1)
Pankaj Patel (1)
Kiran B S (1)
Sivaruban Narayanapillai (1)
Jefferson S. Motta (1)
Deepak Tewatia (1)
Yuvapriya P (1)
Joel Champagne (1)
Arun Potti (1)
Raj Kumar (1)
Amit Mohanty (1)
Om Agarwal (1)
Prabhu Raja (1)
Zoran Horvat (1)
Mahesh Chand (1)
Harpreet Singh (1)
Mukesh Kumar (1)
Sergey Syrovatchenko (1)
Manikavelu Velayutham (1)
Sandeep Singh Shekhawat (1)
Ratnesh Singh (1)
Kirtesh Shah (1)
Amit Tiwari (1)
Keerthi Raja (1)
Shankar M (1)
Rajesh Gami (1)
Maneesha Kashyap (1)
Sakhile Msibi (1)
Ojash Shrestha (1)
Ramasagar Pulidindi (1)
Amira Bedhiafi (1)
Satya Karki (1)
John Godel (1)
Anubhav Chaudhary (1)
Anil Kumar (1)
Sergei Kitaev (1)
Habibul Rehman (1)
Naresh Beniwal (1)
Gokulakrishna (1)
Dharmraj Thakur (1)
Nilesh Sawardekar (1)
Sonu Gupta (1)
Vidya Vrat Agarwal (1)
Rakesh (1)
Jignesh Kumar (1)
Zia Ahmed Shaikh (1)
Sagar Shinde (1)
Ahmad Anas (1)
Rajeesh Menoth (1)
Priyaranjan K S (1)
Related resources for T-SQL
No resource found
Error handling in Transact-SQL (T-SQL)
7/13/2024 10:59:58 AM.
Effective error handling in T-SQL (Transact-SQL) is vital for managing unexpected issues in database operations. Using TRY-CATCH blocks, RAISEERROR, and error functions like ERROR_MESSAGE and ERROR_NU
Check and Detect T SQL Code Analysis
7/8/2024 7:38:43 AM.
In this session, we’ll review the SqlCheck, ScriptDOM, and SQL projects code analysis options such that you can confidently add code analysis to the SQL components of your applications.
SQL Server 2016 - How To Detect The Current Cumulative Update/Service Pack That Was Installed
7/4/2024 7:36:25 AM.
Learn how to detect the current Cumulative Update or Service Pack installed on SQL Server using various methods like ServerProperty in T-SQL, SQL Server Management Studio, Configuration Manager, and P
Query to Find SQL Server Version
7/2/2024 7:11:42 AM.
To identify the version of SQL Server running, use the query SELECT @@VERSION AS 'SQL Server Version';. This returns detailed information including version number, edition (like Developer Edit
Backing Up and Restoring a SQL Database
6/19/2024 7:31:50 AM.
In database management, ensuring data integrity and availability is paramount. Regularly backing up your database is crucial to mitigate risks such as hardware failures, software issues, or accidental
SqlTransaction In C#
6/13/2024 10:53:14 AM.
Transactions in databases ensure data integrity using ACID properties: Atomicity ensures all steps complete successfully or rollback completely, Consistency ensures transitions maintain data rules, Is
SQL Query Execution Understanding Process and Performance
6/11/2024 11:37:51 AM.
Understanding the SQL query execution order—from FROM and JOIN to WHERE, GROUP BY, HAVING, SELECT, ORDER BY, and LIMIT/OFFSET—is crucial for optimizing queries. Key techniques include indexing, optimi
Understanding Different Types of SQL Triggers in SQL Server
6/11/2024 9:14:12 AM.
SQL Server triggers are powerful tools that allow the automatic execution of SQL code in response to specific events on a table or view. They play a crucial role in maintaining data integrity, enforci
Using GO and Semi-Colon in SQL Server 2012
5/30/2024 12:12:09 PM.
Learn about the usage of the GO command and semicolon in SQL Server. Understand how to use GO as a batch separator and change it in SQL Server Management Studio. Semicolon (;) terminates SQL statement
Difference between SQL and T-SQL
5/9/2024 10:35:19 AM.
In the realm of relational database management systems (RDBMS), SQL (Structured Query Language) and T-SQL (Transact-SQL) are often used interchangeably. In this article, we'll delve into the key d
Convert Rows to CSV & Eliminate Duplicates in SQL Server
5/6/2024 4:17:43 AM.
Using SQL Server's string aggregate function, efficiently transform row data into a comma-separated format, while simultaneously removing any duplicate entries, ensuring data integrity and optimiz
SQL Server Fundamentals: Design, Queries & Optimization
4/29/2024 10:52:37 AM.
This article serves as a comprehensive guide to SQL Server fundamentals, database design principles, querying with Transact-SQL, stored procedures, and optimization techniques. Through real-time examp
Zero To Hero In MS SQL Server - Part Four
4/19/2024 10:31:37 AM.
In this article, Part Four of 'Zero To Hero In MS SQL Server' delves into advanced topics like query optimization, stored procedures, and indexing strategies. Master database management, T-SQL
Temporary Table in SQL Server
4/3/2024 9:41:55 AM.
In this article, we will learn about temporary tables in SQL Server, a powerful feature for temporary data storage and manipulation. Master T-SQL techniques for creating and managing temporary tables,
Simple Image or File Import Using T-SQL for SQL Server
4/3/2024 8:47:23 AM.
The article demonstrates importing image files into SQL Server using T-SQL's OPENROWSET, BULK, and SINGLE_BLOB. It covers basic examples and prerequisites, allowing dynamic file paths and names fo
How To Get Started With Always Encrypted For Beginners - Part One
3/28/2024 6:27:34 AM.
Encryption has always been intriguing to me but seemed like it could be a very complex process to set up. However, SQL Server made it very simple when they introduced Always Encrypted (AE) into SQL Se
How To Get Started With Always Encrypted For Beginners - Part Three
3/28/2024 6:26:32 AM.
Discover advanced techniques in data security with Always Encrypted in Microsoft SQL Server. Part Three of our beginner's guide delves deeper into encryption keys, transparent data encryption, and
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
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
JWT Authentication Using Refresh Token Series - 1 [Login Feature] In .NET Core 6.0-ADO.NET-SQL
1/10/2024 10:39:54 AM.
In this series of articles, we'll focus on a hands-on, practical implementation of JWT authentication with refresh tokens in .NET Core 6.0 using ADO.NET and SQL, emphasizing real-world scenarios a
Identifying the Root Cause of SQL Server Problems
1/10/2024 5:17:17 AM.
Finding issues in SQL Server involves troubleshooting and identifying the root cause of problems. Troubleshooting SQL Server issues involves comprehensive steps. Check error logs, use SQL Server Manag
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... "
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
Know The History Of Your SQL Server Database
10/16/2023 9:00:14 AM.
Understand your SQL Server database history for effective management. Learn to identify the internal version number using SQL Server Management Studio and various T-SQL statements, ensuring accurate d
Auditing Data Changes In Microsoft SQL Server
8/25/2023 10:16:21 AM.
Tracking changes in data over time is a common problem, and deciding on your approach relies on answering questions such as “Do I want to track every field or just some fields?”, “Does it need to be ‘
Oracle database 11g and Microsoft SQL Server 2008
7/31/2023 4:34:50 AM.
In this article, I want to cover the new features in Oracle 11g and SQL Server 2008 database systems which are two important players always fighting for the top spot in this important market segment o
Date and Time Functions in T-SQL
7/25/2023 10:24:37 AM.
This article represents the comprehensive guideline for date and time functions in T-SQL.
How to Create Azure SQL Server Database in the Microsoft Azure Portal?
6/22/2023 10:40:30 AM.
Step by step details to create azure sql database server in the Microsoft Azure Portal
Working with Date and Time Formats in T-SQL
5/22/2023 9:36:23 AM.
This article describes how different date styles work with date formats
How To Call Stored Procedure With MuleSoft
4/29/2023 12:25:23 PM.
In this article, we will learn how to call Azure SQL Server Stored Procedure with MuleSoft.
Working with Big Data in SQL Server
4/27/2023 8:54:36 AM.
Working with Big Data in SQL Server
Backup and Restore Using Command Prompt - SQLCMD and T-SQL
3/7/2023 6:46:06 AM.
In this article I am explaining how to do backup and restore using a SQLCMD and T-SQL command prompt.
Put SQL Server’s Query Execution Engine on Hold
3/3/2023 6:58:02 AM.
Here you will see how to put your SQL Server’s Query Execution Engine on hold for a while.
Search For Missing Values Within a Numerical Sequence
3/3/2023 5:26:01 AM.
The purpose of this short article is to show a method for identifying, within a SQL Server table, gaps in a numerical sequence, to quickly locate absences of consequence within given data.
Examples Of DATE/DATETIME Conversion
2/28/2023 4:11:34 AM.
Basic considerations and examples of DATETIME, DATE and TIME data types.
Implementing and Using Fishhook Relation in Transact SQL
2/22/2023 8:27:07 AM.
Here the use of fishhook relation to represent tree structures is explained through a detailed example in T-SQL.
Convert SQL Server Data to JSON
2/22/2023 6:32:15 AM.
Learn how to Convert SQL Server Data to JSON using JSON PATH clause.
Replace Nulls With Specified Values in SQL Server
2/21/2023 12:44:01 AM.
In this article we will see the various ways to replace null values in a table. ISNULL() function, CASE statement, COALESCE() function can be used to replace null values in a SQL Server table.
Creating an OLAP Cube (SSAS)
2/20/2023 5:56:49 AM.
Here you will see how to create an OLAP Cube (SSAS).
How to Generate a CREATE TABLE Script For an Existing Table: Part 1
2/14/2023 3:19:00 PM.
In this article, we learn how to generate a CREATE TABLE Script For an Existing Table.
T-SQL - Retrieve Task Hierarchy In Project Server
2/13/2023 9:31:09 AM.
In this article, we will show how to get the Task Hierarchy for a Specific Project in Project Server Database using 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.
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
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.
SQL Server Merge Statement
1/20/2023 9:14:11 AM.
In this article, you will learn about the SQL SERVER MERGE statement.
CLR Function in SQL Server
1/14/2023 12:35:44 PM.
In SQL Server 2005 and later version of it, database objects like function, store Procedure, etc can be created which are already created in CLR.
Table Valued CLR Function in SQL Server
1/14/2023 11:52:35 AM.
In SQL Server 2005 and later versions of it, database objects such as functions, Stored Procedures, etc. can be created which are already created in CLR.
Simulating Autonomous Transactions in Microsoft SQL Server
1/14/2023 11:41:25 AM.
In the article, I will cover how to use table variable techniques in order to simulate the autonomous transaction behavior of Oracle databases in Microsoft SQL Server.
T-SQL Query Performance Tuning Tips
1/10/2023 8:52:11 AM.
In this article, I will discuss some useful T-SQL query performance tips and tricks for SQL server developers.
Insight.Database .NET Micro ORM - Executing And Carrying Out SELECT SQL Commands
1/10/2023 8:17:02 AM.
Insight. The database micro-format for.NET is quick, light, and, dare we say it, fantastic. SQL commands are simple to run using Insight. SqlCommand class and parameters are no longer used. AddWithVal
SQL Server Functions and Oracle Equivalent
1/9/2023 11:15:39 AM.
This article looks at SQL Server string, numeric and date functions and their Oracle equivalents.
The Most Important SQL Queries For Beginners
12/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.
Export Microsoft SQL Data To CSV Using Python
11/1/2022 5:40:41 AM.
In this article, you will learn how to create REST API to read Microsoft SQL table and export the result to CSV file using Python. I have created a simple Microsoft SQL table for this demo named as Em
Read Microsoft SQL Table And Send The Results As Rest API JSON Response Using Python
10/31/2022 5:46:08 AM.
In this article, you will learn how to read Microsoft SQL table and send the results as REST API JSON response using Python.
T-SQL - Pivoting And Unpivoting Data
9/20/2022 10:55:00 AM.
In this article, you will learn about T-SQL - Pivoting And Unpivoting data.
T-SQL Interview Questions On Data Types
7/31/2022 10:42:38 PM.
In this article, I collected interview questions on data types. I participated in many interview calls and I was asked about (sometimes I asked the interviewee) many times the below interview question
T-SQL Subqueries In Practice
7/21/2022 8:17:52 PM.
This article will demonstrate the two types of subqueries and their practical usage.
XML Shredding In T-SQL
7/19/2022 9:32:17 PM.
In this article, you will learn about XML shredding in T-SQL.
Logical Query Processing In T-SQL
7/19/2022 8:03:35 PM.
This article demonstrates the practical values of knowing Logical query execution in TSQL.
Data Fetching From Microsoft SQL To C#
6/1/2022 12:26:11 PM.
In this article, you will learn about data fetching from microsoft sql to c#.
Build A ToDo List Application Using .NET 5.0 Web API And Microsoft SQL Server
9/17/2021 2:06:03 PM.
The article shows how to build a ToDo list application using .Net 5 Web API, Jwt authentication and AspNetCore Identity.
T-SQL Window Function Performance - Women Data Summit 2021
6/27/2021 10:48:10 AM.
This session in Women Data Summit 2021 is about T-SQL Window Function Performance
Exists And Not Exists In SQL Server
5/22/2021 2:54:51 PM.
In this article we will explore the usage of Exists and Not Exists in SQL Server
T-SQL in Practice - AI42 Ep. 10
5/20/2021 8:28:56 AM.
Welcome to the 10th episode of the AI42 series! This time we will learn about T-SQL.
Full And Differential Backup Using SSMS
5/19/2021 12:34:27 PM.
In this article, we will see how to create a SQL Server Database backup. Database backup using SQL Server Management Studio, SQL Server provides a large number of options to create backups. We will di
Intro To T-SQL For Data Science
5/14/2021 11:51:22 AM.
In this article, we’ll learn about Database as a whole and use examples and features of T-SQL to learn to find meaning out of raw data.
Create An App Using Angular 10, .NET Core Web API And SQL Server
4/21/2021 4:26:47 PM.
In this article, you will learn how to create an App using Angular 10, .NET Core Web API and SQL Server.
T-SQL for Data Science - AI42 Ep. 6
3/25/2021 6:10:25 PM.
Welcome to the 6th session of the AI42 series! This time we will learn about T-SQL.
Top 10 Hottest And Tricky T-SQL Questions For Beginners
3/8/2021 6:47:04 PM.
Transact-SQL (T-SQL) is an extension to SQL developed by Microsoft and Sybase used to administer SQL Server.
How To Link A SQL Server To An Oracle Database
2/26/2021 6:18:45 PM.
This article describes what is Linked servers and how to link MS SQL Server to Oracle from SSMS
Synapse Serverless for T-SQL Ninjas - AMA ft. Nikola Ilic
2/12/2021 1:32:24 PM.
Join us with our guest speaker Nikola Ilic on live AMA for a Crash course on Synapse Serverless for T-SQL Ninjas.
Modern T-SQL for Better Performance - SQL Server Virtual Conference 2021
2/1/2021 4:31:38 PM.
This session is about “ Modern T-SQL for Better Performance ”in SQL Server Virtual Conference 2021.
Storage What SQL Server DBAs Need To Know
1/20/2021 5:54:20 AM.
In this article, you will learn about storage what sql server DBAs need to know.
Real Life SQL And .NET - Part One
12/6/2020 10:41:53 PM.
Welcome to the world of SQL and the huge, growing database technologies of today’s business all over the SQL world. By reading this article, we have begun accepting the knowledge that will soon be req
Export SQL Data to Excel Using ASP.Net
11/24/2020 4:12:39 AM.
This article explains how to export SQL Data to Excel using ASP.NET.
Execute Long Running SQL Query Or Stored Procedure From .NET
11/3/2020 12:47:34 AM.
This article describes the asynchronous call to MS SQL statements from .NET environment using C# to avoid UI or main thread freezing.
Client-Server WASM-Application In C#, TypeScript And Transact-SQL
9/29/2020 11:07:57 PM.
In this article, we describe a Blazor-WASM sample application. Although the article is associated with Web-development, it is not about the classical web. It is related to general Client-Server progra
Compare And Update SQL Server Database Project With Visual Studio
8/24/2020 2:54:59 AM.
In this article, you will learn how to create a SQL Server Database project using Visual Studio 2019 and how to compare and update the SQL Server Database Project from the remote SQL Server Database a
SQL Comments Statement
7/6/2020 7:42:12 AM.
In this article you will learn how to make SQL Comments statement in SQL
SQL Server JSON and ASP.NET Web API Scaffolder Generator Source Code
5/6/2020 4:13:54 PM.
This article demonstrates how to create an ASP.Net web API scaffolder generator based on SQL Server JSON store procedures.
SQL Server REST Scaffolding Simple High Performance SQL JSON Usage
5/3/2020 6:38:38 PM.
This project is a code generation framework for ASP.NET Web API based on SQL Server JSON result and C# repository pattern manager.
How To Import And Export SQLite Database
2/20/2020 5:37:21 AM.
In this article, we will learn how to import/export Android SQLite Database directly from an application. We can use an SQLiteImporterExporter library to perform these functionalities.
Oracle Database Server To SQL Server Migration
2/11/2020 11:01:56 PM.
In this article, you will learn about Oracle Database Server to Microsoft SQL Database Server Migration.
How to Generate Alter Script of Table Design Mode - Sql Server Management Studio
11/13/2019 7:11:26 AM.
How to generate the alter table SQL script in using SSMS.
T-SQL - Introduction To Window Functions
8/29/2019 3:17:25 AM.
You can optimize your queries to obtain simple and elegant solutions to a variety of problems by using Window Functions in T-SQL. In this video tutorial, let us learn how.
T-SQL For Beginners
8/13/2019 7:04:01 AM.
T-SQL (Transact-SQL) is a Microsoft extension to the SQL (Structured Query Language). T-SQL is central to using Microsoft SQL Server. In this course, you will learn the basics of this language in a fe
Resolving Microsoft SQL Management Studio Package Failed To Load Error
8/13/2019 6:50:56 AM.
In this video, you will get to know how to resolve the error - 'Microsoft SQL Management Studio Package' failed to load.
How To Connect And Load Data From MS SQL Server To Microsoft Excel
8/12/2019 8:51:02 AM.
In this article, we will see how to connect and load data from MS SQL Server to Microsoft Excel.
SQL Assessment API (Public Preview)
8/6/2019 10:55:07 AM.
Is your SQL Server configuration in line with Microsoft recommended best practices? If you want to know, check this latest video on SQL Assessment API.
T-SQL - Display Decimal Numbers As Money
7/17/2019 5:06:35 AM.
In this article, we will show how to display decimal numbers as money with and without cents
Installing SQL Server On Linux In Azure
7/10/2019 9:53:40 AM.
In this video, let us learn to create Azure Virtual Machine (Linux) and install SQL Server on it.
Using CLR With SQL Server 2012
6/11/2019 6:36:18 AM.
In this article, I’ll cover the SQL CLR in SQL Server 2012.
Top 30 Important SQL Queries For Developers
4/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
How To Import Data From Excel Data Into SQL Table In Microsoft SQL Server 2016
3/18/2019 10:08:42 AM.
This article demonstrates the inbuilt functionality of importing data from Microsoft Excel to a SQL table using import export wizard.
Use Of DISTINCT Keyword In T-SQL (SQL Server)
2/5/2019 6:24:45 AM.
In this session of SQL Server Training series, we are going to learn how to use Distinct keyword in SQL Server.
How To Connect SQLite With Node.js
5/6/2018 1:21:58 PM.
In this article, we will learn how to use connect SQLite with NodeJS and how to perform the CRUD operations with SQLite and NodeJS.
Export SQL Result To A Text File
12/18/2017 12:30:57 PM.
This article gives an overview of how to export SQL query results to a text file.
Subscribing and Connect Microsoft Azure With SQL Server
2/5/2017 11:24:54 PM.
This brief article will show you how to connect with SQL Server Database in Microsoft Azure.
Ranking Function In Microsoft SQL Server
12/21/2016 11:05:41 AM.
This article will explain the Ranking function in Microsoft SQL Server.
Resolving 'Cannot Connect To DataBase Master At SQL Server' Error During SharePoint 2016 Installation
9/10/2016 2:56:35 PM.
In this article, you will learn how to resolve ‘Cannot Connect to DataBase Master at SQL Server’ error during SharePoint 2016 Installation.