Archive

Archive for November, 2006

What is the difference between CAST and CONVERT in SQL?

November 30th, 2006 No comments

You can use either CAST or CONVERT. Because CAST and CONVERT provide similar functionality.

The difference is CASE is more ANSI standard and use this only if you are writing a program which you will need to use in many database platforms. Where CONVERT is Microsoft specific and more powerful.

Links:
http://msdn2.microsoft.com/en-us/library/ms187928.aspx
http://searchwinit.techtarget.com/tip/0,289483,sid1_gci1014050,00.html

VN:F [1.9.18_1163]
Rating: 4.8/5 (4 votes cast)
Categories: SQL

Technological Myopia in Kerala

November 27th, 2006 No comments

Govt. of Kerala took a very bad decision to take off Microsoft products from Schools. As far as I know more than 70% of the machines in Kerala (also the whole India) is running on Microsoft Windows. And 25% of the machines use Linux and that too for Server purpose only. Microsoft’s products are giving more support and user friendlyness and the very important thing is JOB MARKET!.

Politicts is that much bad now? I was a small student leader representing a political party 5-6 years back at my college. That time I thought these parties are standing for the helping of people. It is very horrible that a Govt. ordered such a bad decision in a Technologically Developing State. I heard this decision is because of political problems between previous Govt. and the Present Govt. How sad :(

Well, I have posted a related thing at t-mug forum – http://forum.t-mug.org/topic.asp?TOPIC_ID=1529.

If you think the decision taken by the Govt. is not helpful for the development of Kerala, please sign on the petition at http://www.petitiononline.com/Kerala1/petition.html

VN:F [1.9.18_1163]
Rating: 0.0/5 (0 votes cast)
Categories: News

Contineous Javascript Marquee

November 24th, 2006 No comments

This script will let the text scroll contineously. This means, the second round scroll will start just after first round. This will overcome the in-between delay of HTML MARQUEE tag. However, this script is not free from limitations. But works on both IE & Firefox.








VN:F [1.9.18_1163]
Rating: 4.0/5 (1 vote cast)
Categories: Web Design

Windows Logger with VBS

November 7th, 2006 No comments

This is a quick script from my hands which logs the date and time of windows ‘loging’ and ‘logoff’.


dim objfso, objtextfile

set objfso = CreateObject("Scripting.FileSystemObject")
set objtextfile = objfso.OpenTextFile("f:logsystem.txt",8,True)

if WScript.Arguments(0) = "LOGIN" then
objtextfile.Write(vbCrLf & Date & " " & Time)
else
objtextfile.Write(" - " & Time)
end if

objTextFile.Close
Wscript.Quit

The output will be like:
11/7/2006 4:15:25 PM - 4:15:27 PM
11/7/2006 4:15:31 PM - 4:15:32 PM
11/7/2006 4:15:34 PM - 4:15:35 PM
11/7/2006 4:15:36 PM

To configure the script in your system you may use “gpedit.msc”. Under “User Configuration” -> “Windows Settings” -> “Scripts(Logon/Logoff)”.

This is the syntax:
[filename .vbs] LOGIN
[filename .vbs] LOGOFF

VN:F [1.9.18_1163]
Rating: 0.0/5 (0 votes cast)
Categories: General