Truncate SQL Command and AutoNumber

Note for myself...

TRUNCATE TABLE (Transact-SQL)
SQL Server 2008 R2

If a table contains an identity column, the counter for that column is RESET to the seed value defined for the column. If no seed was defined, the default value 1 is used. To retain the identity counter (AutoNumber), use DELETE instead of TRUNCATE.

Comments

The Ole Village Greens Golf Course

Peez took me out to one of our old college favorites 2 weekends ago. The course is called THE VILLAGE GREENS and it resides in lovely Ozawkie, KS near Perry Lake. We played this course quite a bit in our later days in college because it was cheap and fun. All we had was Alvamar when we were at KU and she’s a little pricey for college kids. Anyway, it was humid and hot but good times. After, we stopped in Oskaloosa to watch the final round of the PGA at some local ‘downtown’ bar called Angie’s?

Google Play (Music) Keyboard Shortcuts

Space bar : play or pause music. Right/left arrows : next/previous songs. Shift+ right/left arrows : seek forward and backward S In the current song. / : search box Delete : delete track. p : create a new playlist. i -:make an instant mix from the current song. = : Increase the player volume. - : Decrease the player volume. Alt+= : thumbs up. Alt+- : thumbs down. s : Toggle shuffle on or off. r : Toggle repeat between off, all, and one. e : Edits the currently selected songs.

Simulating A Right-Click From The Keyboard

I have been doing quite a bit of LogMeIn (IT Reach and Rescue) lately and sometimes my mouse right-click does not work to get context menus. Therefore, if you ever have this issue, just select the icon or item you need and press [Shift] [F10]. I am sure Tim could have told me this, but he wasn't here :)

Kyle Archer

Search This Blog