Any Insight on CREATE TYPE in management studio?

Hello, I am trying to create a data type trinary. acceptable values are -1, 0, 1. I found the CREATE TYPE code in the help menu, but cannot find a good example to help me. I am stuck at contraints. I know I need a CHECK constraint but the help makes it seem like I need to make a column contraint and I'm not sure how I implement that into the CREATE TYPE script!? any help would be greatly appreciated.

Aug 17 '10 #1

Subscribe Post Reply

✓ answered by ck9663

Read the link...

Or just add it as tinyint and create a check constraint that the only valid values are >= -1 and <= 1. Here's the link on creating constraint.

Good Luck!!!

~~ CK

1600

ck9663

2,878

Expert 2GB

I'm not sure if there's a trinary data type in SQL Server. You might just want to create a user-defined data type. Here, read this...

Good Luck!!!

~~ CK

Aug 17 '10 #2

bushnellweb

obv there is no trinary data type, I've been explaining that was what i was trying to do is create a user defined data type. I need an example of someone's code that explicitly defined a new data type.

Aug 17 '10 #3

ck9663

2,878

Expert 2GB

Read the link...

Or just add it as tinyint and create a check constraint that the only valid values are >= -1 and <= 1. Here's the link on creating constraint.

Good Luck!!!

~~ CK

Aug 17 '10 #4

Similar topics

No SQL management studio in VS 2005

by: Alucard | last post by:

Hi all. For those who have VS 2005, do you find that there is only a configuration tools but no management tools for SQL server? I can only manage my SQL DB in VS IDE... Actually, can I get...

ASP.NET

Installed VS 2005 professional. I see SQL expres also installed as part of it. But where do i get the Management Studio from?

by: Learner | last post by:

we can download the Management Studio Express for free from MS website. I did the same thing on my personal laptop. But can we develop applications using free downloaded Management Studio and...

ASP.NET

Management Studio Express

by: Maury | last post by:

Hello, I downloaded and installed SQL Server 2005 Express and Management Studio Express CTP, but I noticed that there are several limitation in MSEE: for example I can't create a new database,...

Microsoft SQL Server

SQL Server Management Studio Express CTP

by: Lyle Fairfield | last post by:

SQL Server Management Studio Express CTP is a freely downloadable utility (http://www.microsoft.com/downloads/details.aspx?familyid=82afbd59-57a4- 455e-a2d6-1d4c98d40f6e&displaylang=en) something...

Microsoft Access / VBA

Calling SQL from code has different behaviour than calling it from MS SQL Server Management Studio

by: jeeji | last post by:

HI I am experiencing something funny here where I have two equivalent queries: If I run them through query analyzer, the first runs slower than the second, but if run through C# application, the...

C# / C Sharp

I HATE Management Studio, how about you?

by: jj | last post by:

I really dislike the Management Studio in SQL Server 2005. Having tabs is nice but everything else about it really sucks. What don't you like about it? Maybe someone at M$ will read this and...

Microsoft SQL Server

SQL Server Management Studio can't 'see' the 2005 engine?? But can see 2000 ?!?

by: Jack | last post by:

Hello, I had SQL2000 server running fine on the windows 2003 box. I then installed SQL 2005 Express. They both worked together fine. I then uninstalled SQL 2005 Express and installed SQL 2005...

Microsoft SQL Server

SQL 2005 Management Studio/Express - Any differences

by: John Fox | last post by:

Hi there, We have recently deployed a couple of new SQL 2005 x64 servers in our hosting environment. We have previously used SQL 2000. I need to start rolling out the new client tools so our...

Microsoft SQL Server

SQL 2005 management studio vs SQL 2008 express

by: Alex Pavluck | last post by:

Hi. I am managing a SQL server that is running SQL 2005. I really like the management studio that comes with the full version because I can view tables and easily create relationships and...

Microsoft SQL Server

how to attach database created in sql server management studio to the currnt project

by: praveenb000 | last post by:

Hi frnds, i created a database in sqlserver management studio, and i know how to connect that database to the current project. but problem is when i change to another system(pc), i need to run...

.NET Framework

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp