It is really simple to do in Visual Studio, and the steps in 2008 are the same as 2005. When you create the database project, it will ask for...

The problem is that you have @phone declared as a char(20), which means it is going to have trailing spaces for a phone number. Either explicitly cast/convert it to...

Hmm, I have to go play with your code now Jeff. I am not surprised that you once again replaced a loop with a Tally/Numbers table. I...

That is correct, and you can easily modify the code to accept another input and return a scalar value back for a specific part only.

You can do this with TSQL very easily with a split function. You can find one on the following link:

http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=StringArrayInput&referringTitle=Home

declare @namestring varchar(1000), @thirdvalue varchar(1000)

set @namestring = 'Smith, John'

SELECT @thirdvalue...

For this particular question, here is the example code.

DECLARE @InstanceName varchar(100),

@InstanceLocation varchar(100),

@InstancePath varchar(100)

SELECT @InstanceName = convert(varchar, ServerProperty('InstanceName'))

EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',

@key='Software\Microsoft\Microsoft SQL Server\Instance Names\SQL',

@value_name=@InstanceName,

@value=@InstanceLocation OUTPUT

SELECT...

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 @Params = N'@Output varchar(1000) OUTPUT'

EXEC sp_executesql @sql, @Params,

@Output...

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...