We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [user-defined-type]

User-Defined Types (UDTs) are custom datatypes in Microsoft SQL Server 2005 or newer. UDTs are one of the five SQLCLR object types and rely on the .NET Framework. They are most commonly written in C# or VB.NET.

Filter by
Sorted by
Tagged with
-1
votes
1answer
19 views

Unable to declare user-defined variable in MySQL

I'm creating procedure called min_max to find minimum and maximum for every column in a table. But I'm encountering an error for declaring the variable. See below: DELIMITER // DROP PROCEDURE IF ...
0
votes
1answer
28 views

How to insert nested UDT types

I have all these case classes :- case class Role(id:UUID, roleName:String, description:Option[String], isVisible:Boolean, isDefault:...
0
votes
1answer
44 views

Are user defined types (UDTs) available in an Azure SQL database managed instance?

Is it possible to create user defined types and user defined table types in an Azure SQL database managed instance?
2
votes
1answer
85 views

Can't use CAST, Convert with UDT in Sql Server 2014 [closed]

My tables consist of many decimal columns with different precision. I wanted to standardize the usage of precision by creating several UDTs with predefined precision and use them as column type ...
3
votes
3answers
321 views

How do I create a bounded range type in the SQL Server?

I want to create a bible verse table that has one field representing a range of bible verses. Currently I represent this range as pair of values (VerseBegId and VerseEndId). I want something like ...
1
vote
0answers
32 views

PostgreSQL- user-defined types: note sure what internallength/alignment is for linked list type

I'm currently trying to implement at user-defined data type in Postgres in the form of a linked list with each node holding an int and a pointer to the next node, here are my input functions: // ...
6
votes
2answers
462 views

Determine if user-defined type is ENUM

Is there a way to determine whether or not a user-defined type in PostgreSQL is an ENUM? Essentially we have the following: CREATE TYPE foo AS ENUM ( 'Sometimes', 'You', 'Wanna', 'Go', '...
1
vote
1answer
157 views

Need an efficient routine to pass object name, with or without “[” and “]” brackets, to get ObjectID

Someone in their wisdom created a table called user: select schema_name(schema_id) ,* from sys.tables where type = 'U' and name like '%user%' select top 100 * from usr.user Msg 156, Level 15, ...
3
votes
1answer
221 views

UPDATE STATISTICS and User-Defined Types (UDT) from Assemblies

I have a problem with UPDATE STATISTICS where the column is a user-defined type (UDT) from an assembly. Step by step: Assembly: CREATE ASSEMBLY [UDT.TParams] FROM 0x4D...(stripped) WITH ...
2
votes
2answers
166 views

SQLCLR User-Defined Type (UDT) SCH-M blocking

I’m hoping someone can provide some guidance on a problem I’m having with schema locking on C# SQLCLR UDT’s. I’ve been on the Internet for an extended period of time researching my problem without ...
0
votes
1answer
192 views

User defined data types causing implicit conversions

user defined datatypes, i'm looking at some execution plans and seeing implicit conversions happening in the background when a var is declared of type user defined data type and pulling a value into ...
8
votes
1answer
934 views

Understanding MS SQL Server Date Types

Consider the following: declare @dt datetime, @dt2 datetime2, @d date set @dt = '2013-01-01' set @dt2 = '2013-01-01' set @d = '2013-01-01' select convert(varbinary, @dt) as dt, convert(...