User defined functions in SQL server 7.0

[Sergio]

Hi all!!
Does anybody know how I can create a function in SQL 7.0?? I have to
create functions that return a value that can be used in a select
statement. I think SQL Server version 7.0 doesn't support CREATE
FUNCTION, does it?

Ex:
Select MyFunction(Parameter)
From MyTable

Thanks a lot,

[Reg Besseling]

Yes it does simple eg included

CREATE FUNCTION sqre (@num as int)
RETURNS int
AS
BEGIN

RETURN @num*@num

END

and to test

select dbo.sqre (5)

Regards

Reg :-)
"Sergio" <ba******@hotmail.com> wrote in message
news:6e**************************@posting.google.c om...

Hi all!!
Does anybody know how I can create a function in SQL 7.0?? I have to
create functions that return a value that can be used in a select
statement. I think SQL Server version 7.0 doesn't support CREATE
FUNCTION, does it?

Ex:
Select MyFunction(Parameter)
From MyTable

Thanks a lot,

[Simon Hayes]

"Sergio" <ba******@hotmail.com> wrote in message
news:6e**************************@posting.google.c om...

Hi all!!
Does anybody know how I can create a function in SQL 7.0?? I have to
create functions that return a value that can be used in a select
statement. I think SQL Server version 7.0 doesn't support CREATE
FUNCTION, does it?

Ex:
Select MyFunction(Parameter)
From MyTable

Thanks a lot,

Correct - user-defined functions are new in MSSQL 2000. In 7.0, you still
have to use stored procedures. You might find this useful:

http://www.algonet.se/~sommar/share_data.html

Simon