SQL skill

copy table:

select * into table2 (select * from table1) c

update table:

update a
set a.id = b.qID
from v3_group a join qun2 b on a.groupid = b.groupid

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>