Using the Error Output of the Derived Column
The other day I was building a simple data import package when I ran into a common situation; invalid conversions in a Derived Column. The conversion was taking an...
2012-02-01
9 reads
Josef Richberg
An Interview at SSWUG
I've been a bit busy for the last few weeks, with the holidays, PASS, working on SSIS (more to come),...
2011-12-05
390 reads
SQL PASS Keynote : Day(s) 1&2
This is my first time here at PASS and I got a swept away in all the excitement. I tweeted...
2011-10-13
415 reads
SQL University SSIS : Named Pipes -- Consumer
Welcome to the third and last day of the Named Pipes seminar. Today we will get into the consumer portion...
2011-09-28
534 reads
SQL University SSIS : Named Pipes -- Producer
Yesterday, I set up the premise for using named pipes in SSIS. Today we are going to get into the...
2011-09-27
674 reads
SQL University SSIS : Named Pipes -- Fundamentals
There comes a time when you look at how something is being done and say, "Does it have to be...
2011-09-26
585 reads
Easily view errors from Script Components
I've been doing quite a bit of work for my upcoming SQL University class next and in it is a...
2011-09-23
765 reads
Easily view errors from Script Components
I've been doing quite a bit of work for my upcoming SQL University class
next and in it is a Script Component. These are the ones that live inside
of...
2011-09-23
3 reads
Easily view errors from Script Components
I've been doing quite a bit of work for my upcoming SQL University class next and in it is a Script Component. These are the ones that live inside...
2011-09-23
2 reads
SSIS OLEDB Command and procedure output params
While designing a package last week with our consultant, Latha Chandri (twitter), I came across a need to call a...
2011-06-30
8,601 reads
Blogs
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,...
The Mystery of the Locked-Up Database -Scooby Dooing Episode 6
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
Forums
Don't Forget About Financial Skills
Comments posted to this topic are about the item Don't Forget About Financial Skills
Building a Simple SQL/AI Environment
Comments posted to this topic are about the item Building a Simple SQL/AI Environment
Checking Identities
Comments posted to this topic are about the item Checking Identities
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