sql 定义临时变量，给变量赋值

declare @a int , @b varchar(22);

set @b= 13656221310;

set @a=(select id from pt_user where login_id = @b);

select @a 




insert into cfg_user_project (user_id,project_id,system_id) VALUES (@a,'282','2');

insert into cfg_user_sec (user_id,sec_id,project_id,system_id) VALUES (@a,'590','282','2'); -- SG3
 insert into cfg_user_sec (user_id,sec_id,project_id,system_id) VALUES (@a,'591','282','2'); -- SG4
insert into cfg_user_sec (user_id,sec_id,project_id,system_id) VALUES (@a,'592','282','2');    -- SG2
 insert into cfg_user_sec (user_id,sec_id,project_id,system_id) VALUES (@a,'595','282','2');    -- SG1

insert into pt_role_user (user_id,role_id) values (@a,'396');


insert into pt_user (username,login_id,pwd,disabled,create_time) values ('巫斌',@b,'888888','0',GETDATE());