|
|
|
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 Allocate invoice numbers Posted by richardb at 12/24/2005 9:57:02 PM At this point I don't know the terminology of what I need and would
appreciate help even getting started with researching the topic. I need to
allocate a series of (call them) invoice numbers. The "last used number" is
stored in a column of a table. I need to read the last used invoice number,...more >>
Store procedure for reset db Posted by Roy Goldhammer at 12/24/2005 7:52:42 PM Hello there
When i upgrate version i generate script from my computer and run the script
on the computer i want to upgrate
Is there a way to place all the script of tables in store procedure?
script is like Drop table ...
CREATE TABLE...
...more >>
SQLDMO - What name to use to connect to the default instance? Posted by Mark Findlay at 12/24/2005 11:54:49 AM I am using SQLDMO (C++) and trying to connect to the SQL Server default
instance, but I don't know the name to use in the Connect() statement.
I've tried:
"local"
"(local)"
""
What should the "name" parameter be when attempting to connect to the
default instance using SQLDMO?
Many ...more >>
Deleting files Posted by Roy Goldhammer at 12/24/2005 11:47:00 AM Hello there
On every week by Enterprise manager i:
1. Detatch the database
2. delete the log file
3. reattaching it again
I would like to do this by code.
Is there a way to do that?
...more >>
Design Question Posted by Jose at 12/24/2005 6:57:13 AM Dear All,
I have the following design issue which I am unsure how to solve.
Here's the key information:
I am writing a tool which will send emails/SMS to registered users. The
registered user data will be stored in one database (we'll call it
DB1). No changes can be made to DB1. All informa...more >>
Number of indexes can affect performance event in nearly read-only table? Posted by M. Simioni at 12/24/2005 3:23:15 AM I have a table with something like 4.000.000 rows, but only once per
day about 200 rows are inserted by an application, running as a
scheduled job.
So few writes per day are performed, but many reads are executed.
We have on this table 1 clustered index and 5 non-clustered indexes:
this is be...more >>
Faster execution of stored procedure Posted by MilanB at 12/24/2005 3:03:01 AM Hello
I ask which approach gives better speed results. To put next query in one
stored procedure, or to split in two:
//ONE
IF(@FindType=1) /*Find Full word*/
BEGIN
SELECT f_English FROM t_Dictionary
WHERE f_NonEnglish = @parWord
END
ELSE /*Partial find*/
BEGIN
SELECT f_Engl...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |