摘要:
select distinct id,name ,count(1) from user1 group by id,name 阅读全文
摘要:
-- with 一个临时表(括号里包括的是你要查询的列名) with tem_table(dept_id,parent_id,dep_name,curlevel) as ( --1,初始查询(这里的parent_id='000'是我门数据中最底层的根节点) select dept_id, paren 阅读全文
摘要:
begin tran at01 begin try 业务逻辑语句 commit tran at01 end try begin catchrollback tran at01INSERT INTO t_log (ErrorMessage,ErrorSeverity,ErrorState,operat 阅读全文
摘要:
update a set a.UserRoleName=b.Name from Users a inner join Role b on a.RoleId=b.Id 阅读全文