select Name,Age,sex from EmployeeName 假如有多条 数据,我想在存储过程里对应的查出结果DECLARE @Name nvarchar(20)
DECLARE @Age int
DECLARE @sex nvarchar(20)对应上面Sql语句查询出各项,插入到另一个表中insert into 表A valuse (@Name,@Age,@sex,getdate())求写法
DECLARE @Age int
DECLARE @sex nvarchar(20)对应上面Sql语句查询出各项,插入到另一个表中insert into 表A valuse (@Name,@Age,@sex,getdate())求写法
select Name,Age,sex,getdate()
from EmployeeName
where ...不就可以呢?
select Name,Age,sex,getdate() from EmployeeName
select ...
from b
where....
insert into 表A(Name,Age,sex,date)
select Name,Age,sex,getdate() from EmployeeName
select Name,Age,sex,getdate()
from EmployeeName join tb 1 on ...
join tb2 on ...
where ...总之就是表的连接查询,找出符合条件的记录插入进去。
select Name,Age,sex,getdate()
from EmployeeName 仅此而已..