你说的临时表应该就是 SQL SERVER里面的视图吧
如果是的话语句应该如下:
create view 视图名 as
select * from table
/20050520/Img225648909.gif" border="0" onload="if(this.width>screen.width*0.7) {this.resized=true; this.width=screen.width*0.7; this.alt='Click here to open new window\nCTRL+Mouse wheel to zoom in/out';}" onmouseover="if(this.width>screen.width*0.7) {this.resized=true; this.width=screen.width*0.7; this.style.cursor='hand'; this.alt='Click here to open new window\nCTRL+Mouse wheel to zoom in/out';}" onclick="if(!this.resized) {return true;} else {window.open('http://photocdn./20050520/Img225648909.gif');}" onmousewheel="return imgzoom(this);" alt="" />