Archives
-
Testing BlogJet
I have installed an interesting application - BlogJet. It's a cool Windows client for my blog tool (as well as for other tools). Get your copy here: http://blogjet.com
-
Roman's Weekly SQL Server Tip - Case of mistaken @@IDENTITY
Just read Roman's Weekly SQL Server Tip - Case of mistaken @@IDENTITY
-
Paint.NET 2.0 - The final version of this supercharged Paint replacement has been released.
Paint.NET 2.0 - The final version of this supercharged Paint replacement has been released.
[Via Mike Gunderloy] -
Q: What should Social Network sites improve?
A: In my opinion, they should improve on localization, availability, indexing, searching and visualization. That's my wish list and yours?
-
Home of the Social Networking Services Meta List
If you are interested in Social Networking services, this is the place to go: Home of the Social Networking Services Meta List
-
How to subscribe to MSN Spaces RSS feeds
Probably somebody else has already posted about it, but I'll write about it here anyway, so the word spreads faster.
To subscribe to MSN Spaces RSS feeds, just enter the the HTML URL, plus "/feed.rss". As an example, suppose you want to add Shiju Varghese MSN space to your blogroll in your RSS aggregator. To accomplish this, you'll have to subscribe to Shiju Varghese RSS feed -
Express ClickYes - auto-click the Outlook security prompt
I have some VB6 programs which uses MAPI to send email messages and after updating to Windows XP + Outlook 2002 they stopped working due to Microsoft Outlook security prompt. As I found no way to curstomize (say which programs can and cannot send mail) or even turn it off, I just downloaded Express ClickYes - auto-click the Outlook security prompt and installed it. If you, like me, do not afford paying an employee to stay 24 hours a day, seven days a week in front a computer, just clicking the "Yes" button, then give Express ClickYes - auto-click the Outlook security prompt a try.
-
Something I learnt about SQL table type this week
Q: When I try to compile the procedure below I get the error Must declare the variable '@TableType'. Can you guess why the following stored procedure does not compile?
CREATE PROCEDURE #SystemTablesAndColumns AS DECLARE @TableType TABLE (id int, name sysname) INSERT INTO @TableType ( id, name ) SELECT id, name FROM sysobjects WHERE name LIKE 'sys%' ORDER BY name SELECT @TableType.id AS TableID, @TableType.name AS TableName, syscolumns.colid AS ColumnID, syscolumns.name AS ColumnName FROM @TableType INNER JOIN syscolumns ON @TableType.id = syscolumns.id ORDER BY @TableType.name, syscolumns.name RETURN
A: Because aliases are missing for the table type, as can be noted below:CREATE PROCEDURE #SystemTablesAndColumns AS DECLARE @TableType TABLE (id int, name sysname) INSERT INTO @TableType ( id, name ) SELECT id, name FROM sysobjects WHERE name LIKE 'sys%' ORDER BY name SELECT TableType.id AS TableID, TableType.name AS TableName, syscolumns.colid AS ColumnID, syscolumns.name AS ColumnName FROM @TableType AS TableType INNER JOIN syscolumns ON TableType.id = syscolumns.id ORDER BY TableType.name, syscolumns.name RETURN
P.S.: What the temporary stored procedure above does can be acomplished in other ways. I just used it that way to show up the problem I faced this week and how I workarounded it. -
Keeping Secrets Secret: Steganography with .NET
Just read Keeping Secrets Secret: Steganography with .NET, an interesting article from DevX