Sql Server 2008 types in Sql CLR stored procedure
Posted
by
BadEnglish
on Stack Overflow
See other posts from Stack Overflow
or by BadEnglish
Published on 2010-12-30T08:49:22Z
Indexed on
2010/12/30
8:55 UTC
Read the original article
Hit count: 267
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 !
© Stack Overflow or respective owner
