Recent content by inhisglory

which better using UPDLOCK or ROWLOCK for insert record in sqlsever 7. How about delete and update ? Thank you for helping me Inhisglory

Can anybody told me which best query hint i must use for insert, update and delete thank you for helping me Inhisglory

unfortunely no :(

thank you MaxZak, that right there are some bad sector in my harddisk. The problem now is after I reallocate the bad sector, the error is "bad page ID"

Hi all, I want to attach database into sqlserver 7 through Query Analyser using sp_attach_db. There is an error occured : "I/O Error 23 (Data Error (Cyclic Redundancy Check)) detected during read of BUF pointer 0x11f1ed40, page ptr=0x1fd5a000, pageid=(0x3:0x9688), dbid=13, status=0x801...

Hi, can any one tell me how to speed up for selecting from a table have 530000 row/record ? Thank you for any reply. Yahya

Hello all... I want to get the last transaction on a date before. Example : want to get the last trans (row) before Juli,1st 2001 Thank you Yahya

Hi, I want to save my select result into a dynamic name table. Any one can help me... Thank You Yahya

Thanks Steven, its work

I have table 1 with this contains : CUST TYPE VALUE =============================== 001 INV 100 002 INV 200 003 CN 400 004 CN 300 005 INV 500 I want to change table 1 to...