About: isa:1534568   Sponge Permalink

An Entity of Type : prov:Entity, within Data Space : webisadb.webdatacommons.org associated with source dataset(s)

AttributesValues
rdf:type
prov:value
  • Use the UPDATE and JOIN , here is an example , using the details you posted :create table #temp1(col_id INT , col_date datetime)create table #temp2(col_id INT , col_date datetime)INSERT INTO #temp1 select 1, '01-01-2001'UNIONselect 2,'02-02-2001'INSERT INTO #temp2 select 1, '03-03-2001'UNIONselect 2,'04-04-2001'UPDATE #temp2 SET col_date = B.col_dateFROM #temp2 AS A INNER JOIN #temp1 AS BON A.col_
prov:wasQuotedFrom
is prov:wasDerivedFrom of
Alternative Linked Data Views: ODE     Raw Data in: CXML | CSV | RDF ( N-Triples N3/Turtle JSON XML ) | OData ( Atom JSON ) | Microdata ( JSON HTML) | JSON-LD    About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 07.20.3217, on Linux (x86_64-pc-linux-gnu), Standard Edition
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2012 OpenLink Software