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 |
|
praveensql
Starting Member
1 Post |
 Posted - 2006-12-22 : 03:01:47
|
| Hi,I've to convert Oracle Databae to Sql Server. Now I'm fasing problem while creating object type in sql server.ex:sql query"create type student as object ( name varchar2 ( 12) , no number ( 5))" is working fine in Oracle where 'student' can be used in any table as datatype, but its not working in sqlserver. Please can you help me how to create object type in sql server.Thanks & Regards,Praveen. |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2006-12-22 : 06:41:56
|
| http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm[Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
 |
|
|
|
|
|
Create type dtname as object