Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Creating abstract Datatypes in sql server 2005

Author  Topic 

Badsha
Starting Member

2 Posts

Posted - 2008-03-14 : 23:39:50
In oracle we create abstract datatypes using the command
CREATE TYPE address as object
(Street varchar2(50),
cuty varchar2(25));

Can this be done in SQL SERVER 2005. I am new to SQL SERVER 2005. Please help me out giving out the proper syntax alongwith an example.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-14 : 23:56:15
Sql2k5 uses 'create type' too, check books online for details.
Go to Top of Page
   

- Advertisement -