|
|
|
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 Stored Procedure Help Posted by Jack T. at 7/12/2003 10:40:59 PM Goal:
I need to have a stored procedure that will increment an integer value
in a control table column every time it is called and return that number to
the caller. The procedure will be called where columns name the procedure
to generate their default value. It will be used for by more co...more >>
installing evaluation SQL sever 2000 Posted by Austin Smith at 7/12/2003 6:37:45 PM If anyone could help it would be great. I am tring to
install sever 2000, I run setup, get to where it asks the
location of the new instance of SQL Server, I hit "local"
then "next". Error "A previous program installation
created pending file operations on the installation
machine. You mus...more >>
BUG: certain characters screw up QA display Posted by FN at 7/12/2003 6:34:53 PM I'm connecting to a SQL7 SP4 server, and my local machine has SQL2000's
Query Analyzer. I just noticed this bug related to returning an encrypted
string value.
The data in the table is fine, but when I do a SELECT * FROM TABLE and this
field value comes back
´o¸açPQ`'?Á>?ª©Áä+í "ôHrA...more >>
Do I have this right? Posted by bburke NO[at]SPAM fcgov.com at 7/12/2003 5:21:28 PM Calling SQL Server 2k from Access97 through ADO using sqloledb.1
Views Sorting= No Parameters= Yes Updatable= Yes
Stored Proc Sorting= Yes Parameters= Yes Updatable= No
UDF Scalar Sorting= NA Parameters= Yes Updatable= No
UDF InlineTable Sorting= Yes Parameter...more >>
create data with "sa" owner Posted by LamP at 7/12/2003 4:44:01 PM Hi,
Could anyone help me create database with "sa" owner. When
I login as "Administrator" in win2000 environment, the
newly created data has owner as "domain/Administrator"
not "sa"
Thanks in Advance,
Lam
...more >>
Extending client to access Excel files (most data still in SQL Server) Posted by cstolte NO[at]SPAM stanford.edu at 7/12/2003 3:18:14 PM We are building a general query tool for accessing data in our
company. The primary data source we access is SQL Server running on a
remote host, using OLE DB and C++. However, our users also want to be
able to use our tool to analyze data in Excel or delimited text files.
We are considering two...more >>
Avoiding large queries... Posted by cstolte NO[at]SPAM stanford.edu at 7/12/2003 1:37:37 PM Hi,
We are writing an ad hoc query tool for our users and we want to be
able to warn them when the query they are about to run will either
take a long-time (some rough time estimate) or return a large number
of rows (approx). We connect to a SQL Server database using OLE DB /
C++. Is there a ...more >>
Create random string Posted by Jason Davis at 7/12/2003 12:46:30 PM How can I create a random (not necessarily unique) - 8 character string?
Thanks!
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Diabled Triggers Posted by BAbu at 7/12/2003 12:07:29 PM Is there any way, I can get the list of all Disabled
triggers from a particular databse.
I need it urgently plz
Babu
...more >>
Select Statement Question (Again) Posted by Largo SQL Tools at 7/12/2003 10:37:07 AM I have the following simple Select statement which produces an error when I
attempt to save it as part of a stored proc.
Select InvoiceID, dbo.Customer_CalculateAgedBalance (@CustomerID) as
AgedBalance
From Invoices
Where AgedBalance > @MinimumBalance
Note: dbo.Customer_CalculateAgedBalanc...more >>
Working Definition of 3rd Normal form Posted by Jay Schmitendorf at 7/12/2003 8:50:38 AM Since every job interview I go toasks about all 3 normal forms all at once
the
definition like
A database in third normal form has no repeating
fields and groups in any record and only relevant, atomic keys.
I know the use of the word 'atomic' may seem out of place, bu...more >>
Capturing queries sent to SQL Server Posted by dean at 7/12/2003 6:16:59 AM I use a software package that queries a Microsoft SQL Server 2000 database
from a client side Windows application. The client application has a built
in report generator that allows users to easily produce complex reports.
The client application was written in Delphi, and uses Borland's BDE t...more >>
how to join a set of fetch into one output Posted by ashita at 7/12/2003 1:21:44 AM DECLARE @PhotoID int
DECLARE photo_cursor CURSOR FOR SELECT PhotoID FROM Photos
OPEN photo_cursor
FETCH NEXT FROM photo_cursor
WHILE @@FETCH_STATUS = 0
BEGIN
FETCH NEXT FROM photo_cursor
END
CLOSE photo_cursor
DEALLOCATE photo_cursor
the output is separated, how to join the resul...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |