![[-]](/moniwiki/imgs/plugin/arrup.png "[-]")
![[+]](/moniwiki/imgs/plugin/arrdown.png "[+]")
- LCS
- ODBC 쿼리
- Web API Call2
![[https]](/moniwiki/imgs/https.png)
T-SQL 비동기처리(without service broker)
![[http]](/moniwiki/imgs/http.png)
Query to Excel Stored Procedure
- ToUnicode
- Web API Call
- 정규표현식
- Execute Stored Procedures in Parallel
- 문자열 함수
- 중앙값-1분위수-3분위수
- Json
- 누적을 구하는 집계함수
- DistinctCount
- SQLServer & .NET CLR libraries and utilities
- XLSExport: A CLR procedure to export proc results to Excel
[edit]
1 참고자료 #
- https://code.google.com/p/accord/ --> The Accord.NET Framework
- https://code.google.com/p/aforge/ --> AForge.NET Framework
- SQL CLR: An Introduction
- The Database Administrator’s Guide to the SQL Server Database Engine .NET Common Language Runtime Environment
clr.zip
- Invoking CLR User-Defined Aggregate Functions
- CLR Assembly RegEx Functions for SQL Server by Example RegexSQLCLR.zip
- How to create a CLR assembly on a remote server with limited permissions
- SQL Server 2-D Matrix Builder TheMatrixSqlClr.zip
- Calling a Web Service from within SQL Server
- Using CLR Integration in SQL Server 2005
- The DBA’s Guide to SQLCLR
- Managed Data Access Inside SQL Server with ADO.NET and SQLCLR
- Processing XML Showplans Using SQLCLR in SQL Server 2005
- Overview of SQL Server 2005 for Database Developers
- Usage Scenarios for SQL Server 2005 Native Web Services