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)
 Add a function to views?

Author  Topic 

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2007-04-20 : 14:32:58
Is it possible add a user define SQL function in Views?

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2007-04-20 : 14:41:07
Yes. A UDF can be used anywhere a standard function can be used.
Remember though, unlike a standard function you must qualify the function name with the owner:
select dbo.[Function](Parameter)

...and all parameters are required, even those you define with defaults.

e4 d5 xd5 Nf6
Go to Top of Page
   

- Advertisement -