|
Microsoft Connect is the method by which the community can express what it would like to see in updates and future releases of SQL Server. Greg Low, a SQL Server MVP, and director of SQL Down Under submitted a very compelling Connect item 265266, Add server-side compilation ability to SQL CLR which aims to remove the requirement to develop SQLCLR assemblies external to SQL Server. Instead Greg proposes that the SQL Server be able to accept the CLR code inline with the CREATE FUNCTION/PROCEDURE/TRIGGER/AGGREGATE statements similar to the following:
CREATE PROCEDURE my_proc @par1 int,
@par2 int WITH
EXTERNAL LANGUAGE C#, PERMISSION_SET = EXTERNAL_ACCESS AS
using System;
using System.Data;
using System.Data.SqlClient;
...
Greg also recommends that there be the ability to catalog an assembly similar to:
CREATE ASSEMBLY myassembly FROM CLRCOMPILE('C#','code goes here')
which will make this a very readable source instead of the compiled binary that we get in the existing methodology. If you feel that this is important, let Microsoft know by opening the link above and voting for the suggestion.
|