I am trying to create a routine for generating tables from a master
response table.  The end result would increment the variable
"somevalue" by one and then create the next table (ie: TESTTEST2).  Is
there a way to insert the variable into the Table Name as well as one

I have two tables with the same columns (in separate databases) and I would
like to create a third table with the same columns and fill it with all of
the rows from the first two. What is the best way to do it? Some kind of
combination of "select into" and "union"?

Hi all.. I'm trying to pull the first 100 characters from the content stored
in a TEXT type field on a table, and I'm getting this error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Argument data type text is
invalid for argument 1 of left function.

I am getting a data conversion error I cannot explain!
This statement
UPDATE dbImageList
set cx = COS(RADIANS(CRVAL2))*COS(RADIANS(CRVAL1)),

I'm trying to group data by date range, but each row of data could
have a different date range based on a variable.
I want to say "look at the date range the paste five orders were
placed" for each row individually. As an example, think of the rows as

I have a SQL2000 running on a Win2003 server.  I need to move one DB from
this server to another server also running Win2003 and SQL2000.  Both these
servers are on the same domain.  Everything I read on the net has to do with
moving from different version.  Is there a built in ...

I am using the following C# code to establish a SQL connect to a SQL
database file:
// connection string
// attach a SQL database file to a local SQL server express instance

I cannot display Chinses at ASP page. All chinese data (whatever is
Traditional or Simply Chinese) are displayed as ????.
My website connect to MS SQL Server 2005 and all the chinese data are
displayed as ????.

I cannot display Chinses at ASP page. All chinese data (whatever is
Traditional or Simply Chinese) are displayed as ????.
My website connect to MS SQL Server 2005 and all the chinese data are
displayed as ????.

I've written a C# trigger on Developer_Box, using VS 2005
Professional.
I need to deploy it on Test_Server, running SQLServer 2005.
It compile fine, and the references to the appropriate database and

In my select statement, I return a column for 'datediff' using a CASE
query.  I call this column 'Elapsed_days'
is there anyway I can use this result later on in the same select?  IE
I want to refer to 'elasped days' in another CASE query rather than

Information about MySQL Certifications (Newbie)
http://career-assessments.blogspot.com/2008/01/mysql-most-popular-open-source-sq
l.html
For MySQL Aspirants
http://career-assessments.blogspot.com/2008/01/mysql-certifications-aspirants.html

Is there any way to insert into table 100 integers from 1 to 100 in one
insert statement?
Now I have to use loop to insert numbers. I was wondering if there is the
simpler way.

Consider the following two functionally identical example queries:
Query 1:
DECLARE @Name VARCHAR(32)
SET @Name = 'Bob'

I have a question regarding comparing dates within a query.  For instance I
have query and two of the data fields are dates.  I want to be able to
compare the dates and if they are equal disregard them.  If the dates are
not equal then I want the data for those fields.