|
|
|
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 SQL 2005 Output Clause To VB6 Variable Posted by Lovely Angel For You at 9/8/2007 10:30:24 PM Hi,
I am using Visual basic 6 with SQL 2005. In one particular query, I
need to update 3 different tables, dependent on input.
So, the Primary ID for FirstTable, need to be refernced in other Two
Tables.
I searched a bit on the internet and found that SQL2005, has Output
Clause. However ...more >>
'NVARCHAR' is not a recognized CURSOR option. Posted by Jay at 9/8/2007 8:26:35 PM 2005 Express
When I try an run:
DECLARE TABLE_CATALOG NVARCHAR(128)
I get:
Msg 155, Level 15, State 2, Line 1
'NVARCHAR' is not a recognized CURSOR option.
I don't understand.
...more >>
SCD Wizard Question Posted by Mike C# at 9/8/2007 7:41:59 PM Hi all,
I've been playing around with the SSIS SCD Wizard. I noticed that I seem to
be getting better performance updating my SCD's with stored procedures. Is
there a list of best practices concerning the SCD Wizard or something else I
might be missing? Also, I have about 30 Dimension ta...more >>
DBCC CHECKDB WITH DATA_PURITY Posted by Bassam at 9/8/2007 5:48:26 PM Hello
I performed command ,
DBCC CHECKDB WITH DATA_PURITY
Against just attached database between SQL Server 2000 and 2005 as
recommended by instructions, i received this error msg about one of my
tables
Msg 2570, Level 16, State 3, Line 1
Page (1:3530), slot 30 in object ID 11561991...more >>
Select the latest version Posted by vovan at 9/8/2007 4:38:01 PM I have a table Invoice which contains multiple records for some invoices:
InvoiceID InvoiceNumber Version
12 0506-0131 1
13 0506-0131 2
14 0506-0131 3
I need to select only re...more >>
Equivalent of Mysql INSERT IGNORE? Posted by Enter The at 9/8/2007 4:08:14 PM What is the Microsoft SQL Server equivalent of MySQL's INSERT IGNORE
INTO ???
...more >>
Twelve Proofs that Muhammad is a True Prophet Posted by ahmedcoco333 NO[at]SPAM hotmail.com at 9/8/2007 5:35:56 AM My brothers and sisters everywhere! With this essay, I am not singling
out the adherents of Islam - to which I ascribe - but rather I am
writing this essay to every man and woman throughout the whole world.
I ask Allah that He facilitates tat this essay reaches every ear,
falls under the sight...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |