I have a command file with the following SQL statement:
bcp "SELECT * FROM [%dbname%].[dbo].[%1] WHERE DATEDIFF(hour,TimeStamp,
DATEADD(n, -DATEPART(n,getdate()), getdate())) <=24" queryout %CurDate%.tmp
-U -P -f %formatfile%

Example data:
column1   column2      
abcs12     123456
asdf-af     1234

I am attempting to update a text field using UPDATETEXT
I need the table_name for UPDATETEXT table_name.dest_column_name
However, my SP could be running on ANY database.  So like any other query, I
just want it to use the current database.  

I'm running a SQL Server Enterprise Manager.  When I click on 'Change Query
Type', a window pops up on the bottom right hand corner of my screen with the
options: 'Select, Insert from, Insert into, Update, etc.'.  The window used
to appear right under the bottom, but now every ...

Can you tell me whats wrong with this query?
select count(*) as CountedOrders
from
(

I have been strugling with for hours -
I have a table with the following columns
UID(decimal) | SD(bit) | MB(bit) | TS(bit) | Total(Decimal)
I want to run a query which will return

i have a field that has the date of birth's in the following format,
20/06/1982
i want to take this out of the date of births / , the finish date of birth
field should be like this

I need to search for multiple things, all using wildcards but it does not
seem to work:
select *
from Table

i have three fields that are title, firstname and surname,
i want to add all three field together in a different field,
How can this be done

I recently did a little development on an Oracle database and utilized bind
variables in a script like this:
SELECT first_name, last_name, zip FROM customers WHERE id = :cust_no
and simply defined ":cust_no" as a parameter through my application code.  I