Viewing 15 posts - 1 through 15 (of 162 total)
Hi folks,
It is heartening to see highly valuable posts still raining on my script published in 2007.
That year I had done my MCITP in SQL Server 2005, dev and admin...
January 27, 2016 at 12:07 am
Migrating Oracle database to SQL Server database should never be a goal. The target is usually business process reengineering in such migration needs. You can not and should not try...
January 27, 2013 at 12:11 am
Very true. Karthik, you need to 'give your question a chance of being answered correctly' ..
Lynn Pettis (1/4/2013)
karthik_ayyagari (1/4/2013)
For the time being can you write a procedure which can...
January 4, 2013 at 1:37 pm
Hi Karthik,
Following is the resolution I see after analyzing your requirement. Status and 'Date and time' of a ticket is required to maintained as follows:
'InProgress': when a ticket is raised...
January 4, 2013 at 4:55 am
Try adding the line number in the flat file itself, let us say at the beginning of each line.
March 29, 2012 at 6:29 pm
Jeff Moden (1/12/2010)
imhemal29 (1/12/2010)
Select Cast(convert(varchar(16),Getdate(),120) as DateTime) as [Date]And
Select convert(varchar(16),Getdate(),120) as [Date]
Check again... op asked for mm/dd/yyyy hh:mm. Above code returns yyyy-mm-dd hh:mi 😉
Could not resist to...
December 13, 2010 at 8:49 am
Thank you very much RTaylor.
For your requirement, simply you do not need to use two of the functions
DateAt1130
DateAt12
Also modify
the below three functions to remove the reference of the above two...
May 5, 2010 at 5:10 pm
Jeff Moden (11/4/2009)
Mazharuddin Ehsan (11/3/2009)
create procedure..
select
sysdate + cdays
....
from oracletable
Thank you
sysdate cannot be fetched from 'oracletable' :w00t:
Sure it can......
November 5, 2009 at 2:16 am
newbie00001 (10/31/2009)
I'm trying to start with a simple conversion.. Here are 2 small blocks from the procedure that I'm converting..
CREATE PROC [dbo].[Wrd](@BID int, @Bidno int, @ref_no decimal(3,0))...
November 4, 2009 at 9:44 am
newbieuser (11/4/2009)
Thanks, Is this function in sql servercast(convert(nvarchar(20), getdate(), 101) as datetime)
equivalent to trunc(sysdate) in Oracle?
Thanks again
Dear,
Let me try to answer you 🙂
Thanks, Is this function in sql server
Which...
November 4, 2009 at 9:22 am
I think the root cause of the problem you are facing is desctibed in the below excerpt
Note If you use the ALTER DATABASE command in SQL Server 2000 to change...
November 4, 2009 at 8:55 am
create procedure..
select
sysdate + cdays
....
from oracletable
Thank you
sysdate cannot be fetched from 'oracletable' :w00t:
You can say select sysdate from dual...
November 3, 2009 at 10:01 pm
I hope you have proper coalition at the object level and the database level in the main SQL Server which is failing to transfer data to Oracle properly.
November 3, 2009 at 4:09 am
I don't know what stored procedures you are using to trnasfer data. I suggest you to use SSIS. Using SSIS, proper code page properties should be used (1256 for Arabic)
November 3, 2009 at 12:20 am
UTF8 CHARACTERSET has known issue with import. I have used AR8MSWIN1256 without problem for Arabic data. You can also try AL16UTF16. The SQL Server coalation you are using is perfect.
November 2, 2009 at 10:30 pm
Viewing 15 posts - 1 through 15 (of 162 total)