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 Wanet Telecoms Ltd 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: ironvid
  • Content: Threads
  • Order by date
  1. ironvid

    update muiltple columns

    Hi At the moment I update a single column with the following query: update example_Table set finished to ='yes' where ( box='123') which works fine I now want to be able to update 3 columns in my table at the same time without having to do 3 querys so i want to beable to update finished...
  2. ironvid

    newbie urgent help needed!

    help Some idot change the datatype of one of my columns in a table. the result is that it has lost all information after 50 charcters. I have changed the column properties back but is there any way to regain the informaion i lost no backup Is there anything i can do with the transaction log
  3. ironvid

    urgent help need anyone!!!!!

    help Some idot change the datatype of one of my columns in a table. the result is that it has lost all information after 50 charcters. I have changed the column properties back but is there any way to regain the informaion i lost Is there anything i can do with the transaction log
  4. ironvid

    newbie table design

    If anyone can help with my ms sql 2000 I have this question:- I am designing two tables : Batch Documnets In both tables i have two fields called "page" and "name" all the names in the name field are unique How can I design the page field in the batch table to be...
  5. ironvid

    If anyone can help with my ms sql 2

    If anyone can help with my ms sql 2000 I have this question:- I am designing two tables : Batch Documnets In both tables i have two fields called "page" and "name" all the names in the name field are unique How can I design the page field in the batch table to be...
  6. ironvid

    Another Newbie Auto Question

    I am using MS SQL 2000 I have A column which contains a unique auto number 1 2 3 4 and so on How can I format it so they read: CDI-1 CDI-2 CDI-3 CDI-4 and so on The data type for the column is set to 'int' and at present it says the length of the field is 4 but I need it to go into the...
  7. ironvid

    Newbie Auto Date Column

    I need to add a column to automaticly add the date that the record was created. I am a Complete begineer to sql so the more detail the better,I am using SQL 2000 thanks for any help regards....stephen

Part and Inventory Search

Back
Top