How can i execute a piece of sqlstmt which is stored in a string variable
from query analyser.
for ex:@var1="select name,code from" + @var2

I have a table called invoicedetail with the following fields:
companyname
address
booth number

i've one table (A) which has one field with uniqure phone number recrods,
and there is another table (B) which includes misc. numbers plus records from
table A.
my query is that i want to knwo that which number from table A and how many

I'm having trouble deleting duplicates from enterprise manager. I get "Key
column information is insufficient or incorrect. Too many rows were affected
by update." messages.
I can run delete queries through query analyzer but that will delete the

I'm working on a mailing list and want to select records where the both the
SSN number and Address fields are unique, since I may want to send a piece of
mail to more than one address for a person, but not multiple pieces to the
same address for that person. I've created a test ...

Any suggestions and/or supporting documentation for best practices on where
to locate the full text catalog files. Especially as related to other data,
log, and tempdb files?
My searching is coming up empty.