Re: Is MS-SQL6.5 in the same league as Oracle, Sybase?

In article <53uhmm$4eu_at_netnews.hinet.net>, npis_at_ms1.hinet.net says...
>

 stuff delete. User-defined functions....
>>
>They are called extended stored procedures in MS SQL Server. User defined
>functions are compiled into DLL's and then can be called in the same manner
 as
>stored procedures. MS supplies a number of them for specific uses (such as
>mail and executing an NT command).
>
>Good Luck
>
These are NOT actually user-defined functions, in the sense that they CANNOT be used in a select statement. 6.5 lets you use them to create rows in an INSERT, but you can't do:

select * from myTable where thisColumn = userDefinedFct(thatColumn)

I believe this capability is promised for 7.0

--Chip Received on Tue Oct 15 1996 - 00:00:00 CEST