Different types of ANSI standard joins
INNER JOIN (SIMPLE JOIN): This returns all rows for which there is at least one match in BOTH tables. This is...
2016-09-26
267 reads
Arun Kumar
- Interests: Database developer and designing
What does UNION do or what result set UNION return ? What is the difference between UNION and UNION ALL?
UNION merges the contents of two structurally-compatible tables into a single combined table. This return unique records from all the...
2016-09-26
177 reads
What will be the result of the query below? Explain your answer?
select case when null = null then 'True' else 'False' end as ResultSet;
2016-09-26
146 reads
SPACE
USE CASE: When we are working on TSQL or some text based scripting we may need some extra space in between...
2016-09-04
187 reads
STUFF
Use case when we are working on TSQL or Query ,some time we came such a situation when we need...
2016-09-04
168 reads
Common uses of stored Procedure sp_MSforeachtable
We will get the brief idea about undocumented procedure sp_MSforeachtable of the Master database.
sp_MSforeachtable can be used to loop through all...
2016-05-09
11,408 reads
Generate list of all Month name
DECLARE @year INT
SET @year = 2016
;WITH months AS(
SELECT 1 AS Mnth, DATENAME(MONTH, CAST(@year*100+1 AS VARCHAR) + '01') AS monthname
UNION ALL
...
2016-04-11
212 reads
Get each table space and their rows count
Sometime we need to know how much table space are used to store the data and also wish to know...
2016-04-11
164 reads
SQL Basics for Beginner
SQL BasicsAn instruction to a database to combine data from more than one table.A SQL join combines records from two or more...
2016-02-08
898 reads
SQL Create Table
SQL CREATE TABLEThe CREATE TABLE statement is used to create a table in a database to stored data.Tables are organized...
2016-02-08
195 reads
Blogs
Advice I Like: Fear and Imagination
By Steve Jones
Fear is fueled by a lack of imagination. The antidote to fear is not...
Cloud Data Driven User Group 2025 – Slides & Scripts
The slidedeck and the SQL scripts for the session Indexing for Dummies can be...
Leading Through Change: Guiding Teams in Times of Uncertainty
By Chris Yates
Change is not a disruption in technology; it is the rhythm. New frameworks appear,...
Forums
Building AI Governance and Policies- First Steps
Comments posted to this topic are about the item Building AI Governance and Policies-...
Simple delete causes table scan on other tables with foreign key
Why is sql doing a full scan VS seeking on the index? I've included...
Show/Hide number of rows in table
We have a report that has multiple tables that list the top 15 performers...
Question of the Day
Checking Identities
The DBCC CHECKIDENT command is used when working with identity values. I have a table with 10 rows in it that looks like this:
TravelLogID CityID StartDate EndDate 1 1 2025-01-11 2025-01-16 2 2 2025-01-11 2025-01-16 3 3 2025-01-11 2025-01-16 4 4 2025-01-11 2025-01-16 5 5 2025-01-11 2025-01-16 6 6 2025-01-11 2025-01-16 7 7 2025-01-11 2025-01-16 8 8 2025-01-11 2025-01-16 9 9 2025-01-11 2025-01-16 10 10 2025-01-11 2025-01-16The docs for DBCC CHECKIDENT say this if I run with only the table parameter: "If the current identity value for a table is less than the maximum identity value stored in the identity column, it is reset using the maximum value in the identity column. " I run this code:
DELETE dbo.TravelLog WHERE TravelLogID >= 9
GO
DBCC CHECKIDENT(TravelLog, RESEED)
GO
INSERT dbo.TravelLog
(
CityID,
StartDate,
EndDate
)
VALUES
(4, '2025-09-14', '2025-09-17')
GO
What is the identity value for the new row inserted by the insert statement above? See possible answers