wait type is pageiolatch_sh....

Is there any chart to get this depending on the waittype....

or any logic

thanks 🙂

thanks, but am unable to get a separate script of the defaults...the syntax is in the table definition itself, however after a close look I found that the most of...

helloo....plz chk out da attachements.... 🙂

Thank u all 🙂

if am not using sql injection...is this correct

select iCustomerid,sCustomercompname from CustomerMaster C inner join Citymaster Ci

On C.iCityid=Ci.iCityid where...

but what should I do ... Should i open up the format file and check the collation...I don't hv any idea to...

Hey Jeff... Still unable to upload the upload the file....

Code for format file.....

bcp dnbsql..dnb12 format -T -n -f dnb.fmt

Code for Bulk insert

BULK INSERT dnb12

FROM 'E:\smb\dnb.txt'

...

Oops...I did it directly...

Jeff Moden (7/1/2008)

---

Ummm.... Use DTS to import just one of the Excel sheets... the one with the column headers. That will define a table fairly nicely. Then, truncate...

hi...

No, it dint.

I don't have a correct format of...

Hi All,

Can i export MS Excel 2007 file into sql 2000

Regards,

Ahmad

gud one thanks...

thnks man..

Thnks for all the valuable...

ok...so u mean that i can navigate thru the table using a while loop on the identity column...or there is any other way...