Top "User-defined-types" questions

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

How cool are User Defined Data Types in SQL Server?

Are User Defined Data Types in SQL Server something that a intermediate SQL user should know and use? What are …

sql sql-server user-defined-types
How to check if an array contains a particular string?

I have an array of strings. I want to check if a particular string is present in the array. DECLARE …

oracle plsql contains user-defined-types
SQL Server 2008 - How do i return a User-Defined Table Type from a Table-Valued Function?

Here's my user-defined table type... CREATE TYPE [dbo].[FooType] AS TABLE( [Bar] [INT], ) This is what ive had to do …

sql-server tsql sql-server-2008 user-defined-functions user-defined-types
User-Defined Table Type insertion sometimes causing conversion error

I have a User-Defined Table Type called tvpInsertedColumns: CREATE TYPE [Audit].[tvpInsertedColumns] AS TABLE( [ColumnName] [varchar](max) NOT NULL, [NewValue] […

sql tsql sql-server-2008 user-defined-types
How to alter user defined table types

I have already tried to alter the user defined table types but it is not working with alter commend. alter …

sql-server alter user-defined-types
Set a type in VBA to nothing?

I have defined a variable with an own type, say Dim point As DataPoint Public Type DataPoint list as Collection …

vba object variables user-defined-types
How to get information about a User-Defined Type?

In simplicity, PL/SQL generally follow the following: DECLARE Variable declaration BEGIN Program Execution EXCEPTION Exception handling END; I am …

oracle variables plsql user-defined-types
Pass A User-Defined Table to a Stored Procedure

I have a User Defined Table that I am passing into a stored procedure from within a stored procedure. DECLARE @…

sql-server stored-procedures sql-server-2008-r2 user-defined-types
What makes a user-defined class unhashable?

The docs say that a class is hashable as long as it defines __hash__ method and __eq__ method. However: class …

python class python-3.x user-defined-types hashable
Table type parameter in a stored procedure cause operand type clash error

I want to give an array of identifiers as argument to a stored procedure. The stored procedure looks like : ALTER …

sql-server-2008 stored-procedures user-defined-types