Using .net assemblies in SQL Server 2005

Question

I recently discovered that you can host .net assemblies on SQL Server> = 2005 so that .net functions can be called in T / SQL statements.

I wondered what people use for this and how they work?

Answer 1

The first general-purpose use for the CLR in SQL 2005 that I created was with the SQL 2005 assembly, which has many functions that perform string operations and pattern matching using regular expressions. SQL 2005’s native string functions can be extended so that you can check common formats, such as phone numbers or credit card numbers, or perform regular expressions in stored procedures.

SQL CLR .

Answer 2

, .

, XML MSSQL2005.

, .

Answer 3

, - , , MSMQ . , , .NET, T-SQL.

Answer 4

CLR SQL 2005 / , .NET, . , SQL . , datetime -.

Answer 5

, . , T-SQL ( ).

- . ...

• //.

. , UNTRUSTED. reset, /.

2. SQL Server ( ).

, , SQL Server .

3. , , ; .

, Assembly, . , . .