drbing的博客

1、首先获取所连接数据库的名字 sql语句：Select Name From Master..SysDataBases Where DbId=(Select Dbid From Master..SysProcesses Where Spid = @@spid) 2、截取其中从第8位开始的3位数 sql语句：Select SUBSTRING(Name,8,3) From Master..Sys

情景：某一字段有子父级关系，找出此记录属于第几级，同时找出是否是最末级 sql语句 WITHtradertype(tradetypeid,code,lcode,name,parentid,class_level) AS (SELECT   a.tradetypeid ,a.code ,a.lcode , a.name ,a.parentid, 1 AS class_level