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.
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 AnalyserI 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')MadhivananFailing 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 |
|
|
|
|
|