You can find the syntax reference here:

http://www.mssqlcity.com/FAQ/Devel/xp_regread.htm

Jeff is looking to find out what you are trying to use CLR for. If it is just string splitting, unless you are using extremely long strings, that extend well...

While you can do threading in SQLCLR, it is UNSAFE and not recommended. This seems like a job for a SSIS package and a staging table to me. ...

You need to post the .NET code associated with the Exception for us to assist with this. It sounds like a simple syntax error, but I can't tell without...

Jeff,

Perhaps in my attempt to demonstrate an overly simplistic TSQL Example, I made it far to simple. The OP wants to SELECT a value from any column in a...

Consider the following example:

CREATE PROCEDURE uspGetObjectIDFromName

(

@ObjectName sysname,

@OutputValue varchar(1000) output

)

AS

DECLARE @sql nvarchar(max)

SET @sql = 'SELECT @Output=convert(varchar(1000), '+@objectname+')

FROM sys.objects

WHERE name = ''sysfiles1'''

DECLARE @params nvarchar(max)

SET

There are a couple of ways to do this. Just using standard TSQL, you can use XP_REGREAD to read the registry key for the instance root key:

HKLM\Software\Microsoft\Microsoft SQL Server\Instance...

Nope, I am wondering the exact same thing.

It was the...

Muhammad Furqan (7/22/2008)

---

it was just that i was not handling exceptions properly in CLR, like i was doing like

command.ExecuteScalar().toString()

but i was not handling what to do if "command.ExecuteScalar()" doesnt return...

Use nvarchar(max) instead of text.

What version of Oracle and is SQL running on x64 or x86?

It is impossible to really provide a good answer to your question about whether to index the view or not without seeing execution plans and other information. I would...

Enabling CLR doesn't do anything in reality, it just allows CLR to work if it exists in the database. You can create assemblies in SQL even with CLR disabled,...

rbarryyoung (7/20/2008)

---

Please list some of these "many things" that can be done in SQLCLR with External_Access permissions, that is worthwhile in a real-world, practical sense that we couldn't do better...

rbarryyoung (7/20/2008)

---

The problem is that there is virtually nothing worthwhile that you can do in SQLCLR that isn't either unsafe, unsupported, impossible or just better done in T-SQL to begin...