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 |
|
deven
Starting Member
3 Posts |
 Posted - 2001-12-26 : 02:39:38
|
| while import a database from Oracle to SQL Server, how the system table particularly DUAL in Oracle will be stored in SQL Server.DevenEdited by - deven on 12/26/2001 02:41:48 |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2001-12-26 : 07:16:40
|
| There is no Dual equivalent in SQL Server. Most of the Dual functions can be handled in other ways in SQL.I'm not an expert in Oracle so if anyone else can comment, please do. |
 |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2001-12-26 : 07:55:22
|
| Yeah , therez no dual in Sql server. Actually u dont need one in Sql Serverto give a example.In Oracle:select sysdate from dual will give you the current dateIn Sql Server :Select getdate()will give you the current date.So, its not compulsory to have a from clause in Sql Server for queries retrieving information without actually quering a table.if you look at Dual in Oracle , it has one column and one record. its a dummy table. its basic use is it fills those kind of queries where a table is not required. you can easily run this too with correct resultselect sysdate from empbut it will return the sysdate as number of times as there are records in emp. i repeat, Sql Server simplifies these kind of queries by eliminationg the necessity of having a from clause .HTH-------------------------Graz's Baby is my Master:) |
|
|
|
|
|
|
Import database from Oracle to Sql Server