SQL Sever, NewID ()

[mr.Hyde]

Hi,
I am working with mscrm database. the Accounts has UniqueIdentifierID,
so I am trying to use as parameter value in sqlcommand "NewId();", it doesnt
works becouse,
ExecuteNonQuery pass my parameter as "NewId();" - with quotas. How I can
remove quotas from this command?

Regards
Hyde

 

[Jester98x]

Hi,
I am working with mscrm database. the Accounts has UniqueIdentifierID,
so I am trying to use as parameter value in sqlcommand "NewId();", it doesnt
works becouse,
ExecuteNonQuery pass my parameter as "NewId();" - with quotas. How I can
remove quotas from this command?

Regards
Hyde

mr.Hyde,

Could you provide a snippet of code for us to look at? Without seeing
how you are coding this it's not easy to suggest a solution.

Cheers,
Steve

 

[bruce barker \(sqlwork.com\)]

you can't because sqlserver doesn't allow expressions or fuction as
parameters. newid() is just a guid, so you can let the clr do it. define the
paramter as a UniqueIdentifier, and set its value to Guid.NewGuid()


-- bruce (sqlwork.com)