ASP.NET, SQL Server, WPF, C#, VB.NET

"Leila" <Leilas@hotpop.com> wrote in  
  
news:Ozzn1J1HGHA.984@tk2msftngp13.phx.gbl:  
  
Yes, you are right that you can use the members mentioned above in the  
  
SqlFunction attribute. However, UDT's can have instance methods, which  
  
are doing data access. If the instance method of your UDT executes data  
  
access, you have to use the SqlMethod attribute together with the  
  
DataAccess and SystemDataAccess member as per above.  
  
Likewise, if the method changes the internal state of the UDT in SQL  
  
Server, you have to mark your method with the SqlMethod attribute and  
  
the IsMutator=true member.  
  
Niels  
  
--  
  
**************************************************  
  
* Niels Berglund  
  
* http://staff.develop.com/nielsb  
  
* nielsb@no-spam.develop.com  
  
* "A First Look at SQL Server 2005 for Developers"  
  
* http://www.awprofessional.com/title/0321180593  
  
**************************************************

Hi,  
  
In the first line of description for SqlMethodAttribute Members in MSDN has  
  
been stated that:  
  
"Indicates the determinism and data access properties of a method or  
  
property on a user-defined type (UDT)".  
  
As far as I learned, these attributes are relevant to TVFs (e.g  
  
FillRowMethodName, TableDefinition).  
  
Did the author of this page mean:  
  
"Indicates the determinism and data access properties of a method or  
  
property on a user-defined functions(UDF)"  
  
or there is something that I am not aware of that?  
  
Thanks in advance,  
  
Leila