Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nab7373
Starting Member
2 Posts |
 Posted - 2010-05-08 : 00:49:15
|
Hi,i convert database from access to sql server..sql statement is ok with access but showing error with sql server 2008..Incorrect Syntax error near ','Statment : "UPDATE TRANH,TRAND SET TRANH.TMPVALUE=TRAND.EMAT WHERE TRANH.SID=TRANDHSID"I tried to google it.. NAB |
|
|
nab7373
Starting Member
2 Posts |
Posted - 2010-05-08 : 01:29:55
|
| Sorry..to post this.. i just found solutioni tried inbuilt SQL Query..New Query...and try to select tables and fields..from its selection list...now statement is running ok..as follows..for referenceUPDATE TRANH SET TRANH.TMPVALUE=TRAND.EAMT FROM TRANH,TRAND WHERE TRANH.SID=TRAND.HSIDTHE DIFFERENCE IS == "FROM TRANH,TRAND" which not required in access...NAB |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Update SQL Statment Error