select as into from where
来源:百度知道 编辑:UC知道 时间:2024/06/11 11:00:26
select f1 as txzxdm
into #xbuffer
from wtzc40base..xbuffer
where xzbh = @p_xzbh
------------------------------------------------
select xx from xx where xx看的懂,但是里面加了个as。。into就不懂了。f1是什么,在上下文中看不到, xbuffer是个表还是变量,前面加个#代表什么?
into #xbuffer
from wtzc40base..xbuffer
where xzbh = @p_xzbh
------------------------------------------------
select xx from xx where xx看的懂,但是里面加了个as。。into就不懂了。f1是什么,在上下文中看不到, xbuffer是个表还是变量,前面加个#代表什么?
select f1(当前表的字段) as(生成别名关键字) txzxdm(当前字段f1的别名)
into(查询建表关键字) #xbuffer(生成的新表的表名)
from wtzc40base..xbuffer
where xzbh = @p_xzbh
不知道我这么些你懂不懂,关于这个你可以看一下帮助文档,在sql的帮助“索引”中你可以输入select into就可以查到这个答案了
select as into from where
select into
select into问题(oracle)
select * into temp from (select * from MESSAGES),这个对吗?
insert select的语句和select into语句的区别?
SQL, insert into 后跟 select是什么意思?
select count(*) into :i from userinfo &
virtualpc select item cannot fit into memory
SELECT Count(*) AS aa FROM是什么意思?
select count(*) as sc_name from school是什么意思?