No announcements
Found 2055053 threads
-
1 VotesOracle to SQl Server Function
This was a solution to concatenate rows into one record (produce CSV) in the SQL Server 2000 (pre XML path solution).Answered | 24 Replies | 8307 Views | Created by JGIS - Friday, October 23, 2009 4:39 PM | Last reply by Naomi N - Wednesday, December 30, 2009 6:10 PM
-
3 Votes
Oracle Translate function equivalent in SQL Server
I of course no nothing about Oracle, so I used the following as a ...Answered | 2 Replies | 16454 Views | Created by kumarsv - Friday, May 5, 2006 7:59 AM | Last reply by Louis Davidson - Monday, May 8, 2006 2:59 AM -
0 Votes
Conversion of Oracle function into SQL Server 2008
I will however, make a few remarks: * An SQL Server function must not change database state, why you cannot have an INSERT into ...Answered | 4 Replies | 1640 Views | Created by knra - Sunday, November 10, 2013 4:24 PM | Last reply by Gert-Jan Strik - Sunday, November 10, 2013 11:21 PM -
0 Votes
Over() function in SQL server is same as Oracle?
SQL 2008 GRAND SLAM New Book: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server ...Answered | 5 Replies | 2499 Views | Created by Jumpingboy - Friday, December 28, 2012 7:34 PM | Last reply by Kalman Toth - Friday, December 28, 2012 9:06 PM -
3 Votes
Oracle statement to SQL Server
Hi All, I have a oracle statement, I need same logic in SQL Server.Answered | 6 Replies | 1644 Views | Created by sql9 - Wednesday, April 23, 2014 3:45 PM | Last reply by Elvis Long - Monday, April 28, 2014 2:40 PM -
0 Votes
What is the equivalent of oracle function NEXT_DAY in sql server
The function DATEPART is non-deterministic!Answered | 5 Replies | 8636 Views | Created by KarunMendu - Friday, February 19, 2016 10:24 PM | Last reply by Patrick Hurst - Wednesday, February 24, 2016 2:34 PM -
0 Votes
SQL Server linked to Oracle
Or is that reserved for SQL Server DBs only?Answered | 3 Replies | 5490 Views | Created by bobk544 - Friday, November 20, 2009 4:00 PM | Last reply by Brian Tkatch - Monday, November 23, 2009 2:42 PM -
0 Votes
Oracle to SQL Server
Hi, Yes by using SSIS Data can be moved to SQL Server, Oracle Client to be installed on the SQL Server to create a connection string in ...Answered | 4 Replies | 1045 Views | Created by collie12 - Tuesday, February 2, 2016 8:33 PM | Last reply by SKB7 - Wednesday, February 3, 2016 9:29 AM -
0 Votes
Oracle Publisher SQL Server Subscriber
http://www.attunity.com/products/attunity-cdc-ssis/oracle-cdc-for-ssis looking for a book on SQL Server 2008 Administration?Answered | 4 Replies | 1324 Views | Created by philliptackett77 - Thursday, December 18, 2014 4:04 PM | Last reply by Hilary Cotter - Thursday, December 18, 2014 7:49 PM -
0 Votes
Implementing LEAD(Oracle) function with SQL Server
The rest is done by DATEADD function.Answered | 7 Replies | 4610 Views | Created by M Mahendra - Thursday, May 13, 2010 11:51 AM | Last reply by M Mahendra - Thursday, May 13, 2010 5:09 PM -
0 Votes
Emulting Oracle packages in SQL Server
There is no such thing as packages in SQL Server (unfortunately).Answered | 1 Replies | 6229 Views | Created by SQLAJ - Monday, January 25, 2010 4:31 PM | Last reply by TiborK - Tuesday, January 26, 2010 1:04 PM -
0 Votes
instr related function in sql server
I suggest you look at this: http://www.sqlines.com/oracle/functionsAnswered | 3 Replies | 1359 Views | Created by ArunaMSBI - Thursday, June 4, 2020 11:39 AM | Last reply by Tom Phillips - Thursday, June 4, 2020 1:41 PM -
1 Votes
migration from oracle to sql server
SQL Server Migration Assistant for Oracle in your case.Answered | 6 Replies | 1663 Views | Created by delaynomore - Tuesday, July 25, 2017 6:55 AM | Last reply by Mohammad Ali Torabi - Wednesday, August 23, 2017 11:31 AM -
0 Votes
Oracle --> SSIS --> SQL Server
NUMBER (5,0) ---> DT_14 --> NUMERIC (5,0) a valid combination from Oracle ---> SSIS ---> SQL Server?Answered | 4 Replies | 1670 Views | Created by etl2016 - Tuesday, October 4, 2016 10:50 AM | Last reply by ArthurZ - Tuesday, October 4, 2016 3:58 PM -
0 Votes
Connecting to Oracle from SQL Server
Linked server might help.Answered | 1 Replies | 2515 Views | Created by PSULionRP - Friday, November 30, 2012 2:39 PM | Last reply by Fedor Pustovachenko - Friday, November 30, 2012 6:45 PM -
0 Votes
Use sql server to connect the oracle
Hi arlsen, Here is a blog: Creating a Linked Server for Oracle in 64bit SQL Server, ...Answered | 8 Replies | 989 Views | Created by arlsen - Friday, March 10, 2017 12:58 AM | Last reply by Teige Gao - Monday, March 13, 2017 7:05 AM -
1 Votes
Fetch data from oracle server to sql server
SSIS Import/Export Wizard is the best choice: http://www.sqlusa.com/bestpractices/ssis-wizard/ Alternative is linked ...Answered | 3 Replies | 2184 Views | Created by Sandy.S - Wednesday, April 30, 2014 5:32 AM | Last reply by Kalman Toth - Sunday, May 4, 2014 10:37 AM -
0 Votes
Data Migration - Oracle database to SQL Server 2016
Is that works for Oracle on Unix env to SQL Server on windows Yes, it works with ...Answered | 5 Replies | 941 Views | Created by ashwan - Friday, September 28, 2018 12:33 PM | Last reply by Olaf Helper - Monday, October 1, 2018 6:02 AM -
1 Votes
Migration from Oracle To SQl Server
I know hardly anything at all about Oracle, SQL Server is my place in life.Answered | 3 Replies | 1584 Views | Created by SubhadipRoy - Sunday, March 30, 2014 6:01 PM | Last reply by Erland Sommarskog - Sunday, March 30, 2014 6:38 PM -
1 Votes
Oracle functions with PowerPivot
I had gone through above link previously, but we need to provide solution to client either by calling functions or executing queries those are used inside ...Answered | 2 Replies | 1192 Views | Created by SS_2011 - Monday, June 23, 2014 3:53 AM | Last reply by SS_2011 - Friday, July 4, 2014 4:35 AM - Items 1 to 20 of 2055053 Next ›
No announcements
