Sorry ,  i am getting the above words in the 'cmd' column.

Antares,

5. I have dropped a table from the database ,but ,when you execute sp_help, it shows you the table. what is the reason ?

I realized the problem, reason is transaction is not...

No i dont want to use DTS import/export wizard. Because the same script will be called from .net.

So I need a pure sql script which will take all the records...

Let us assume we have 25 master tables without any relationship.

 in this case i dont want to use DTS package.

I want to execute a script which will insert all the...

Thanks Experts !

Regards

Karthik

Thanks Experts !

Thanks Matt.

Because , the same sql query will be execute from both the sybase and sqlserver2000 server. That's why i am asking pure sql code (without using any specific sqlserver related functions).

Regards

Karthik

Hi Ken,

I am getting only 'NULL' value in the Value Column.

Output :

Col              Value                                                

---------------- -----------------------------------------------------

ParAmt      NULL

DenomQty  NULL

CINbr        NULL

HNbr         NULL

(4 row(s) affected)

Nelod, Thanks for your answer.

Is the NEWID() function used with ORDERBY clause only ? Can you explain me the reason for using ORDERBY in NEWID() Function ?

*Karthik

Neold,

is it necessary to give nolock ? or shall i give table name only ?

will NEWID() affect performance ? if the table has lot of records.

Here i have one basic question...

How many magnitudes are there ? 6 is the maximum value or anything else ?

What is mean by 1 ,2 or 6 order magnitude ? Really i dont know about it.Please explain me and give some real time example.

Is there any way to avoid cursor...

Hi Phill,

Regarding #3, I am using the below query to copy sybase data to sqlserver.This table contain 750,000 records.It is taking 1/2 hrs to complete its execution.

select CompanyInstitNbr,ProjectId,TrancheNbr,ParticInstitNbr,TransNbr,AcctNbr,SubAcctNbr,SubAcctCode,DeptCode,DivCode,CurrencyCode,ueDate,PostingDate,convert(varchar(255),AcctEntryAt)AcctEntryAt,convert(varchar(255),AcctEntryUsd)AcctEntryUsd,AcctEntryQty,DatetimeStamp,UserId

from icase.dbo.AcctEntry

Thanks and...

Hi Phill,

1. Any oledb provider for sybase 12.5.3 available in market ? I have searched in many websites,but i am not able to find out it.

2. shall we change any sqlserver...