by: M Wells |
last post by:
Hi All,
I have a database that is serving a web site with reasonably high
traffiic.
We're getting errors at certain points where processes are being
locked. In particular, one of our people...
|
by: Steven An |
last post by:
Howdy,
I need to write an update query with multiple aggregate functions.
Here is an example:
UPDATE t
SET
t.a = ( select avg(f.q) from dbo.foo f where f.p = t.y ),
t.b = ( select sum(f.q)...
|
by: Najib Abi Fadel |
last post by:
Hi all i am running PostgreSQL 7.3.2,
i have a VIEW for which i implemented multiple RULES on UPDATE.
The weird think is that the Update Query corresponding to one of the rules is updating...
|
by: UDBDBA |
last post by:
Hi:
This is a merge questions which has been posted and answered... in my
case need more clairification when target table (tableB) matched
multiple rows to be updated based on the ON condition...
|
by: Thom Little |
last post by:
I need to have multiple applications in the same 2.0 webspace.
I am using the add-in to Visual Studio 2005 that permits me to do this and
it creates namespaces in a manner very similar to 1.1 in...
|
by: davidevan |
last post by:
I'm trying to update a single field in a table according to the an age
category as a condition.
The meat of the code that executes looks like this (I created a record
set, and loop through it...
|
by: luckyerdai |
last post by:
I have a table, what I need to do is
if Field 1= a, field 2=b, field 3=c, then field 4 update to xxxx;
iif Field 1= a, field 2=b, field 3=d, then field 4 update to xxxxxx,
if Field 1= z, field...
|
by: pratsadhu |
last post by:
Hi,
I have a table which has columns name, date1, date2.
Through 'Or' condition, i can update name but to update date1 and date2 I have another condition. ID1 matches, date1 will be updated...
|
by: MARIEDB2 |
last post by:
Hello,
I am struggling to build a query on a DB2 db wich does an update for multiple fields which are the result of a select query with where clause (using multiple tables in the condition).
...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|