Desktop MOTD

“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 →

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 →