Recent content by ckevin

Oh, I see. Thank you very much.

Dear All, I have a little problem of access my website. My setup as follows: I have one IIS server (192.168.0.100) connected to LAN, and I have a record to map "ABC" to 192.168.0.100 at the internal DNS Server already, so every machines on LAN can access the site by typing "http://ABC" or...

Thank you very much, It works

Hi all, I am a new guy for MS SQL server, and I have a question on how to create a trigger. I have one table PO, there are 4 columns: rowid, creater, modifier and PO_detail What I want to do is to check out all the modification did by user "ELLEN" during last week. (12/8 - 12/12). Of...

All PO_itemnumber should be shown for each combination of PO_number and PO_customer Thank you again

Hi everybody, I have a table PO, has the field PO_number, PO_customer and PO_itemnumber What I want to do is to list out all the 3 columns of information, by using distinct on PO_number and PO_customer I find I can show out PO_number and PO_customer information by using this query: select...

Thanks, it is working, thank you

Hi all, I have a problem on formatting my result. String variable named "descripation" is inserted into MS-SQL by using textarea field of form, in multiple lines, and datatype is "varchar" . I get this string from MS-SQL server by this simple SQL query: DBConn.Open...