|
|
|
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 Best practice for storing email like text Posted by Charlie Dison at 3/28/2004 10:00:35 PM Hi there,
Among the features of my asp.net application is a need for two users to
communicate with each other. Questioner will ask a question, responder may
simply answer or respond with a question. There may be several threads.
There is no way to know what the maximum text length might b...more >>
begin Posted by Frank Dulk at 3/28/2004 9:12:23 PM Does the begin only serve for of the the rollback in case of mistake?
...more >>
Can't quite get my head round this Posted by Keith at 3/28/2004 8:47:31 PM Hi
I am relatively new to SQL Server, but not to DBs - I have a lot of
experience in Access.
I have just been given the task at work of creating a fairly complex
database and web application.
Whilst not a problem, I have fell at the first hurdel.
I cannot get my head round the relation...more >>
Table Naming and Keywords Posted by Brad at 3/28/2004 6:51:08 PM Hi
I'm reviewing SQL standards for a new database, and I've come across a few potential problems. I've adopted a non-plural naming scheme for entities. Thus, we have tables such as "Product", "Component", "ProductComponent". However I have some problems with some entities that have names that are ...more >>
sql server 2000 - slow record retrieval Posted by byron at 3/28/2004 6:26:08 PM Hi. I need to retrieve the top 600 records from a table with 1/2 a million records.
I only want records where the 'EX_FromStaffID' field matches the variable @StaffID or when @StaffID = 0 to return all records
I'm using the follow code
--********************************
-- code (1
declare @...more >>
Help with returning variable column in SP Posted by Kent Ogletree at 3/28/2004 6:04:40 PM I am rewriting an application and trying to do a lot of optimization. PArt
of that is moving all queries into Stored procedures. I am having a problem
with one query in particular, right now it is two seperate queries and the
application does some hunt and match for each item. It is a real perfor...more >>
How do I: "Build a DOS Path" - My table is using adjacency model - ParentID Posted by Russell Mangel at 3/28/2004 5:31:07 PM Hi
I would like to build an SQL2000 stored procedure which takes an ID (a directory), and returns a completed DOS path, as a string like this
storedProcedureBuildDOSPath 1
Example: The procedure would take an ID of 10 in this case for "etc" leaf node, and return an (output parameter) the compl...more >>
Problem in WHERE Expression Posted by mj at 3/28/2004 3:49:04 PM Hi. I'm stumped but close. Any suggestions would be a real
help. I have a view that's based on one table named
tblShipped. Here's what the output would look like if it
were grouped by CUSTOMER__,INVOICE_DA,PRODUCT_H2:
CUSTOMER__ INVOICE_DA PRODUCT_H2 SALES__ QUANTITY
0000011183 12...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How to use VFP OLEDB Provider in openrowset ? Posted by Luqman at 3/28/2004 3:43:29 PM How to use VFP OLEDB Provider in openrowset of Sql Server 2000 Query
Analyzer?
Best Regards,
Luqman
...more >>
query syntax Posted by y at 3/28/2004 9:41:08 AM This is comparing (3) periods to one another and I think that I understand most of it, but what does the =2 at the very end mean
Thank
--------------------------------------------------------------------------------------
SELECT name, symbo
FROM a_Name_Symbol AS
WHER
(SELECT COUNT(*
...more >>
'Create' User Forms From the Database? Posted by CSDunn at 3/28/2004 7:26:49 AM Hello,
I am beginning the process of recreating an Access 2000 mdb application to
run on SQL Server 2000 standard. The forms in the Access application allow
K-2 schoolteachers to transfer test question answers from student test
booklets into Access forms. There is a different form for each dif...more >>
Distinguish User Objects and System objects Posted by Arr S at 3/28/2004 1:41:05 AM How to differentiate between user objects(table,view...) and system objects. Where is this information stored in SQL Server 7.0
Thanks in advance
Arr S...more >>
SQL Server 2000 - Hierarchical data - Versus - Post Relational Databases Posted by Russell Mangel at 3/28/2004 1:38:40 AM I have been working on a new SQL Server 2000 database system for the last
three months.
The database is storing hierarchical-based data from Exchange Server, it is
almost complete and it seems to be performing reasonably well.
However, during many phases of development, I feel like I have succ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |