In this SQL Server tutorial, we will learn and understand how to use the SQL Server INNER JOIN clause on multiple tables. We have already discussed how to use the SQL Server Inner Join on 2 tables in SQL Server. However, there are many cases when we need to apply Inner join on more than … Read more >>

In this SQL Server tutorial, I will show you how to create a table in SQL Server Management Studio. As a database developer, you must know how to create a table to store the information in it. Tables are important objects in SQL. Server databases and their design are a base for both DBAs and … Read more >>

You need every customer and what they’ve spent, including the two who’ve never ordered. A sql server left join keeps every row from the table before LEFT JOIN and returns NULL for the other table’s columns when nothing matches. The finished report: Before You Start: The Sample Tables Tested on: SQL Server 2025 (17.0.1000.7) Developer, … Read more >>

Plenty of old scripts still call CONVERT with a bare varchar and no style. It runs, but it cuts text at 30 characters. The SQL Server CONVERT function changes a value’s data type, and its third argument picks the format: CONVERT(data_type[(length)], expression[, style]). So CONVERT(varchar(10), PaidOn, 101) returns 07/04/2026. CONVERT Syntax and the Sample Payments … Read more >>

You joined Customers to Orders, put TOP 1 in front, and got one row back for the whole query. That’s how SQL Server INNER JOIN TOP 1 works: TOP trims the final result, not each customer’s orders. Quick answer: move TOP (1) into a CROSS APPLY with an ORDER BY, so it runs once per … Read more >>

You can’t select last 10 records in SQL Server without sorting. A table has no built-in order, so “last” only exists once a column defines it. So you sort an identity or date column descending and take TOP (10): What came back on my run: On my 5,000-row login table that’s IDs 5000 down to … Read more >>

Many guides still count joined rows with COUNT(*). Join a third table and those totals quietly inflate. A safer sql server count join group by query joins the tables, groups by the column you report on, and counts the child key: SELECT c.State, COUNT(o.OrderID) FROM dbo.Customers AS c INNER JOIN dbo.Orders AS o ON o.CustomerID … Read more >>

Quick answer: SQL Server STRING_AGG joins values from many rows into one string with a separator. Add GROUP BY to get one list per group: Result: Three teams, one row each. Legal has nobody, so the inner join leaves it out, and you’ll see how to keep it below. Sample Tables for the STRING_AGG Examples … Read more >>

My naive recursive trigger in SQL Server died at nest level 32 with Msg 217 and took the INSERT with it. A recursive trigger fires itself again, directly (it updates its own table) or indirectly (A updates B, B updates A). Direct recursion needs ALTER DATABASE … SET RECURSIVE_TRIGGERS ON. Indirect recursion needs only the … Read more >>

In this SQL Server tutorial, we will learn and comprehend How to create a trigger to insert data in another table in SQL Server. We will also discuss and learn several instances to assist you in better understanding the concept. The full list of topics we will cover is given below. Also, check the related post: SQL … Read more >>