Search results for query: *

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

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

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

Does this make more sense ------------------------ Table 1 Name - DOCUMENTS Fields: ID Name -(Type)varchar (length)80 (no Nulls) Page -(Type)text (length)16 (no Nulls) date Date ------------------------ Table 2 Name - Batch Fields: Name -(Type)varchar (length)80 (no Nulls) Page...

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

thanks DickieBird update Batch set Batch.page = Documents.page where Batch.name = Documents.name where do i enter this I am a complete newbie to this !!! In other words an idot the more info the better it will help me learn thanks.....

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

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

(getdate()) IS WHAT I WAS LOOKING FOR THANKS hmckillop & james

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