T-SQL Resources

Share

Related resources for T-SQL

Working with Date and Time Formats in T-SQL5/22/2023 9:36:23 AM. This article describes how different date styles work with date formats
How To Call Stored Procedure With MuleSoft4/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 Server4/27/2023 8:54:36 AM. Working with Big Data in SQL Server
Backup and Restore Using Command Prompt - SQLCMD and T-SQL3/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 Hold3/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 Sequence3/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 Conversion2/28/2023 4:11:34 AM. Basic considerations and examples of DATETIME, DATE and TIME data types.
Implementing and Using Fishhook Relation in Transact SQL2/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 JSON2/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 Server2/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 12/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 Server2/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 Comparison2/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-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
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 Statement1/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 Server1/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 Server1/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 Tips1/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 Commands1/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 Equivalent1/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 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.
Export Microsoft SQL Data To CSV Using Python11/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 Python10/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 Data9/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 Practice7/21/2022 8:17:52 PM. This article will demonstrate the two types of subqueries and their practical usage.
XML Shredding In T-SQL7/19/2022 9:32:17 PM. In this article, you will learn about XML shredding in T-SQL.
Logical Query Processing In T-SQL7/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#.
How To Query Dataverse In Microsoft SQL Server Management Studio (SSMS)?12/8/2021 2:51:40 PM. In this article, you will learn how to query dataverse in Microsoft SQL Server Management Studio (SSMS).
Build A ToDo List Application Using .NET 5.0 Web API And Microsoft SQL Server9/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 20216/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 Server5/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. 105/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 SSMS5/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 Science5/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 Server4/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. 63/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 Beginners3/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 Database2/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 Ilic2/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 20212/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 Know1/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 One12/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.Net11/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 .NET11/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-SQL9/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 Studio8/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 Code5/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 Usage5/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 Database2/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 Studio11/13/2019 7:11:26 AM. How to generate the alter table SQL script in using SSMS.
T-SQL - Introduction To Window Functions8/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 Beginners8/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 Error8/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 Excel8/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 Money7/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 Azure7/10/2019 9:53:40 AM. In this video, let us learn to create Azure Virtual Machine (Linux) and install SQL Server on it.
Generate Database Script with Table Data From SQL Server7/4/2019 2:02:52 AM. In this article, I will describe how to generate a database script for a table with all it's data, views, stored procedures, constraints, and login credentials.
SqlTransaction In C#6/30/2019 9:42:59 PM. SqlTransaction class of ADO.NET is used to execute transactions. Learn how to use the SqlTransaction in C# and SQL.
Using CLR With SQL Server 20126/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 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
How To Import Data From Excel Data Into SQL Table In Microsoft SQL Server 20163/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.
Auditing Data Changes In Microsoft SQL Server8/27/2018 9:49:37 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 ‘
Querying Azure SQL Databases In Databricks Spark Cluster8/27/2018 9:29:51 AM. We will see the entire steps for creating an Azure Databricks Spark Cluster and querying data from Azure SQL DB using JDBC driver. Later we will save one table data from SQL to a CSV file.
Zero To Hero In MS SQL Server - Part Five8/21/2018 1:52:34 PM. In this article, we will learn about Insert and Select Statement in SQL Server.
How To Connect SQLite With Node.js5/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 File12/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 Server2/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 Server12/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 Installation9/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.
SQL Server 2014 Database Backup - Encryption5/24/2016 10:31:46 AM. In this article you will learn about SQL Server Database Backup. Microsoft SQL Server has developed a key feature introduced in SQL Server 2014, backup encryption.
How To Import Excel Data Into Microsoft SQL Server5/3/2016 12:20:57 AM. In this article you will learn how to import excel data into Microsoft SQL Server.
Get SQL Server Table Records in XML1/26/2016 12:43:20 PM. In this article I just want to show you that how to get the SQL Server table records in format of XML.
Connect SQL Server After Changing Computer Password1/6/2016 4:51:03 AM. In this article you will learn how to connect SQL Server after changing computer password.
How To Export SQL Server Database As .MDF File12/31/2015 1:59:45 AM. This article will help you to understand the procedure of exporting an existing database on your system to other system and the procedure to access it.
Using the Multi-Line Table-Valued Function12/1/2015 10:54:08 AM. The video shows using the Multi-line function created in the Previous video
Creating Simple Table-Valued Function11/30/2015 5:25:37 AM. This video shows creating a simple table-valued function in SQL Server 2005
Create And Connect SQL Server And Database On Windows Azure11/3/2015 2:20:10 PM. In this article you will learn how to create and connect SQL Server and database on Windows Azure.
User Manual For Export Tool9/30/2015 2:49:22 PM. In this article you will learn about User Manual for Export Tool.
Replace Function In Microsoft SQL Server9/6/2015 1:07:40 AM. This article will explain you how to use a replace function in Microsoft SQL Server.
Transaction Management in SQL5/28/2015 2:45:36 PM. This article explains Transaction Management in SQL.
Error And Exception Handling in T-SQL1/22/2015 2:52:13 AM. In this article you will learn about exception handling in T-SQL.
Coding Instructions To Prevent SQL-Injection12/12/2014 1:23:15 PM. In this article, I am describing a few techniques to make SQL-Injection difficult.
Restore a SQL Server BACKUP Using Transact-SQL7/24/2014 2:43:54 PM. This article describes how to restore a SQL Server backup using one of multiple methods using Transact-SQL.
SQL Server DATABASE Transaction LOG BACKUP Using Transact-SQL7/22/2014 12:15:33 AM. This article describes SQL Server database transaction LOG backups and how to take a SQL Server database transaction LOG backup with multiple methods using Transact-SQL.
SQL Server DATABASE BACKUP With Multiple Methods Using Transact-SQL7/18/2014 2:14:16 PM. This article describes SQL Server database backups and how to take a SQL Server database backup with multiple methods using Transact-SQL.
SQL Server Transact-SQL Programming7/4/2014 7:55:52 PM. This article explains Transact-SQL Programming in SQL Server.
How to Use and Connect To Sqlite in a Windows Application5/21/2014 9:43:29 PM. Here, I will explain how to use and connect to Sqlite in a Windows application.
Useful T-SQL For Date Calculations5/1/2014 12:05:18 PM. In this article, we will see some useful T-SQL for date calculation.
Broadcast Real-Time SQL Data Using SignalR3/30/2014 11:50:37 AM. In this article you will learn how to broadcast SQL data using SignalR.
Natively Compiled Stored Procedures in SQL Server 20143/6/2014 12:51:36 PM. This article describes Natively compiled stored procedures (T-SQL procedures compiled to native code and access memory optimized tables) and their use.
Broadcast SQL Data Using SignalR in ASP.Net1/17/2014 12:02:13 PM. In this article you will learn how to get data from SQL Server and broadcast it using SignalR in ASP.NET.

Topics