sql server 2000文法

837 ワード

引用:http://zhidao.baidu.com/question/261673548.html
   
(1)  :create table #  (      ,   2   2。。。。)     :drop table #  
             、  、                          ,     sql         ,
       :create table tempdb..tablename(field1 datatype,field2 datatype....)
(2)              :                     。
        nashville         :
   :create table #temp_info(name char(30),homebase char(40),style char(20),artist_id int)
insert #temp_info select * from artists where homebase='nashville'
select recordings.* from recordings,artists where recordings.artist_id=#temp_info.artist_id
   :select artists.* from artists,recordings where artists.homebase='nashville'