Thread: Technical Suggestion Pl. Clarrify.

Technical Suggestion Pl. Clarrify.

From

"sathya"

Date:

04 May 2001, 18:28:24

Hi,

I am working as Software Architect in malaysia.

I am facing a problem while i am calling a stored procedure in the Select Statement.

Here's my problem,

My Table structure is,

Table Name - Country

        CountryID    Int
        CountryName Char

My Query is ,

Select countryId, countryName, getCountry(countryname,"XX") from Country

   getCountry(name as String , value as string)
   {
getcountry = name & value
   }

Kindly suggest me will this SELECT QUERY works.

If possible kindly get me any alternate methods to get it done.

My platforms are

Visual Basic, SQL server.

Anxiously Waiting for your reply.

Thanks a million,
Sathya Narayanan D

Re: Technical Suggestion Pl. Clarrify.

From

Joel Burton

Date:

04 May 2001, 20:09:15

On Wed, 2 May 2001, sathya wrote:

>   If possible kindly get me any alternate methods to get it done.
>
>   My platforms are
>     Visual Basic, SQL server.

An excellent alternative method to getting this done would be:

1) Delete SQL server from your system.
2) Install PostgreSQL, a very nice Open Source database system.

for extra credit, s/Visual Basic/Python/g;

... and just think of the money you'll save!

Seriously though, this is a list for the discussion of issues around
PostgreSQL. Questions about SQL Server are not appropriate here.

--
Joel Burton   <jburton@scw.org>
Director of Information Systems, Support Center of Washington