Gray Wolf Blog

Some of the characters seemed shoe-horned in. Pretty good read overall.

The Night Gardener

Well written and very entertaining. Pelecanos hitting on all cylinders with this one

The Big Blowdown

I was looking for a way to return an Identity value from a dynamic sql statement.

The simplest way is to pass an output parameter along with the sql:

Dim arrParams(0) As SqlParameter
arrParams(0) = New SqlParameter("@iSCID", SqlDbType.Int)
arrParams(0).Direction = ParameterDirection.Output


Then add the following to the end of the sql statement: ” ; Set @iSCID = @@Identity ”

You can then reference the value in this manner (I use the SqlHelper class from MS):

This page has a lot of great information.

The Curse and Blessings of Dynamic SQL

UPDATE: I ran into a situation where I was using triggers for an audit log that caused the above method to return weird @@Identity values. Turns out, if your trigger inserts into another table, that @@Identity will be returned, not the @@Identity from the intended table.

Detailed info – Excerpt below

on the side note: you should NEVER be using @@IDENTITY to get the last inserted identity from a table. this has been shouted down from the havens numerous times. @@IDENTITY will return the last inserted identity from ANY table of TRIGGER within the transaction session. you MUST use SCOPE_IDENTITY(). even IDENT_CURRENT is dangerous from the BOL about the dangers of using anything but SCOPE_IDENTITY():

SCOPE_IDENTITY and @@IDENTITY will return last identity values generated in any table in the current session. However, SCOPE_IDENTITY returns values inserted only within the current scope; @@IDENTITY is not limited to a specific scope.

For example, you have two tables, T1 and T2, and an INSERT trigger defined on T1. When a row is inserted to T1, the trigger fires and inserts a row in T2. This scenario illustrates two scopes: the insert on T1, and the insert on T2 as a result of the trigger.

Assuming that both T1 and T2 have IDENTITY columns, @@IDENTITY and SCOPE_IDENTITY will return different values at the end of an INSERT statement on T1.

@@IDENTITY will return the last IDENTITY column value inserted across any scope in the current session, which is the value inserted in T2.

SCOPE_IDENTITY() will return the IDENTITY value inserted in T1, which was the last INSERT that occurred in the same scope. The SCOPE_IDENTITY() function will return the NULL value if the function is invoked before any insert statements into an identity column occur in the scope.

Pretty good. Moves along at a good clip.

Hell to Pay

Good for an evening with nothing to do, but don’t ask for much more than that.

Drama City

First 1/3 was interesting. The rest was tedious.

Stalin: The First In-depth Biography Based on Explosive New Documents from Russia’s Secret Archives

Author and Bosch seem to be getting a bit tired in this reworked NYT serial.

The Overlook (Harry Bosch)

Usually, setting Recovery Model to Simple in Options is enough to get started in shrinking a Sql Server db.

However, you may also need to rebuild clustered indexes on large tables. This reorganizes the index and releases the space.

The first 60-80 pages are about papal politics and the overall situation in Europe, which I ended up skimming. Once the crusaders got under way, things started to get interesting. There is actually much more information about the siege of Antioch than Jerusalem. From cannibalism to siege engines to unremitting bloodshed, its hard to imagine how anyone survived.

The First Crusade: A New History: The Roots of Conflict between Christianity and Islam

I read this after seeing the movie Mongol which was a pretty good introduction. The scope of the Mongol conquest was awesome. Story lags a bit after Genghis’ death, but a good read overall.

Genghis Khan and the Making of the Modern World

This one stretches the willful suspension of disbelief but is good for a day off.

Echo Park (Harry Bosch)

Bosch is back from retirement and back in the mix.

The Closers (Harry Bosch)

In order to use the standard response.write method of exporting to excel, you need to force AJAX to make a full postback. Otherwise, parsing errors occur.

To force a postback, assign a control to a trigger and put the export logic in the control click event or in the page.ispostback portion of page_load.

Trigger syntax:


</ContentTemplate>
<Triggers>
<asp:PostBackTrigger ControlID="btnGo" />
</Triggers>
</asp:UpdatePanel>


Keeps you off balance throughout. One of the better in the Bosch series.

City of Bones (Harry Bosch)

Penguin Lives series is somewhat like the cliff notes of biography. Some interesting theories on the birth of totalitarianism and secret police force that grew out of the French Revolution.

Napoleon (Penguin Lives)