--上面第2条描述写返了
--1.表t2(id,title,content) 中ID不是自增量:
create proc T_proc
as
insert t2 select * from t1 where w='1'
--2.表t2(id,title,content) 中ID是自增量:
create proc T_proc
as
insert t2 select title,content from t1 where w='1'
--1.表t2(id,title,content) 中ID不是自增量:
create proc T_proc
as
insert t2 select * from t1 where w='1'
--2.表t2(id,title,content) 中ID不是自增量:
create proc T_proc
as
insert t2 select title,content from t1 where w='1'