Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Can I write a SP which works like build-in function

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-01-30 : 08:40:19
Michael writes "For example, Can I write a Sp named sp_test(arg), and then
I use SQl as follow:

select sp_test(a_column) from table_a

make it works like oracle's funtion

Thanks."

Andraax
Aged Yak Warrior

790 Posts

Posted - 2002-01-30 : 08:52:33
If you are using SQL2000, look up UDF's (User Defined Functions). They work exactly like you want.

Regards,
Andraax

Go to Top of Page
   

- Advertisement -