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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-05-06 : 08:07:00
|
| dhrubo writes "Hello All, In oracle databases we can create a database record type say ADDRESS -------------> name varchar2(100) -------------> phone_no varchar2(20) -------------> zip number(15) -------------> street varchar2(100)etc as the fields. Is it possible for me to do the same in SQL SERVER 2000 i.e tocreate ORACLE like composite record datatype ??? If yes then how ??RegardsDhrubo" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-05-06 : 08:09:27
|
| You can create user-defined datatypes in SQL Server, but they can only have one base type and can't contain multiple types/properties. You don't really need it anyway, just create an Address table and add those four columns to it. It will function the same way. |
 |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-05-06 : 20:03:05
|
A fine example of functionality bloatation  |
|
|
|
|
|
|
composite data type