|
|
|
January 2003 March 2003 April 2003 May 2003 June 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 November 2007 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Can somebody give me the number of rows in each table Posted by Tony Johansson at 7/3/2005 11:22:24 AM Hello Experts!
The question that I want to have an answer to is how many rows does the
Person table have and how many rows does table Car have.
NOTE!!! I don't have the database so I can't check by using these select
statements.
select count(*) from Person and select count(*) from Car.
It s...more >>
Enable Identity Posted by scott at 7/3/2005 10:53:42 AM Below is sample code to create a table within DTS. Every time I use such
code, I have to manually edit each table created and set the primary key
field to be an identity type.
Can I change the code below on the causeID field to make it an identity type
with code?
CODE:
CREATE TABL...more >>
Variables in custom functions Posted by Mark Rae at 7/3/2005 10:39:14 AM Hi,
I'm sure this is a very easy question, but I'm having a bit of "senior
moment" this morning and would be grateful for some assistance.
Basically, I have a custom function which returns a table of timesheet data
and, within the SELECT statement, I need to return different values
accor...more >>
Insert,update,delete trigger Posted by Tod at 7/3/2005 12:00:00 AM Hi,
I have a trigger which fires in insert, update and delete
("CREATE TRIGGER MY_TRIGGER ON [dbo].[MY_TABLE] FOR INSERT, UPDATE, DELETE
AS...")
In this trigger, how I can I know this trigger fired because insert, update
or delete?
Thanks...
...more >>
counter/sequence in database Posted by eXavier at 7/3/2005 12:00:00 AM Hi all,
I'm looking for some common patterns on counters (or sequences) implemented
in database.
I need several sequences with definable range. It should be function -
something like GetNext(SequenceType). I need to call it from within
potentially concurrently running transactions so that tra...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |