CODEWITHSUNDEEP
sql-serversql-server-2008
edgarmtze
edgarmtze

Reputation: 25058

SQL Server UDF, load and use it 2008

I know we can use functions in SQL Server, but my question here:

If I write a udf, do I have to use something 'visual basic', or something, could you please provide a simple example, how to load that function, because if it is a simple function is enough to execute it, but if it uses vb?

Upvotes: 0

Views: 82

Answers (1)

Mitch Wheat
Mitch Wheat

Reputation: 300728

SQL Server UDF (User Defined Functions) are usually written in TSQL, but they can also be written using the CLR.

A typical use of a CLR Function or Stored Procedure is for string manipulation (which TSQL wasn't really designed for and only has limited functionality built-in)

Upvotes: 2

Related Questions