Filtering Data in T-SQL

02:45 Languages & Coding, T-SQL

Introduction In most scenarios when working with data, users do not require all the data in each...
Read More

T-SQL Regular Expressions: SUBSTRING, PATINDEX and CHARINDEX

01:45 Languages & Coding, T-SQL

In my previous article about T-SQL regular expressions, I have explained the LIKE operator, its usage and provided several examples with...
Read More

Transact-SQL: Working With Strings

02:31 Languages & Coding, T-SQL

Microsoft SQL Server has many built-in functions that can be used to format the output and represents it in the desired format. In this...
Read More

T-SQL Regular Expression: LIKE Operator and Its Use-Cases

02:45 Languages & Coding, T-SQL • One Comment

A Regular Expression (Regex) is a rule defining how characters can appear in an expression. In...
Read More

Calculate the median by using Transact SQL

00:54 Languages & Coding, T-SQL

The statistical median is the value which separates a dataset into halves – one comprises greater values, and the other comprises...
Read More

Auto Create Statistics and Auto Update Statistics

01:12 Languages & Coding, SSMS, T-SQL, Tools & technologies

Statistics comprises lightweight objects that are used by SQL Server Query optimizer to determine the optimal way to retrieve data from the...
Read More

T-SQL SET Operators Part 2: INTERSECT and EXCEPT

02:58 Database development, Statements, T-SQL

In my previous article, I explained the basics of set operators, their types, and prerequisites for...
Read More

How to Properly Use the T-SQL IsNumeric Function

03:17 Languages & Coding, T-SQL

This article is focused on the T-SQL (Transact-SQL) IsNumeric function and its proper use in day-to-day SQL scripting tasks. We will also...
Read More

Advanced SQL: Variations and Different Use cases of T-SQL Insert Statement

00:07 Database development, Languages & Coding, Statements, T-SQL

In my previous article, I demonstrated: Insert the output of the table-valued function in the SQL table. Insert the output of the...
Read More

Basic and Complex Uses of Not Equal Comparison Operator in T-SQL

00:15 Languages & Coding, T-SQL

This article is focused on the T-SQL Not Equal comparison operator (<>) and its uses in basic...
Read More
Close