下次感冒初起， 不妨试试 !

下次感冒初起， 不妨試試 !

可以很快使感冒或頭痛不再繼續惡化！

友人轉寄，說 得蠻有道理的，提供參考！

如果你感覺到已經開始流鼻水、連續打噴嚏、有點頭痛，就快要感冒了！趕緊先喝兩、三杯熱 開水（不可以喝冰的)

等三、五分鐘，再沖一杯咖啡，任何咖啡都可以，三合一的最方便了，如果沒有，鐵罐子的咖啡? ?

可以，一定要熱的喝才有效 ( 不可冰）。

二、三十分鐘以後，咖啡和先前喝的開水會讓你要尿尿，而且，很神 奇的，流鼻水、打噴嚏、頭痛都慢慢不見了！

想 知道為什麼這麼好用？

一、咖啡可以讓你加速排 尿，加上先喝的開水，可以把已經侵入繁殖的病毒，從身體裡「洗」掉大部分。

二、咖啡有提神、興奮的作用，會讓你低迷不振的免疫 功能提振起來，病毒從尿尿排掉了一部分，免疫功能又加強了，感冒繼續惡化的可能當然降低不少。

他人的故事 原创心情 有他哪有我。。。

tata的故事 - 原创心情 有你有我
http://tataface1975.spaces.live.com/music/

Date found: 2008-01-04 12am
Song: Jacqueline's Tear
Instrument: Cello

新的一年

2008，第27个年头
多些行动，将是不一样的第一步。

早安，2008
明天再见~！

Using Transactions.TransactionScope

Trying to do with: running Using scope As Transactions.TransactionScope = New Transactions.TransactionScope() in vs 2005 pro by vb.net
Searched by: TransactionScope imports
Source from: http://www.devnewsgroups.net/group/microsoft.public.dotnet.framework.adonet/topic59025.aspx


"Namespace or type specified in the imports 'System.Transactions' doesn't contain any public member or cannot be found. Make sure then namespace... etc."

When I visit the properties of the project and check the available references I can't find it there either. Do I have to do something extra before using that Namespace?


If you are using Visual Studio 2005 Standard Editon & above do the following
Right click on the project
Add Reference
you'll definitely see reference System.Transaction under .NET references in
the references tab.

MSDTC on server is unavailable.

Trying to do with: running Using scope As Transactions.TransactionScope = New Transactions.TransactionScope() in vs 2005 pro by vb.net
Searched by: MSDTC on server is unavailable
Source from: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54705




[*]
On the server where the trigger resides, you need to turn the MSDTC service on. You can this by clicking START > SETTINGS > CONTROL PANEL > ADMINISTRATIVE TOOLS > SERVICES. Find the service called 'Distributed Transaction Coordinator' and RIGHT CLICK (on it and select) > Start.

Test the trigger and see if it works. If it still does not work, wrap you trigger in the following transaction code (found below in bold):


SET XACT_ABORT ON
BEGIN DISTRIBUTED TRANSACTION

-- Put all queries in here (SELECT, INSERT, UPDATE, and DELETE)
select * from [SERVER2].[DBASE].[OWNER].[TABLENAME]
update [SERVER2].[DBASE].[OWNER].[TABLENAME]
set [column] = value
where [condition(s)]

COMMIT TRANSACTION
SET XACT_ABORT OFF


This solution solved our problems, I hope they solve yours.
We ran into the following errors, and the above fixed them:
1. MSDTC on server is unavailable. [fixed this error by started the service above [*] ]
2. Server: Msg 7395, Level 16, State 2, Procedure name, Line 26
Unable to start a nested transaction for OLE DB provider 'SQLOLEDB'. A nested transaction was required because the XACT_ABORT option was set to OFF.
[OLE/DB provider returned message: Cannot start more transactions on this session.]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionLocal::StartTransaction returned 0x8004d013: ISOLEVEL=4096].

msn nick

☑爱自己
☐Rich
LoL ~~ o(∩_∩)o...

DateTimePicker vb.net 2005 bindingsource

These will cause error:

1. DateTimePicker.value = DateTime.Now().ToString("yyyy-MM-dd dddd hh:mm:ss tt")
2. DateTimePicker.value = Format(Now, "yyyy-MM-dd dddd hh:mm:ss tt")
   

if assign value to any components(comboBox.selectedIndex, DateTimePicker.value) within constructor New() body, after form those assigned value don't work as expected.

fixed by: assign value within form_load body.

sql server functions

SQL Server 2000

There are three types of UDF in Microsoft SQL Server 2000:

1. Scalar functions.
2. Inline table-valued functions.
3. Multistatement table-valued functions.

Scalar functions return a single data value (not a table) with RETURNS clause. Scalar functions can use all scalar data types, with exception of timestamp and user-defined data types. Inline table-valued functions return the result set of a single SELECT statement. Multistatement table-valued functions return a table, which was built with many TRANSACT-SQL statements.

User-defined functions can be invoked from a query like built-in functions such as OBJECT_ID, LEN, DATEDIFF, or can be executed through an EXECUTE statement like stored procedures.

The Structure of Stored Procedures

The Structure of Stored Procedures
(from SQL SERVER 2000 Stored Procedure Programming)

We will pause aminute to explain the structure of a stored procedure.
A stored procedure encapsulates a relatively simple Select statement for later use.
It returns a recordset containing values from the Selected column.

The recordset will contain only records that matched with the WHERE statement.

