|
|
|
July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
A .cmd file can be run on SQL7, but not on SQL2000 Posted by June at 3/30/2006 9:56:02 AM Hi,
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%
I can run this file on a machine with SQL7 installed, but...more >>
deleting duplicates Posted by carl at 3/29/2006 8:01:01 PM 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
original reocrd and duplicate. The table in qu...more >>
UPDATETEXT table_name Posted by VistaCreek at 3/18/2006 9:34:29 AM 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 assume I am not forced to hardcode the table_...more >>
Enterprise Manager 'Change Query Type' Window Posted by PML at 3/17/2006 5:16:31 AM 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 time I click it,...more >>
Help with a query please Posted by RobA at 3/12/2006 3:17:27 AM 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
UID, Total if SD is True AND
UID, Total if MB is True AND
UID, Total if TS is True
UID is the userID so ...more >>
Nested select Posted by John at 3/9/2006 11:29:34 PM Can you tell me whats wrong with this query?
select count(*) as CountedOrders
from
(
select distinct [order]
from [OrdersTable]
where
[Customer]='100000' and
[Order Date] between '01/01/2005' and '31/12/2005'
)
It runs perfect in MS Access but not in MS SQL-Server.
I need to creat...more >>
SQL Posted by TYE at 3/9/2006 3:45:27 PM hi,
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
20061982
Also
i have a date and time field in sql how can i search one day only the format
...more >>
Using wildcard criteria in an 'in' statement Posted by Jig Bhakta at 3/9/2006 10:05:27 AM I need to search for multiple things, all using wildcards but it does not
seem to work:
select *
from Table
where Field1 in ('A%','B%','C%','D%','E%')
Is it possible to do the above or some variation of it without having to
write multile queries or use the OR condition?
Thanks....more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL ADD THREE FIELDS INTO OTHER FIELS Posted by TYE at 3/8/2006 3:32:28 AM Hi,
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
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |