@Martin: I know, but the DBMS is relevant quite often; it's a good habit to get into. SQL Server uses '+' as a string concatenation operator, for instance. (Of course, the better solution would have been for the poster to simply run the query without the count() to see what it did in the first place instead of posting here.) –

Jul 9, 2012 · @ConradFrix - True, and I certainly don't mean to imply that any database implements the entire SQL standard set of functions (someone will have to explain why it isn't easier to implement POSITION and SUBSTRING rather than documenting that they don't exist, for example, and if that was the question, I'd happily call out Oracle).

Adding to Craig's comment above - I use Linked servers to refresh a few tables in an Oracle database from SQL Server. You can also pull data to SQL Server using OPENQUERY. INSERT INTO dbo.SQLTable1 SELECT * FROM OPENQUERY(ORALINKEDSERV, 'SELECT * FROM OracleTable1') A couple of links that will help you set up linked server here and here

Sep 1, 2011 · SELECT * FROM OPENQUERY(<linked server name>, '{CALL <oracle sp>}') What I've seen (I have not tried this myself) is that you can also use OPENQUERY to call an Oracle function which can then call the stored procedure, or you can turn the stored procedure into a function. Your connection from SQL Server would then look something like this:

Oct 9, 2014 · <> is Standard SQL-92; != is its equivalent. Both evaluate for values, which NULL is not -- NULL is a placeholder to say there is the absence of a value. Which is why you can only use IS NULL/IS NOT NULL as predicates for such situations. This behavior is not specific to SQL Server. All standards-compliant SQL dialects work the same way.

Feb 7, 2015 · In SQL Server, there is no dual. You can simply skip the FROM clause: SELECT pCliente, 'xxx.x.xxx.xx' AS Servidor, xxxx AS Extension, xxxx AS Grupo, xxxx AS Puerto However, if your problem is that you transferred some code from Oracle which references dual, you may create a dummy table:

Dec 20, 2013 · Before creating a database link, you'll have to setup a Heterogeneous gateway to connect to the SQL Server. General steps include: Install Oracle ODBC drivers on the server that will access the remote SQL Server database using the database link. Setup the ODBC connection on the local Oracle database using the Windows ODBC Data Source Administrator

Apr 5, 2011 · MINUS is a SQL set operation that selects elements from the first table and then removes rows that are also returned by the second SELECT statement in Oracle. And in SQL Server, we can use EXCEPT to do same thing. While migrating my project from oracle to SQL Server, I noticed a difference.

Dec 8, 2014 · I am trying to connect to Oracle db using pyodbc, getting errors. The examples include ms sql server driver: in my /etc/unixODBC/odbc.ini, I have this entry: [test_con] Driver=Oracle Description=...

Jan 26, 2015 · SQL is a declarative language to operate on relational data: tables, views, resultsets and similar. It's more or less standardized, and used by almost all relational database management systems: SQL Server, Oracle, MySQL, PostgreSQL, DB2, Informix, etc.