2020-8-26 糖果小宝
sql
Declare @s varchar(1000)
select @s=','+cast(id as varchar(20))+'' from M_Directory where id=5
while @@rowCount>0
--charindex:返回字符串中指定表达式的起始位置
select @s=@s+','+cast(id as ...
阅读全文>>
评论(0)
浏览(814)
2020-8-26 糖果小宝
sql
WITH COMMENT_CTE(id,MainID,name,UpdateName,create_id,isdelete, tLevel)
AS(
SELECT id,MainID,name,UpdateName,create_id,isdelete,0 AS tLevel FROM M_Directory WHERE id =3
UNION ALL
SELECT c.id,c.MainID,c.name,ce.UpdateName,c.create_id,c.isdelete,ce.tLevel - 1 FROM M_Directory AS c INNER JOIN C...
阅读全文>>
评论(0)
浏览(835)