1.插入一条记录
insert into Tim_Tree_Info (tree_class,tree_describe,tree_learn,tree_first,tree_order,Tree_MaxNum,Tree_FieldName,tree_pre,tree_PreName,Tree_FirstName,Tree_Name1,Tree_Name2,Tree_Name3,Tree_NameDep) values (略)
declare @start1 varchar(50) //定义一个变量
set @start1 = (select top 1 tree_id from Tim_Tree_Info order by tree_id desc) //给变量赋值
--print @start1
update Tim_Tree_Info set Tree_Road=',135339,135433,'+@start1+',',Tree_IsLast='1' wheretree_id=@start1
update Tim_Acc_Info set Tree_ID=@start1,tree_road=',135339,135433,'+@start1+',',info_delete='0' where Acc_Name='091521' or Acc_Name='091661' or Acc_Name='091704' or Acc_Name='091579' or Acc_Name='091522' or Acc_Name='091609' or Acc_Name='091640'
2.
insert into users (last_name,pwd,purview,email) values('txl','12345','view','yztxl@eyou.com');
select @@identity
SELECT TOP n PERCENT表示返回的前面的n%行
例:select top 10 percent * from life_unite_product