?? bugnet_component_getchildcomponentsbycomponentid.sql
字號:
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[BugNet_Component_GetChildComponentsByComponentId]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[BugNet_Component_GetChildComponentsByComponentId]
GO
CREATE PROCEDURE [dbo].[BugNet_Component_GetChildComponentsByComponentId]
@ComponentId int
AS
SELECT
ComponentId,
ProjectId,
Name,
ParentComponentId,
(SELECT COUNT(*) FROM Component WHERE ParentComponentId=c.ComponentId) ChildCount
FROM Component c
WHERE
c.ParentComponentId = @ComponentId
ORDER BY Name
GO
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -