how can i make a varchar field unique in MS SQL server 2000?

Dear Experts, can you help me with this access conumdrum. I have several tables with autonumbers in each which are being used for each table as a primary key. However, I need to combine 3 of the tables as a union quiry and have a field in each table which I need to keep as the item number field in the...

Hello, I have a table(table1) that contains a memo field, I'm creating another table from a query using table1. My problem is that when I run the query, the text from the memo field is converted to symbols(square with a -) and asian symbols?! Do you have any idea what is happening when I run the...

i have created a table and i want the primary key to be system generated(atuo number) but i cant find the auto number data dype so i used the uniqueidentifier data type...or are there any other way to make the primary key auto number?

I am developing an Access application with an ADP file. I am using Access as the front end and SQL Server as the back end database. How would you modify the following routine to add a new field named OFFICE which is derived from positions 4 to 6 of the COSTCENTER field ? Open "C:\psttest.txt"...