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
"Computers are useless. They can only give you answers." -- Pablo Picasso
A: In my opinion, they should improve on localization, availability, indexing, searching and visualization. That's my wish list and yours?
If you are interested in Social Networking services, this is the place to go:
Home of the Social Networking Services Meta List
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
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.
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.