I am trying to search for a table for some information using this query
select * from table  A
where  lastdate between '07/01/06' AND '07/30/06'
the lastdate column dates are listed as date and time '2007-01-08

I want to drop all the tables and in a database and repopulate with the tables exist in the other server.
What is the best method that i can do?
While i am trying to drop the object i am getting error if it has dependencies how and i drop all the tables including all the ...

In a table I have the value like following:
X_CREATE_SOURCE    INTEGRATION_ID
Sales            SR0000000082
Sales            SR0000000083

I need some help with distinct count on mulitple field e.g
Select count (distinct Field1, Field2, Field3, Field4, Field5, Field6,
Field7, Field8, Field8)
from tableA

foreach (Table NewTable in TblCollection)
           {
               if (NewTable.IsSystemObject == false)
               {

I have created a Linked Server and a stored procedure.
In the stored procedure i create a temporary table
i fill the temporary table with data from the linked server.
use the temp table to issue a couple of things

I have a web application with a lot of stores procedures running under SQL
Server 2000 in English but the languaje of the application is Spanish. In
many of these stored procedures there are transformations of text dates like
convert(datetime,'01/07/2008 19:45:23') before I store ...

since sqlwish@microsoft.com is gone , anyone knows where people can set new
wishes for future versions of SQL Server ? all links i searched does not
work
thank you

One of the method to search a particular column within all tables in a
database is:
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS

What's the easiest way to do this using an "IN" Parameter???
DECLARE    @ContactRequestLst    char(100)
SET    @ContactRequestLst    =    '(195666)'
;

I want to be able to keep 2 postions for date.
Select datepart(mm,getdate())
I want the mm to show as 07 not 7.

I'm experimenting with XML DML. I need to add an attribute only if it meet
some condition. But I can not use an sql variable to implement the
condition. The following example gives me an error:
XQuery [modify()]: An expression was expected

Use SQL Server 2000
Given a table which holds string data ( could be characters as well)
If user provide with value let me say '88' I return the data where this
value is occured (col= 4,5,7 for example in my case)

Using SQL 2000 sp4
This query works, put takes about 11 to 20 seconds.
Just trying to be more effient with it and maybe write it better. I hope I
explain this correctly so you guys can understnd.

One of my co-workers and I are trying to figure out how this  script works. I
do understand using multiple Select statements to get multiple result sets.
Can someone help us with what this script is doing? My take was that it's
like building arrays.