Execute Function

All replies

• 

  

  0

  Sign in to vote

  For scalar function:

  select dbo.fun_sample()

  or

  declare @v int

  set @v = dbo.fun_sample()

  For table-value function:

  select * from dbo.fun_sample()

  Monday, February 26, 2007 9:57 AM
• 

  

  0

  Sign in to vote

  sorry, u have not got my question.
  
  my doubt is why we are specifying the ownername for executing a function?
  
  
  
  
  

  Monday, February 26, 2007 10:25 AM
• 

  

  0

  Sign in to vote

  "dbo." isn't owner name, it's schema. If you use function without schema name, SQL Server think that it's system function. For stored procedures "sp_" prefix is a reason to resolving as system stored procedure.

  Monday, February 26, 2007 10:47 AM
• 

  

  0

  Sign in to vote

  firstly its a schema name or owner name, depending on the version of sql server being used...owner for 2000 and schema for 2005

  for the main question...why dbo. for a function... i guess its just a syntax thing ...and it does saves time for the server... so maybe i'll use it evn if its not mandatory.... use it for sps as well....

  Monday, February 26, 2007 1:37 PM