The code of a stored procedure consists of a header and a body.

The header of the stored procedure defines external attributes of the stored procedure—its name and a list of one or more parameters.

A example stored procedure has two parameters.
Parameter names must start with the @ character.
The developer must also define a datatype for each parameter.
The header must begin with the Create Procedure keyword and finish with the As keyword.

The body of the stored procedure contains the Transact-SQL statements to be executed when the stored procedure runs.

In this example, there is just one Select statement using the procedure parameters.

钻石水机用户，是真是假，有关当局快快帮帮忙。

Cz：　钻石水机用户，是真是假，有待你的医生从你的医药报告　一一告知以你

有線新聞踢爆鑽石能量水廣告
http://www.youtube.com/watch?v=-NkHV0a10Do

鑽石水機用戶，請立刻驗腎!!!
請立刻轉寄給所有鑽石水機用戶，功德無量!!!

鑽石水機用戶感染腎小球腎炎 - 李小姐 32 歲，每年都有例行全身檢驗的習慣，
2006 年 2 月，李小姐安裝了一台鑽石水機，開始生飲過瀘後的水，
2006 年4月作例行全身檢驗時發覺感染了腎小球腎炎，腎功能開始衰退。

據知馬來西亞，新加坡和香港已有多人受感染。 鑽石水機大腸桿菌嚴重超標

鑽石水機用戶陳先生，2006 年6月安裝了一台鑽石水機，開始生飲過瀘後的水，
感到身體不適，每天肚瀉多次，代理解釋為好轉反應，陳先生不放心，
於是自行把過瀘後 的水交化驗所化驗，結果是大腸桿菌嚴重超標。
陳先生於是立刻退機。


Cz：　有关当局快帮帮忙，别让你忠实的用户，过于担心。
好的产品当然不怕考验，希望这一封转邮，纯属恶搞。
要不然，受害者多得是啊～

p/s：查证后，将有详细的讯息　将陆续上载～

new function of blogger

today, new function from blogger.

Write. Share. Post.
Post to Blogger from Google Docs & Spreadsheets.

friendster vs facebook

trend of customizing for friendster steping after facebook.

few days back, friendster launched something which is similiar with facebook.

From - An.Inconvenient.Truth.2006.

From “An.Inconvenient.Truth.2006.”

Learn as much as you can about the climate crisis.
Then put your knowledge into action. www.climatecrisis.net

vb.net time format string.

Codes	Output
Format(Now, "h")	System.FormatException was unhandled Input string was not in a correct format.
FormatDateTime(Now, DateFormat.ShortTime)	19:36 (in 24 hour)
DateTime.Now.ToString("h") or Now.ToString(" h")	7 (in 12 hour)
Now.Hour.ToString(" h")	h (not appear figure in hour)

reference of string formating:
• http://msconline.maconstate.edu/tutorials/VBNET/VBNET01/vbnet01-08.aspx
• http://www.stevex.org/CS/blogs/dottext/articles/158.aspx

转：hottest forum in china

http://www.tianya.cn/
[5:32:27 PM] Gwyneth Tham says: iit's one of the hottest forum in china nowadays
[5:32:27 PM] Gwyneth Tham says: it has lots of forums for lots of topics

Formatting Dates and Times

Formatting Dates and Times

A format string for date/time values can use one of the predefined string values shown in the following table.

String	Description
Long DateD	Displays a date in long date format.
Short Dated	Displays a date in short date format.
Long TimeT	Displays a date in long date format.
Short Timet	Displays a date in short date format.
F	Displays the long date and long time.
f	Displays the long date and short time.
g	Displays the short date and short time.
Mm	Displays the month and the day of a date.
Yy	Formats the date as the year and month.

---

Examples of applying a format string to date/time values are shown in the following table.

Format	Output
Format(Now,"D")	Thursday, November 29, 2007
Format(Now,"d")	11/29/2007
Format(Now,"T")	3:20:02 AM
Format(Now,"t")	3:20 AM
Format(Now,"F")	Thursday, November 29, 2007 3:20:02 AM
Format(Now,"f")	Thursday, November 29, 2007 3:20 AM
Format(Now,"g")	11/29/2007 3:20 AM
Format(Now,"m")	November 29
Format(Now,"y")	November, 2007

kitten for adoption

Born/Found on 2007 Nov 25
Photo took on 2007 Nov 27

Bio status:
- healthy
- eyes still closing
- milk feeding

if any one interested, pls contact me before too late.


Open Adoption Closed on 2007 Nov 30.

TypeInitializationException was unhandled

Public g_sptCompany As new clsCompany

fixed by:
Public g_sptCompany As clsCompany
g_sptCompany = new clsCompany

Then VS2005 show me in the clsCompany constructor have some errors in VS2005 errors list, then easy to fix.

Editing guide for private battlenet server of Warcraft III.

well...,
just simply a lousy guide for editing private battlenet server of warcraft III,
will keep update ya.

(assuming your copy of Warcraft III in pc is installed, able to play in single player and LAN,
and u able to connected to official battlenet servers,
but could not login due to id and password)

Tools: BNetGatewayEditor.exe version: 2.0.3.1. (perfer this version's flexibilities)	Url: http://track.eurobattle.net/ browser: any will do. (any will do)

To be continue...

different of beginning and ending.

friendster Shoutout:

"~=~N0body cAn g0 baCk and staRt a nEw begiNning, but any0ne can sTart t0day and mAke a new ending."~=~"