Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ckevin
  • Content: Threads
  • Order by date
  1. ckevin

    Can not access web site by using External IP

    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...
  2. ckevin

    Don't know how to create simple trigger

    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...
  3. ckevin

    Distinct problem

    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...
  4. ckevin

    How to separate the string?

    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...

Part and Inventory Search

Back
Top