Top "User-defined-types" questions

User-Defined Type (UDT) is a type that customize by user.

How to do ForEach on user defined table type in SQL Server stored procedure?

XX PROCEDURE [dbo].[XXX] @X dbo.IntType readonly AS BEGIN SET NOCOUNT ON; // how can I foreach(@X) here and …

sql-server stored-procedures azure-sql-database user-defined-functions user-defined-types
How to pass udtt into a stored procedure in SQL Server Management Studio

I have a SP prc_Foo_Delete which has the following signature: ALTER PROCEDURE [prc_Foo_Delete] @fooIds [int_udtt] …

sql-server stored-procedures user-defined-types
Only public user defined types defined in public object modules can be used as parameters in VBA

I have a public UDT, and wanted to use it as parameter in a Public Sub in a normal Module. …

vba excel user-defined-types
c++ convert class to boolean

With all of the fundamental types of C++, one can simply query: if(varname) and the type is converted to …

c++ boolean user-defined-types
Passing a user-defined table type between SQL Server database

I have a user-defined table type in one database in SQL Server (let's call this DB1). The definition for my …

sql-server sql-server-2008 user-defined-types
How to specify a List<MyCustomType> as a "Return Type" for a UML Interface Property

In my Visio 2007 UML document I am unable to figure out how I can add an operation to an Interface …

visio generic-list user-defined-types
Performance of User-Defined Table Types in SQL Server

We have been using User-Defined Table Types to pass a list of integers to our stored procedures. We then use …

sql-server tsql sql-server-2008-r2 user-defined-types table-valued-parameters
Unable to Modify User-Defined Table Type

I have a SQL User-Defined Table Type. It used in many stored procedures.Now i need to change a column …

sql sql-server stored-procedures sql-server-2012 user-defined-types
How do you return a user defined type from a WCF service?

I have a WCF service hosted in IIS. The intention is for clients to make a call and receive a …

.net wcf web-services user-defined-types
how to fetch cursor values into an object

I want to fetch values from a cursor and store them in an object.... I tried doing the same with …

oracle plsql user-defined-types object-type