|
|
|
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 BCP rowcount Posted by TLV at 10/23/2004 8:32:09 PM Hi,
I am working on data auto-archive process.
I move data from server1 to server2 using bcp command line .
I want to know the row count of each bcp queryout statement.
I executed this code in command line:
bcp "exec master..sp_who 1 " queryout "c:\sp_who.bcp" -S. -T -c
Is there is an...more >>
Newbie problem: Saving a view from a linked server won't work Posted by Hi. I've created a linked server to Oracle 8i. I want to save a view as
follows:
SELECT *
FROM ORACLE8I..SCOTT.EMP EMP_1
From SQL Query Analyser, this returns a nice set or records. Running this
from the view designer also returns a nice result. However, if I try to to
s...more >>
Decimal Places in TSQL Posted by Shaqman at 10/23/2004 6:46:05 PM Newbie to T-SQL,
How can I return the result of a division to 2 decimal places. Doing a
sample SP, when I issue PRINT 80/60 yields 1. I need to see 1.33. Any help
will be appreciated
Shak
...more >>
sql server connection problem Posted by Savas Ates at 10/23/2004 4:37:37 PM "SQL Server does not exist or access denied"
sql server error:17
i cant connect sql Server 2000
why?
...more >>
compute clause Posted by Curtis at 10/23/2004 12:46:17 PM Is there anyway to specify the column name when using the compute clause in
a stored procedure?
compute sum(mycolumn)
seems to return "sum" for tables(0).column(0).columnname when using vb.net
changing the stored procedure to
compute sum(mycolumn) as mynewcolumnname
gives an error n...more >>
delete statement causing procedure to hang Posted by Mike at 10/23/2004 11:33:18 AM I have a stored procedure that inserts about 2K rows into a table of about
500K rows. It then performs updates on around 2K rows, then sometimes
deletes 2K rows. To be honest most of the applications I've written prior
to this do small inserts and primarily just selects to display informatio...more >>
redundant trigger calling Posted by dearkami NO[at]SPAM yahoo.com at 10/23/2004 7:24:36 AM Hi,
I want to know how to run redundant trigger for deletion.
For e.g. i made a delete trigger on Table1. It updates some record in
Table2 and then delete
another row in Table1 on some condition.
I assume that this trigger will run again as soon as the previous
trigger tries to delete...more >>
Table Groups? Posted by Wayne Wengert at 10/23/2004 7:06:39 AM Is there a way to get a list of just those tables used by a specific
application? The application shares a SQL2000 database with other
application. When the user needs to select a table I'd prefer to offer only
those tables that "belong" to that application. Looking at BOL I am not
finding any g...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
ms-sql-s established Posted by Arjen at 10/23/2004 12:18:22 AM Hello,
I'm running a webapplication which uses msde 2000 as database server.
All webpages query the database.
If I refresh a lot of time a webpage then I get a time-out error .
With the netstat command I found a lot of ms-sql-s connections.
Is there a way to disconenct these connections?
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |