Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sara19_s
Starting Member
3 Posts |
 Posted - 2010-10-07 : 15:37:36
|
| HiI using this store procedure in sql server 2008 :create procedure sss@id uniqueidentifierasselect * from tableX where IdTableX = @id...in my program where i send parameter(id) to sql , what must i do?(i used this code in c#:...string.format("'{0}'",id)... but i receive this error{id operand type clash,bit is incompatible with uniqueidentifier}what do i for solve this problem?(i use visual studio 2010 and c# and sql server 2008)thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-10-07 : 15:45:11
|
Use GUID as datatype.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
|
|
|
uniqueidentifier field