|
|
|
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 Identity Columns as Primary Keys Posted by wrytat at 10/28/2007 9:33:00 PM All the while, I've been using the usual column(s) with the usual datatype
(e.g. varchar, int, ..) as the primary key(s) of the tables I have. For
instance, I have a Customer table, then I will make the VARCHAR(4) CustID
column as the primary key.
Now, my colleague told me that using an ide...more >>
Create and Alter Stored Proc in the same SQL file Posted by maa at 10/28/2007 5:25:00 PM I would like to perform a Create on a stored proc if not found but alter in
the case of an existing stored proc and do this in the same file. I can do
it in 2 files and run if I know state of db. Is it possible to do the
following:
if ( Stored Proc does not Exists) {
Create Stored Proc...more >>
Who added files? Posted by Bob at 10/28/2007 12:02:00 PM How can I tell who added some files to the database, and when?...more >>
Sp nesting Posted by Barry Burke at 10/28/2007 11:34:00 AM How many SPs could be nested 'normally',
i have seen nesting with level of 10 and totally calling more than 50
Procedures
being invoked from one single procedure, thereby being involved triggers and
cursors.
The DB Programmers are like 'scripting people'....more >>
SP sometimes "locks up" and times out Posted by Jeremy at 10/28/2007 11:01:52 AM I have an app that runs a process. One of the steps is embodied in a stored
proc (sql 2k5), and it sometimes times out after 120 seconds. Bear with me,
I've done quite a bit of work on this.
The stored proc creates a temp table with IDs of records to delete, then
deletes records from 10 t...more >>
Dropping off users Posted by Ana at 10/28/2007 12:14:20 AM Hi,
I'd like to drop off all connections to the server at a certain time.
How do I complish it?
TIA
Ana
SQL05...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |