Sql Server 2008 types in Sql CLR stored procedure
- by BadEnglish
I have Table-valued parameters in SQL Server 2008 e.g.
CREATE TYPE UserType AS TABLE
(
UserID int,
UserName nvarchar(100),
UserPassword nvarchar(100)
)
Can i use this type somehow in my Sql CLR stored procedure? for example as input parameter ??
[SqlProcedure]
public static void SomeFunction(/* what type should be here ?? */)
{
}
Will be appreciate even for attention, let alone for any help !
