Set Command in UDF

• Rohit @ SQL

  SSC Eights!

  Points: 938

  More actions

  February 10, 2004 at 10:07 am

  #108864

  i want to use Set Datefirst 1 statement in UDF but when i create the UDF it gives error invalid use of Set Command how can i use set command in UDF

  
  Rohit

• Jonathan

  SSC-Insane

  Points: 20427

  More actions

  February 10, 2004 at 11:36 am

  #493458

  You cannot, of course.

  Even if you could change a setting like that in a UDF, you still wouldn't be able to use any functions that depend upon the setting, as they are, due to that very setting, nondeterministic. 

  
  
  --Jonathan

• Rohit @ SQL

  SSC Eights!

  Points: 938

  More actions

  February 11, 2004 at 2:20 am

  #493572

  that means you can not use Set Commnads in UDF so any can make me available limitations od UDF cause i use them exetensively

  
  Rohit

• Calvin Lawson

  SSChampion

  Points: 11030

  More actions

  February 11, 2004 at 7:21 pm

  #493733

  R,

  Techically, you can the Update DML statement in a UDF, but it can't affect any tables outside the udf.

  If you wanted to do that you'd have to write like so:

   

  Update t 

  set column1=f.column1     

  from table1 t 

  JOIN function() f on t.ID = f.ID

   

  Signature is NULL