How to run a User Defined Function

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)

How to run a User Defined Function

Author

Topic

rahul8346
Starting Member

21 Posts

Posted - 2006-04-28 : 07:37:13

Please Guys, Do tell me how to run a User Defined Function from Query Analyser
I Tried out the following...
1)print dbo.udfSupportTicketGetAsset('Systems')
Error :Invalid object name 'dbo.udfSupportTicketGetAsset'
2)Select * from :: dbo.udfSupportTicketGetAsset('Systems')
Error : Incorrect syntax near '.'
3)select * from ::Syscmdb.dbo.udfSupportTicketGetAsset('Systems')
Error : Incorrect syntax near '.'
My Udf return an table and takes an varchar parameter

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-04-28 : 07:43:38

Select * from dbo.udfSupportTicketGetAsset('Systems')

Madhivanan

Failing to plan is Planning to fail

Kristen
Test

22859 Posts

Posted - 2006-04-28 : 09:14:47

... unless its a scalar function, in which case it would be:

SELECT dbo.udfSupportTicketGetAsset('Systems')

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources