all groups > sql server mseq > august 2006
sqlexec
Posted by shif at 8/27/2006 1:40:02 AM
Hi
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
--
Thanks... more >>
Simple SQL statement question
Posted by Bkana at 8/24/2006 9:43:02 AM
Hello All,
I have a table called invoicedetail with the following fields:
companyname
address
booth number
booth space
In this table a company name could be listed more then once (more then one
row). One row would have the company name and the address, where another row
will have the c... more >>
SQL Query
Posted by murtaza at 8/22/2006 10:40:01 AM
Dear all,
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
times it has been inserted in table B.
... more >>
SELECT DISTINCT records based only on two columns
Posted by archuleta37 at 8/17/2006 6:38:02 AM
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 table and some ... more >>
Full Text File Locations - Best Practices
Posted by tduffy77 via SQLMonster.com at 8/11/2006 8:02:57 PM
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.
Thanks in advance.
Terry
--
Message posted via http://www.sqlmonster.com
... more >>
|