Bertolt Brecht What a miserable thing life is: you're living in clover, only the clover isn't good enough.
sql server: create table as select (CTAS-like in Oracle)
category: General tips |
Tag List: create    ctas    oracle    select    sql server   
posted by : jazzvm
view count : 683
2010-01-30 17:44:21, EST: 2010-01-30 03:44:21
posted about 7 months ago

sql server - select table into 

SELECT * 
    INTO new_table_name
FROM original_table_name


만약 new_table_name 이 존재한다면 error 가 발생한다.



oracle - create table as select (CTAS) 

CREATE TABLE new_table_name
AS
SELECT * FROM original_table_name



물론 위의 두 경우 모두 table 생성뿐 아니라, data도 insert 한다.


posted(2010-01-30): www.jazzvm.net/board/view.jazz?seq=1328

도움이 되었거나, 의견이 있으시면 커멘트를 남겨주세요. 글을 작성할 때에 참고가 됩니다.
Please leave any comment or opinion regarding this posting. Particularly when you want to refer to this.
That would provide me with good motivation.
thanks --jazzvm

Name:   PWD:
Five Numbers[one zero zero one eight] :   ex)[zero one two three four] : 01234
sql server: create table as select (CTAS-like in Oracle) jazzvm 2010-01-30 17:44:21