34,590
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE dbo.GetPartChildern
(
@parent int
)
AS
SET NOCOUNT ON
SELECT a
FROM Part a --这里加个别名下面也可以用a
WHERE a.Parent = @parent
--RETURN 去掉这个
GO
CREATE PROCEDURE dbo.GetPartChildern
(
@parent int
)
AS
SET NOCOUNT ON
SELECT *
FROM Part
WHERE (Parent = @parent)