CREATE PROCEDURE GetCategories
(@ID VARCHAR(20)
)
AS
IF (@ID<>0) OR (@ID<>'')
BEGIN
SELECT
NodeId,
ParentId,
NodeName
FROM News_Categories
WHERE NodeId = @ID
ORDER BY OrderId
END ELSE BEGIN
SELECT
NodeId,
ParentId,
NodeName
FROM News_Categories
--WHERE NodeId = @ID
ORDER BY OrderIdENDRETURN 0
GO
AS
if @id=0 or isnull(@ID) then
SELECT
NodeId,
ParentId,
NodeName,
FROM News_Categories
ORDER BY OrderId
else
SELECT
NodeId,
ParentId,
NodeName,
FROM News_Categories
where NodeId = @ID
ORDER BY OrderId
RETURN 0
GO
@id varchar(1024)
AS
if @id=0 or @id=null
then
begin SELECT
NodeId,
ParentId,
NodeName,
FROM News_Categories
ORDER BY OrderId
end
else
RETURN 0
GO
CREATE PROCEDURE GetCategories @ID int
AS
if @id=0 or isnull(@ID) then
SELECT
NodeId,
ParentId,
NodeName,
FROM News_Categories
ORDER BY OrderId
else
SELECT
NodeId,
ParentId,
NodeName,
FROM News_Categories
where NodeId = @ID
ORDER BY OrderId
RETURN 0
GO
@id int
AS
if @id=0
begin
SELECT
NodeId,
ParentId,
NodeName,
FROM News_Categories
ORDER BY OrderId
end
else
begin
SELECT
NodeId,
ParentId,
NodeName,
FROM News_Categories
where NodeId = @ID
end
GO
if isnull(@id,0)=0CREATE PROCEDURE GetCategories
@id int
ASif isnull(@id,0)=0
if @id=0
begin
SELECT
NodeId,
ParentId,
NodeName,
FROM News_Categories
ORDER BY OrderId
end
else
begin
SELECT
NodeId,
ParentId,
NodeName,
FROM News_Categories
where NodeId = @ID
end
GO
@id int
ASif isnull(@id,0)=0
set @id=0if @id=0
begin
SELECT
NodeId,
ParentId,
NodeName,
FROM News_Categories
ORDER BY OrderId
end
else
begin
SELECT
NodeId,
ParentId,
NodeName,
FROM News_Categories
where NodeId = @ID
end
GO
AS
begin
if @id = 0
SELECT
NodeId,
ParentId,
NodeName
FROM News_Categories ORDER BY OrderId
else
SELECT
NodeId,
ParentId,
NodeName
FROM News_Categories where NodeId = @ID ORDER BY OrderId
end
GO
返回全部结果集:
exec GetCategories
只返回符合条件NodeId = @ID 的结果集:
exec GetCategories 100
返回全部结果集:
exec GetCategories 或 exec GetCategories 0
只返回符合条件NodeId = @ID 的结果集:
exec GetCategories 100
(@ID int=0
)
AS
IF (@ID<>0)
BEGIN
SELECT
NodeId,
ParentId,
NodeName
FROM News_Categories
WHERE NodeId = @ID
ORDER BY OrderId
END ELSE BEGIN
SELECT
NodeId,
ParentId,
NodeName
FROM News_Categories
ORDER BY OrderIdEND
@ID VARCHAR(20)
AS
BEGIN
IF (@ID<>0) OR (@ID<>'')
BEGIN
SELECT
NodeId,
ParentId,
NodeName
FROM News_Categories
WHERE NodeId = @ID
ORDER BY OrderId
ENDELSE
BEGIN
SELECT
NodeId,
ParentId,
NodeName
FROM News_Categories
ORDER BY OrderId
ENDRETURN 0
END
GO
返回全部结果集:
exec GetCategories 或 exec GetCategories 0
只返回符合条件NodeId = @ID 的结果集:
exec GetCategories 100