Augusta’s Winking Judge August 30 2006
Just a quick post to let everyone know that the Winking Judge now has a MySpace page. Here is the link:
http://www.myspace.com/thewinkingjudge
Hamilton Restaurant Guide August 24 2006
For those of you that live in the Hamilton / Ancaster are of Ontario, here is an online resource that allows you to look up local restaurant menus.
Stored Procedures That Return the IDENTITY August 21 2006
The secret lies in the function “SCOPE_IDENTITY()” which references that last ID inserted within the scope of the procedure. See the following:
CREATE PROCEDURE [dbo].[usp_FORMS_E_InfoEntry_INSERT]
@NAME VARCHAR(255) ,
@ID_FORMS_E_InfoEntryCategory INT
AS
SET NOCOUNT ON
INSERT INTO [dbo].[FORMS_E_InfoEntry]
(
NAME,
ID_FORMS_E_InfoEntryCategory,
creation_datetime
)
VALUES
(
@NAME,
@ID_FORMS_E_InfoEntryCategory,
GetDate()
)
SELECT SCOPE_IDENTITY() AS ID
SET NOCOUNT OFF
GO
Cicada August 09 2006
I have decided to write a post about Cicada (sick-eh-dah) which are bugs that produce an interesting sound. Most people in Southern Ontario are probably quite familiar with this sound that can be heard on a hot summer day. Its sort of a droning buzzing noise, kind of like crickets. The difference with this sound is it seems they are all in on it. Once one starts they all start and the noise gets louder and louder and eventually tapers off.
Anyway… these bugs are called Cicada. Most people confuse this noise with Grasshoppers or Locusts.
Read more here : http://en.wikipedia.org/wiki/Cicada
