?php the_time('F, Y');?>
Tuesday, January 29th, 2008
Microsoft SQL Server allows to return the results of a query in XML format.
Let's create a simple table:
create table test
(
field_a varchar(20),
field_b varchar(20)
);
insert into test values('Microsoft','SQL Server');
insert into test values('Oracle','Oracle Database');
SQL to XML transformation is very simple to use. It's done by adding following clause at the end of a query:
FOR ...
Posted in Ms Sql Server, Sql, Xml | No Comments »
Friday, January 25th, 2008
Some people think that there is no difference between an adware and a spyware.
Spyware is just a web term used to refer to an advertising supported software, which is otherwise known as adware. These are the pop-up ads that often come out whenever we open a website or download ...
Posted in Adware, Security, Spyware | No Comments »
Wednesday, January 23rd, 2008
1. Create a DNS name for your Access Database(*.mdb file) which you want to connect.
Start -> Settings -> Control Panel -> Data sources
Select Access in User Data Source
Click Create
Select ...
Posted in Databases, Java, Microsoft | No Comments »
Thursday, January 10th, 2008
Wireless devices are red hot. For example, the number of mobile phones is double that of PCs and continues to increase; sales of wireless Web devices are expected to grow from $10 billion in 2000 to $73 billion in 2005, according to consultants Strategy Analytics. While there are many debates ...
Posted in Asp, Mobile phones | 1 Comment »
Thursday, January 10th, 2008
Up until .NET there was no real error handling in ASP code. Sure, you have your "On Error Resume Next" and "On Error Goto 0", but there was no good structured error handling. I can truly say there has not been one Web application I have come across of decent ...
Posted in Asp, Asp.Net, IIS, Security | No Comments »
Thursday, January 10th, 2008
When first testing a database, nothing is more useful than iSql, and to be able to display and modify your data quickly and simply. This software is given with almost all sql databases and is used to execute queries.
In this article we will see how to build our own iSql ...
Posted in Asp, Sql | No Comments »
Tuesday, January 8th, 2008
It’s that wonderful time of year again—the International Consumer Electronics Show (CES) in Las Vegas, Nevada. Running from January 7-10, 2008, CES is the largest electronics expo in the USA—so big that it’s being held at two separate convention centers: the Sands Expo and Convention Center/The Venetian, and the Las ...
Posted in Gadgets | No Comments »
Monday, January 7th, 2008
If you've ever written a script that needs to UPDATE or INSERT Date values in a database and you live outside of North America, then I'd nearly bet that (like me) you've stayed up until midnight cursing the fact that all dates in SQL Server and MS-Access are natively converted ...
Posted in Databases | No Comments »
Sunday, January 6th, 2008
Blackberry is to unveil new series?
While Research In Motion Ltd. remains mum on any and all future products, that silence isn't shared around the Web as details of new BlackBerry models have begun to emerge.
Members from the BlackBerry Forums have unearthed a prototype 9000 series device being sold on eBay ...
Posted in Gadgets | 1 Comment »