sqlclr Questions
3
Solved
I've built a SQLCLR function in C# that will deserialize JSON and return a table.
The problem I have is getting the correct assemblies within SQL Server 2012.
In order to utilize Newtonsoft's des...
Unsegregated asked 13/1, 2016 at 17:14
2
Solved
It seems I'm running into more woes with 'my most favorite datatype' SqlDecimal.
I'm wondering if this should be considered a bug or not.
When I multiply two small numbers in SQL I get the expecte...
Eggcup asked 30/1, 2017 at 14:28
1
Solved
I want to create SQLCLR based stored procedures for SQL Server. As you know I can build a dll against multiple versions of .NET framework. I can't find a reference that describe which version of SQ...
Melburn asked 13/12, 2016 at 5:14
2
Solved
We are using SSDT tools with Visual Studio 2015 and Target Platform set to SQL Server 2008. We are stuck with this function which is throwing an error and need assistance on what we can do to fix i...
Homothallic asked 9/12, 2016 at 8:2
1
Solved
I wrote some code in C# 6.0 .NET 3.5 CLR assembly with safety level = external_access.
Reduced code:
public static readonly DataTable warnings_table = init_warnings_table();
public static void...
Marenmarena asked 9/12, 2016 at 14:36
1
It is my understanding that the awaitable completes the remaining part of the executing code when they return back from the wait. I am trying to get this to work in an sql clr, and this is not work...
Leotie asked 27/9, 2016 at 23:17
3
Solved
I'm having trouble adding a SQLCLR assembly into a database, but a coworker of mine has no problem. Although we do have different levels of access, we can't figure out why I'm getting the error mes...
Brew asked 31/5, 2011 at 15:59
2
Solved
I want to compress some large table containing historical data that is rarely or not read at all. I have first try to use the build-in compressions (row, page, column stored, column-stored archive)...
Stucker asked 22/1, 2015 at 9:48
2
Solved
I'm using SQL 2012 RC0, and looking for a function that can convert a column that holds first and last names into proper/title case. I've had a look around SO but can't seem to find anything, if th...
Benham asked 7/3, 2012 at 3:22
1
Solved
I am quite new to SQLCLR stored procedures. In my example I have two stored procedures, one without a parameter and one with a input parameter. Both target the same tables.
The one without the par...
Waistcloth asked 4/4, 2016 at 14:47
4
Solved
I applied the SQL Server Data Tools patch to Visual Studio 2012 (Premium) and created a SQL Server CLR user-defined function project in C#:
public partial class UserDefinedFunctions
{
[Microsoft....
Adularia asked 29/10, 2013 at 19:56
7
Solved
When I try to create assembly in SQL 2008 from .Net assembly (.Net 3.5) I am getting the below error, error says that I have to set either of the below properties as true, how can I do that?
The d...
Scurf asked 26/3, 2013 at 14:11
2
Solved
I have a SQL CLR dll I want to deploy, but have found you can embed the byte stream/varbinary_literal/ varbinary_expression/assembly bits into a text file to get around the messy hassle of packagin...
Batho asked 21/5, 2010 at 20:27
3
Solved
The tSQLt test framework requires to set TRUSTWORTHY ON for the database, and to enable SQL CLR for the server.
Why are these required? Is it possible to achieve the same/similar functionality wit...
Dioptrics asked 10/5, 2012 at 8:29
1
Solved
I have a written a number of SQL CLR functions (UDF) that reads data from an external DB2 database hosted on an IBM iSeries (using IBM DB2 .Net Provider). So that the function has the necessary per...
Flip asked 23/2, 2016 at 12:9
1
Solved
A little context first, then the specific questions will follow.
I am trying to generate sequential GUIDs for use as primary ids in a SQL Server 2008 R2 table. Previously, these were being generat...
Bailiwick asked 11/2, 2016 at 16:26
2
Solved
I have written the following SQL CLR function in order to hash string values larger then 8000 bytes (the limit of input value of the T-SQL built-it HASHBYTES function):
[SqlFunction(DataAccess = ...
3
I'm using the following command to try and enable the CLR on a SQL Server 2008 instance
EXEC sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO
But I still get the following error
Execution of ...
Secunderabad asked 2/2, 2016 at 13:26
5
Solved
Are there any multithreaded caching mechanisms that will work in a SQL CLR function without requiring the assembly to be registered as "unsafe"?
As also described in this post, simply using a lock...
Termless asked 30/4, 2013 at 15:28
1
Solved
I have been struggling with a SQL Server CLR stored procedure.
Background:
We are using SQL Server 2014 and a CLR stored procedure has been implemented which calls a customer's web service.
The ...
Suksukarno asked 31/1, 2016 at 17:0
2
Solved
Looking for Enabling CLR Integration I found this document: http://msdn.microsoft.com/en-us/library/ms131048.aspx that said to use the following code for setting to 1 the "crl enabled" variable.
s...
Anissa asked 9/11, 2012 at 11:15
5
Solved
I've already dived into SQL clr programming. Unfortunately my first attempt is troubled.
My C# assembly code is just so:
enter code here
public partial class FirstCLRRoutines
{
public static int ...
Tevet asked 1/11, 2011 at 14:34
3
Solved
I am using the below code for CLR stored procedure creation. While I am creating the assembly. it shows the below issue. My target framework is 4.0. sql server is 2008 r2
SQL code:
create assemb...
Sarnen asked 31/7, 2014 at 6:3
2
Solved
I have a SQL Server 2012 stored procedure that returns a table. I have to modify that SP to add an additional value to the returned table. Unfortunately, that added value comes from a call to a web...
Kinser asked 30/9, 2015 at 21:29
2
Solved
I know that I can define default values for CLR procedures when creating the procedure in the database, like this:
CREATE PROCEDURE [dbo].[ShredXml] (
@InputXml [xml],
@AttributeElementHandling...
Donnetta asked 21/6, 2011 at 6:4
© 2022 - 2024 — McMap. All rights reserved.