|
|
|
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 fetching a block of rows Posted by s_alexander04 NO[at]SPAM list.ru at 3/25/2006 11:56:57 PM How to fetch a block of rows by the cursor at a time?
If it's not possible to return several rows in one FETCH is there other
way to read table in series of rows?
...more >>
What is MISSING from Microsoft SQL Server 2005 Express Edition??? Posted by Alan Mailer at 3/25/2006 5:13:21 PM I was looking a Microsoft SQL Server 2005 Express Edition. What I
couldn't seem to find are it's 'limitations'. In other words, what
*doesn't* it have that the non-Express Edition *does* have?
Thanks in advance for your help....more >>
Any SQL experts? Posted by amy at 3/25/2006 4:16:24 PM Hi, I have an SP that was working fine (took about 10 mins to process).
I've added a section of the SP below for reference. Here is an overview of
my table structure (simplified).
EMPLOYEE TABLE
employeeid
name
IsActive
EMPLOYEE HISTORY TABLE
employeeid
name
IsActive
FromDate -- t...more >>
replication and trigger Posted by rockdale at 3/25/2006 3:28:33 PM Hi, all:
We have 5 databases which contains invoice and invoiceHistory tables.
We have an update and insert trigger on invoice table to record every
modification into InvoiceHistory table. The invoiceHistory table is not
read only, it has some fields that the end user can edit (comments,
d...more >>
Authentication Posted by christof at 3/25/2006 3:20:46 PM Let's say we've got 2 computers - [A] and [B] where is a SQL Server.
Is it possible to make user from [A] log into instance of SQL Server on
[B] with Windows Authentication? So is there a possibility to create a
user on [B] that will correspond exactly to [A], or not?
[A] and [B] could be tota...more >>
Stored Procedure to Number Records by Sort Order Posted by Altemir at 3/25/2006 10:23:44 AM I need to number records in a table in way that indicates the order
they were sorted. For example, I would start with the following table:
PartID NeedDate Priority
A 12/1/2005
A 2/12/2006
B 11/2/2005
C 3/12/2006
C 4/2/2007
C 5/13/2007
and the s...more >>
Query help Posted by Niclas at 3/25/2006 12:00:00 AM Hi,
I am struggling with a SQL query and was hoping to get some help.
This is a simplifed scenario:
I have 2 tables
Table1 Results with 2 columns USERID (int) and RESULT (datetime)
Table 2 Users UserID (int), firstname (varchar), lastname(varchar)
The results table stores datetime ...more >>
Query help Posted by Niclas at 3/25/2006 12:00:00 AM Hi,
I am struggling with a SQL query and was hoping to get some help.
This is a simplifed scenario:
I have 2 tables
Table1 Results with 2 columns USERID (int) and RESULT (datetime)
Table 2 Users UserID (int), firstname (varchar), lastname(varchar)
The results table stores datetime ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
| home · blog · groups | Questions? Comments? Contact the dn |