I have a SQL CLR Function (written in c#.net) that I\'m trying to debug. I attach visual studio to the sqlserver process and begin stepping through, but it keeps crashing and ending with the following
I\'m new here and English isn\'t my native language, so I hope you guys can understand me. Can someone give me an example of how to make a function that create a table with data from result of nested
I have some SQLCLR code for working with Regular Expresions. But now that it is getting migrated into Azure, which does not allow SQLCLR, that\'s out. I need to find a way to do regex in pure T-SQL.
I\'m having issues creating an index on a view that uses a custom CLR aggregate function. I don\'t see any way to flag the aggregate function as deterministic or with schemabinding.
I would like to have a SQL Server function dbo.GetNextNumber(), which would generate sequential numbers for each call. As far as I understand this is impossible with a native T-SQL function as SQL Ser
This has been dogging me for 2 days now.I have a CLR sp that needs EXTERNAL_ACCESS.I can deploy it via VS2010 on my dev box by setting TRUSTWORTHY ON but we don\'t want to do that to the production se
I\'m trying to figure out how I can parallelize some procedural code to create records in a table. Here\'s the situation (sorry I can\'t provide much in the way of actual code):
I\'ve created my first CLR table valued function. The steps I went through were: Create Library Run this command - EXEC dbo.sp_configure ‘clr enabled’,1 RECONFIGURE
I am trying to deploy an CLR TVF (table value function). In the code I am using JavaScriptSerializer to parse some JSON string, so I reference the System.Web.Extensions dll and my problems start there
I have a clr project R with a User defined type called RN in it, RN looks like [Serializable] [Microsoft.SqlServer.Server.SqlUserDefinedType(Format.UserDefined)]