“Try it, You’ll like it” says the wife. “Download it, use it.” says the developer “What is it? Why should I?” says the visitor Get it here. Well, it is a small application that I wrote to write messages onto your desktop picture. I wanted to see bible verses on my desktop that would rotate at some interval. To Use:… Read more →
Category: code
SCOPE_IDENTITY() returns a value?
I have long used SCOPE_IDENTITY() to get the primary key of a newly inserted row immediately after the INSERT statement. For example: INSERT INTO myTableSELET @var = SCOPE_IDENTITY() What I incorrectly assumed was that the value was reset with each statement similar to the behavior of @@ERROR. If not each statement, then each INSERT statement. In other words, [@more@]if I… Read more →