I need to convert Oracle SQL SPs and functions to SQL 2005. Table and columns names do match. Is there any tool which will 'convert' Oracle script yntax to to SQL 2005 syntax?
I can't install it on the server where DB is residing. I am looking for a standalone tool - pass input as Oracle Script and the tool spits out SQL 2005 syntax?
Any one know if such a tool is available or I need to do manual work?
Thanks.
iitt2007
Last Activity: May 28 '08, 07:58 PM
Joined: Feb 28 '08
Location:
-
Export Excel to SQL 2005 table
Scenario :
SQL table has 2 columns SQ1, SQ2
Excel sheet has three columns : EX1, EX2, EX3
SQ1 matches with EX2
SQ2 matches with EX3
I would like to insert the rows where EX1='X'. EX1 is the left most column in th Excel sheet.
Here's what I am trying. Could you suggest any changes/suggestions?
-- Link server logic
IF EXISTS (SELECT srv.name FROM sys.servers... -
Hi CK,
Any idea? In Oracle, these were used for formatting the output (pooled to txt file).
Laternatively, I am lokking for how to format the values when dataset is pooled to a txt file.
Thanks in adavance. -
capturing object not found in SP
For the following SP, is table aaa doesn't exist, error is not caught. Any help is appreciated. Thanks.
I would still expect ''Unexpected error occurred!' if table 'aa' doesn't exist.
I am using 2005.
DECLARE @intErrorCode INT
BEGIN TRAN
UPDATE aa
SET DRE_EMAIL_ADDR = 'ss'
WHERE DRE_EMAIL_ADDR = 'mm'
SELECT @intErrorCode = @@ERROR
IF (@intErrorCode... -
Nice article. Thanks CK.Leave a comment:
-
SELECT @error_message vs SET @error_message
In my SP, I am using SELECT @error_message= 'string' . My collegue asked me to use SET@error_messa ge= 'string' ,
I would like to know the differences for using SELECT vs SET.
Here's the snippet of SP :
set ANSI_NULLS ON
set QUOTED_IDENTIFI ER ON
GO
ALTER PROCEDURE [dbo].[spd_name_of_sp]
(
@fileID Integer
)
as
BEGIN... -
resetting Identity column values
I have a table :
drop table REPORTING_FILES
Create table REPORTING_FILES
(
DRF_FILE_ID INTEGER IDENTITY (1,1) PRIMARY KEY,
DRF_FILE_NAME VARCHAR(50),
DRF_SUBJECT_LIN E varchar(50)
)
With entries :
1 abc abc subject
2 xyz xyz subject
3 mnq mnq subject
4 yyz yyz subject
When I delete DRF_FILE_ID=2 , I have entry like
1 abc abc... -
iitt2007 started a topic Copying XLS (local) directly to SQL (remote) Table without Link srver and BCPin SQL ServerCopying XLS (local) directly to SQL (remote) Table without Link srver and BCP
I have a XLS file on local machine and would like to copy all the columns to a new SQL table on the 'remote' (not local sql server) using SQL scripts.
I tried following :
select * into TEMP_PLAN_CODE FROM OPENROWSET('Mic rosoft.Jet.OLED B.4.0',
'Excel 10.0;Database=D :\Placodes.xls; HDR=YES',
'SELECT * FROM [Sheet1$]')
but it's giving me an error :
Msg 7415, Level 16, State 1, Line 1
... -
capture XP Donload complete Event
Is there any way to capture "download complete event" on XP?
This is typically when user tries to download a file from a server and is notified when the download is complete.
I am looking to capture this in .NET application.
Any thoughts ? Pointers?
I have posted the same question in Windows forum as well.
Thanks. -
Capture Download complete Event - XP
Is there any way to capture "download complete event" on XP?
This is typically when user tries to download a file from a server and is notified when the download is complete.
I am looking to capture this in .NET application.
Any thoughts ? Pointers?
Thanks. -
I am trying to convert Oracle script to SQL Server. I think those are the environment variables.....Leave a comment:
-
equivalent of SET NEWPAGE NONE in SQL server 2005
Are there any equivalent of following in SQL server 2005?
SET NEWPAGE NONE;
SET SPACE 0;
SET LINESIZE 181;
SET PAGESIZE 0;
SET ECHO OFF;
SET FEEDBACK OFF;
SET HEADING OFF;
SET UNDERLINE OFF;
SET FLUSH OFF;
SET MARKUP HTML OFF;
COLUMN AGT_CD NOPRINT;
COLUMN PROC_DT NOPRINT;
SPOOL OFF;
SET COLSEP ','; -
converting oracle script to SQL server 2005 script
Hi I am newbie. I need to translate the following Oracle script to SQL Server 2005 script.
I will appreciate your help and feedback.
Thanks a lot in advance.
-----------------------------------------------------------------------------------------------------------
test_reporting/here4fun@test_P ROD
SET NEWPAGE NONE;
SET SPACE 0;
SET LINESIZE 181;
SET PAGESIZE 0;
SET ECHO...
No activity results to display
Leave a comment: