Is it possible to update a table(table 1) with data from another table (table 2)? Here is what I am trying, but it isn't working.
Update table1 A
set var1 = (select var1
from ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10315880.html
Zones:
MS SQL ServerDate Answered: 06/08/2000 Rating: 7.8 Views: 0
What I need to do:
From ListBox selections on a form Create an SQL statement
that concatenates the fields(AND Values from the table) chosen into a desiginated field("Description") in the table ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20079243.html
Zones:
MS AccessDate Answered: 03/13/2001 Rating: 7.2 Views: 0
I have two tables that are exactly alike. Table A contains the daily transactions, Table B contains the history. I need to update Table B f ReleaseNbr exists in Table A.
The table contains mult...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20120097.html
Zones:
MS SQL ServerDate Answered: 06/15/2001 Rating: 7.2 Views: 0
I want to write a piece of SQL that will allow me to update a column in table ( say table A) based on values that are found in another table (table B). The common thing between the two is the prima...
http://www.experts-exchange.com/Database/Oracle/Q_20182332.html
Zones:
OracleDate Answered: 09/14/2001 Rating: 4.2 Views: 0
Can someone give me some copy and paste code for the following problem, or tell me why my existing code doesn't work.
I want to update a SQL Server table. I wish to update part of the field, no...
http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_20395304.html
Zones:
C#Date Answered: 11/14/2002 Rating: 6.2 Views: 0
ASP Newbie, continuing to get an annoying error for this statement:
Microsoft VBScript runtime (0x800A01A8)
Object required: "
dvd_edit.asp, line 32
27 SQL = vbNullString
28 ...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_20415338.htm...
Zones:
ASPDate Answered: 12/04/2002 Rating: 7.0 Views: 0
Hi,
I am just a beginner in SQL / Sybase.
And I am not familiar with Store Procedures.
Could you tell me how can I write a store procedure to update a field in a table.
I would like to update a...
http://www.experts-exchange.com/Database/Sybase/Q_20435599.html
Zones:
SybaseDate Answered: 01/09/2003 Rating: 8.0 Views: 0
Assume I have the following table in an Access Database:
ID----PERSONID--POINTS-------REWARD
1-----123-------333----------8-----
1-----143-------333----------6-----
1-----324-------312-------...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_20437881.htm...
Zones:
ASPDate Answered: 12/30/2002 Rating: 7.6 Views: 0
I am using JSP and oracle and need to update multiple tables at once, preferably not by having 7 or 8 different update statements. The user fills out/changes a bunch of information on one page and...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20630227.html
Zones:
DatabasesDate Answered: 06/03/2003 Rating: 6.8 Views: 0
Real quick... adding stuff into a DB with a ASP.NET C# app, and an oleDBConnection and oleDbCommand... here is what is giving me the error
Global.oleDbCommand1.CommandText="UPDATE Info SET Email...
http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_20665234.html
Zones:
C#Date Answered: 07/02/2003 Rating: 6.2 Views: 0
