Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > quey conversion from oracle to sqlserver?

Reply
Thread Tools

quey conversion from oracle to sqlserver?

 
 
ravi
Guest
Posts: n/a
 
      04-19-2008
hi friends,
The below given query is work on oracle.Help me out write same query
on sqlserve i want the same resule.
select * from (select trunc(sysdate) + level from dual
2 connect by level <= 10);

TRUNC(SYS
---------
28-OCT-06
29-OCT-06
30-OCT-06
31-OCT-06
01-NOV-06
02-NOV-06
03-NOV-06
04-NOV-06
05-NOV-06
06-NOV-06

10 rows selected.
 
Reply With Quote
 
 
 
 
Lloyd Sheen
Guest
Posts: n/a
 
      04-19-2008

"ravi" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> hi friends,
> The below given query is work on oracle.Help me out write same query
> on sqlserve i want the same resule.
> select * from (select trunc(sysdate) + level from dual
> 2 connect by level <= 10);
>
> TRUNC(SYS
> ---------
> 28-OCT-06
> 29-OCT-06
> 30-OCT-06
> 31-OCT-06
> 01-NOV-06
> 02-NOV-06
> 03-NOV-06
> 04-NOV-06
> 05-NOV-06
> 06-NOV-06
>
> 10 rows selected.


Sql Server does not have the "connect" functionality. Perhaps you could
explain what you are attempting to accomplish.

LS

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Timeout Troubles when I execute a sql quey. Don Juan ASP .Net 3 06-24-2008 05:02 PM
quey conversion from oracle to sqlserver? ravi ASP .Net 1 04-19-2008 10:44 PM
install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:The specified procedure could not be found at C:/Perl/lib/DynaLoader.pm line 230. Feyruz Perl Misc 4 10-14-2005 06:47 PM
Exception thrown while accessing Oracle through oracle client =?Utf-8?B?TmVv?= ASP .Net 2 07-12-2005 06:59 PM
Oracle adapter don't work with Oracle 10.1.0.2 v. Client vaidas gudas ASP .Net 1 10-11-2004 01:11 PM



Advertisments