#1  
Old 16th December 2018, 11:04 PM
Diniz
 
Posts: n/a
Default No Subject

Hi Eivind

//UPDATE ERROR
SELECT REFERENCIA, DESCRICAO, UNIDADE, FOTO, INFORMACAO
INTO #Temp
FROM PRODUTOSB
WHERE CODIGO = 1;

UPDATE PRODUTOSA
SET REFERENCIA = (SELECT REFERENCIA FROM #Temp),
DESCRICAO = (SELECT DESCRICAO FROM #Temp),
UNIDADE = (SELECT UNIDADE FROM #Temp),
FOTO = (SELECT FOTO FROM #Temp),
INFORMACAO = (SELECT INFORMACAO FROM #Temp)
WHERE CODIGO = 1;



// INSERT (OK)
INSERT INTO PRODUTOSA SELECT * FROM PRODUTOSB WHERE CODIGO = 11;

thanks
Diniz

---
Este email foi escaneado pelo Avast antiv?rus.
https://www.avast.com/antivirus

Attached Files
File Type: rar Produtos.rar (183.8 KB, 0 views)


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
No Subject Francisco San Jose Juarez nexusdb.public.support 1 14th February 2007 11:37 PM
No Subject Ken Randall nexusdb.public.support 1 16th August 2006 10:37 AM
No Subject Bernhard Roos nexusdb.public.support.adoprovider 3 21st February 2006 03:29 PM
No Subject Luc Jeanniard nexusdb.public.support 1 6th January 2006 10:45 PM
No Subject Diniz nexusdb.public.support 5 25th August 2005 05:35 PM


All times are GMT +11. The time now is 01:50 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.