| Groups | Blog | Home |
|
March 2003 April 2003 May 2003 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 |
Filter by week: 1 2 3 4 5 I just showed my boss a simple SQL statement... Posted by Ian at 6/21/2005 2:15:05 AM insert X select * from X
(4194304 row(s) affected)
00:00:44
This was on a little twin processor Dell blade thing.
I strongly suspect his XX terabyte 32 processor Sun Oracle server
licence is going to be renegotiated on price in a few month't time.
...more >>
subtract rows Posted by pikapi at 6/21/2005 12:40:01 AM Hi,
I have the following table:
INOUT Total
1 3
2 2
2 4
1 3
2 6
1 23
2 33
I want to make a query that will do the following:
Subtract (the sum of the total where inout=1) from (the sum of the
total where inout=2)
Any help is greatly appreciated. Thanks
...more >>
How do i search all Stored Procedures for a table name Posted by weegee NO[at]SPAM metronet.co.uk at 6/20/2005 4:45:58 AM What I want to do is to search within the text of all Stored Procedures
....for instances of a table name within the SQL
statement
Does anyone know how I would be able to do this?
Say for example I want to search for the table tblContractHistory
Would I use sysobjects?
...more >>
SQL 2000, SP3a "TOP 100%" Posted by RTL at 6/17/2005 8:53:19 PM Ever since we rebooted the machine, all of our views have been modified with
the "TOP 100%" We cannot seem to remove this. MS Access barks at us when we
try to modify a table and it's because of the TOP 100% text.
How to remove it...make it go away...just ignore it?
Cheers,
Rich
...more >>
alter column sql Posted by Jeff Kish at 6/16/2005 10:36:53 AM Hi.
Is there some way to get enterprise manager or query analyzer to tell me the
sql it uses for an alter column operation?
I would just do :
alter table asset alter column asset_number varchar(60)
go
but there are other contraints etcc.
I don't know how to 'cascade' them, and the
...more >>
Inserting current date midnight Posted by kayda at 6/16/2005 9:09:17 AM Hi:
You can INSERT the current date and time like this
SELECT databasefield, getdate()
FROM testtable
but what is the easiest way to SELECT the current date's midnight
timestamp, so instead of SELECTing 6/17/2005 4:17:32 PM it would SELECT
6/17/2005 12:00:00 AM?
Thanks,
Kayda
...more >>
Increment a single column? Posted by Noozer at 6/16/2005 9:04:39 AM Just wondering if there is a simple way to do this...
I have an MS Access table that I'm using from an ASP page. It's quite
simple... Just one row with six columns. I want to be able to specify a
column and increment the value in that column.
Something like this.. I want to increment the val...more >>
Transact-SQL Tutorial Posted by b_naick NO[at]SPAM yahoo.ca at 6/15/2005 1:11:43 PM Are there any good free online tutorials for T-SQL?
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
| home · blog · groups | Questions? Comments? Contact the dn |