| Groups | Blog | Home |
|
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 31 Multi-database access in trigger Posted by CYTAY at 3/14/2004 11:06:07 PM Dear all,
I would like to know... Is that a way that can be programmed to make a trigger to update a table resides at the other database? For instance... Whenever there is a new record inserted in database A's table B, the trigger fired and update database C's table D?
Thanks in advance...more >>
How to Create and Debug a Setup Program to Update a SQL Server Database Posted by johannblake NO[at]SPAM yahoo.com at 3/14/2004 10:55:17 PM This article shows one solution on how you can create a setup program
to deploy an update for your SQL Server database. If your customer
already has a SQL Server database installed and you want to use a
Transact-SQL script to update the database model, there are several
options on how you can do...more >>
maintenance plan Posted by Frank Dulk at 3/14/2004 10:38:06 PM Using maintenance plan can make backup for another personal computer
...more >>
Escaping ' charactors in SQL Posted by Andrew Banks at 3/14/2004 9:04:07 PM I'm having problems with some charactors in SQL statements.
For example, the following would give me an error.
UPDATE Table SET Column1 = 'This statement's not too long' WHERE ID = '2'
I can see that the error's due to the ' in statement's. I'm assuiming I need
to escape this somehow. How ...more >>
SQL Server 2K connection is interrupted regularly, why ? Posted by Oscar at 3/14/2004 8:52:57 PM In my OLEDB ADO configuration SQL Server 2K regularly hangs for a while
within a client request. At such a hanging , the error
'[DBNETLIB] ConnectionOpen (Connect().] . The SQL Server doesn't exist or
you don't have permission to the server ' is shown .
In such a case I go into the debugging...more >>
How to prevent queries showing up in Profiler? Posted by Ben Fidge at 3/14/2004 6:01:38 PM How do you prevent or protect your custom queries executed from within a
custom application (in this case a Delphi written app) from being displayed
by Profiler?
Are there any special "SET ??? OFF" commands that instruct the Profiler NOT
to display SQL queries?
Thanks
Ben
...more >>
COUNT Posted by shank at 3/14/2004 5:15:43 PM How can I get all the records below AND a final record count?
I can get one of the other, but not both.
thanks!
SELECT #TempNR.*
FROM #TempNR
...more >>
Creating a view that uses a sp to retrive data Posted by Glenn Wilson at 3/14/2004 4:46:05 PM Can some one give me an example of creating a view that gets its data from the execution of a stored procedure (ie. sp_help_jobhistory
Thanks Glenn...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Keylocks and updates Posted by Max Spectrum at 3/14/2004 3:56:05 PM Scenario: A table that is 6 columns wide, has a primary key with a clustered index. One of the columns is incremented approx. 250-300 times/minute. At this rate key locks and some general performance degradation occurs on the server. Anything higher causes performance to drop dramtically.
Any sugg...more >>
using 'sp_' as a naming convention for stored procedures Posted by Scott at 3/14/2004 3:07:03 PM I know that using 'sp_' as a naming convention for stored
procedures is not a good idea because MS uses that naming
for system stored procedures. I am working on a system
where the original developer had all of the stored
procedures named "sp_" then the name. I am being told
that this ...more >>
Cursor inside another cursor, or...? Posted by \ at 3/14/2004 1:30:24 PM I'm doing something like the following, but I need to insert a few
functions.
1) I would like to be able to insert each orderline from our
INVOICELINEARCHIVE in the email text below the T&T number - like:
*Pseudo code*
For Each Line in INVOICELINEARCHIVE, Where INVOICELINEARCHIVE.NUMBER =
@O...more >>
Query: Which employee had the most orders... for each day Posted by Bill at 3/14/2004 11:49:05 AM Wow... here's an SQL2k/Access2k query that sounds like it "should" be short,
easy (and very common):
My table contains records with fields of:
> EomKey (The record ID #)
> EomDateSort (The date of the order)
> EomEmp (The employee name)
I can get the total number o...more >>
EXCEPT: As far as I can tell, these two queries are equivalent. Can anyone confirm? Posted by David F at 3/14/2004 10:00:27 AM In order to implement set difference (EXCEPT) you typically use a correlated
subquery with NOT EXISTS.
Using the Pubs database, find all the publishers who do not sell business
books...
SELECT pub_id, pub_name
FROM publishers
WHERE NOT EXISTS
(SELECT *
FROM titles
WHERE pub_id = publish...more >>
T-SQL : Unknown number of input parameters Posted by Jaco at 3/14/2004 8:41:06 AM Hi
When I will start a query, I want to ask the user to input some parameters (dates)
My second problem is that the user have to input minimal 2 dates (input parameter), but he may choose the number of input parameters. So, in my programm I don't know before the number of input parameters
Purp...more >>
use of @@error Posted by John Brown at 3/14/2004 3:11:05 AM Question on errors in sp transactions:
if I check the value of @@error I can decide what to do in TSQL. However I have seen that in some cases the error is soimportant that a rollback willhappen automatically. My question: what can be captured by @@error and what causes an automatic rollback?
...more >>
SQL Server 2K disconnects the client after reaching a specific amount of query load. Posted by Oscar at 3/14/2004 12:36:41 AM In my VB-SQL Server 2K application the client is disconnected sometimes and
receives an errormessage which depends on the cursorsetting. The problem is
that the app. performs successively some large queries (Opening of ADO
recordsets for read actions). While it is able to perform the frst set of
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |