All Posts Tagged Tag: ‘SQL’
All the hype that once surrounded XML is finally starting to die down, and developers are really beginning to harness the power and flexibility of the language.
A PL/SQL RECORD is a composite datatype. In contrast to a scalar datatype like NUMBER, a record is composed of multiple pieces of information, called fields. Records can be declared using relational tables or explicit cursors as “templates” with the %ROWTYPEdeclaration attribute.
I WAS JUST THINKING of calling Jill the Transmeta Molette when a vibrating sort of call came through on my CDMA Issa enabled cellphone. It was Tarquin from Sacramento and what he said made me go all quivery and jelly-kneed.
SQL Server 2000 was designed to operate as an integral part of the Windows 2000 domain environment. Unfortunately, the new features that best exemplify this integration are rarely taken advantage of. The purpose of this article is to present their overview.
If you’re having trouble keeping track of your business, you may want to have a look at SQL Server 2000 For Developers Part 1. With this product, you can build databases that will help you keep track of, for example, your debtors or creditors. You can perform any number of queries on your sales records. For example, you may want to know how many debtors you have in any one city or, you could pull out from your sales database all those debtors who owe you more than say, $10, 000.00.
First off, let’s explain a little about the common situation that this “how to” is targeted towards. FoxPro 2.x was a big part of many applications in the early 90’s and those applications ran/run just fine. However, compared to SQL Server 2000, or any other modern DBMS, it’s a joke.
One of the most frustrating things to me is seeing developers doing new things, but in “old” ways. A classic example is one you may have seen yourself: Here we have a sophisticated client – side application that runs in Internet Explorer, we use XML Data Islands and XSLT transforms and parameters, templates, and we even use XMLHTTP from the client. And along with this we may have page upon page that needs to get a recordset from SQL Server – sometimes many recordsets, and bring them into the page as XML so we can do all our “new kind of cool stuff” with it. Well, that’s great.
Software is only as complicated as its developers make it.
It seems like a very profound sentence but it is so true and it is relevant to all commercial software that I know of. Let’s take a test case of a certain piece of software most of us have probably encountered.
To begin, you will need a machine on which you can test some sample scripts. The easiest way to accomplish this if you haven’t already done so is to download ASP from Microsoft and install it with PWS on your Win95 or WinNT box. There are plenty of resources available for describing how to do this, so I won’t waste any more time on it.