|
|
|
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 August 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 How to Write SQL Posted by hon123456 at 9/2/2007 11:44:29 PM Dear all,
I got two table,
Table 1, is For Item inventory
inbound_number Invoice_number item
----------------------------------------------------------------------------
A
1 ...more >>
What exactly happens, when I reach the 4 GB limit with SQL Express? Posted by PSiegmann NO[at]SPAM mail.nu at 9/2/2007 8:38:47 PM Hello,
I know that SQL Server 2005 Express has a limitation of 4 GB for a DB.
But, what exactly happens, if you reach this limit?
Does it just stops working? (Shutting down of the SQL Server service?)
Will it not accept anymore inserts? Will it give exceptions?
...more >>
I need help with this code Posted by Vince at 9/2/2007 8:10:35 PM Hi everyone,
For some reason this code wont pass the syntax check. It says error
near SET and error near END
The SET commands look fine to me and as i understand it and so does
the rest. Can anyone see something I cant?
And is the error handling ok or should I use RAISEERROR instead?
Thank...more >>
Declare cursor Posted by Mark Goldin at 9/2/2007 3:10:37 PM Can a cursor be declared like this:
DECLARE cursorname CURSOR FAST_FORWARD FOR
SELECT t.col1, t.col2
FROM udf_tablevaluedfunction(@parm) t
ORDER BY t.col1
Thanks
...more >>
Help with stored procedure Posted by Sandy at 9/2/2007 7:56:01 AM Hello -
I have two tables:
tblLoans
LoanID
AccountNo
etc.
tblBorrower
BorrowerID
BorrowerLastName
etc.
LoanID
I need to join the two tables and return only one name for each account - it
does not matter which name. Most accounts have more than one name and some
...more >>
Stored Procedure results set Posted by PAUL at 9/2/2007 2:44:01 AM Hi
I'm having to re - do some old VB6 programs at the moment.
You know I didn't realise that if a stored procedure updates a table then
returns a result set from same table you can't return the results into a
recordset. It just won't open the rs.
Didn't know that.
paul...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |