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'