create proc xxx
@id varchar(10)
as
select b.Treeid,b.strCategory,b.IntHave,b.IntTotalInfo
from CategoryProp as a,NewCategory as b
where
a.CategoryId=b.TreeId
and a.IntParent= @id
order by a.DisplayOrder Asc调用的时候 exec xxx 'id的值'
@id varchar(10)
as
select b.Treeid,b.strCategory,b.IntHave,b.IntTotalInfo
from CategoryProp as a,NewCategory as b
where
a.CategoryId=b.TreeId
and a.IntParent= @id
order by a.DisplayOrder Asc调用的时候 exec xxx 'id的值'
-------------------------------------------------------------------
create procedure sp_test(@id int)
as
select
b.*
from
CategoryProp a
inner join
NewCategory b
on
a.CategoryId = b.TreeId
where
a.a.IntParent= @id
order by
a.DisplayOrder Asc
GO
@id int
as
select b.* from CategoryProp a,NewCategory b
where a.CategoryId = b.TreeId
and a.a.IntParent= @id
order by a.DisplayOrder Asc
go
@id int
as
select b.Treeid,b.strCategory,b.IntHave,b.IntTotalInfo
from CategoryProp as a,NewCategory as b
where
a.CategoryId=b.TreeId
and a.IntParent= “ & id & ”
order by a.DisplayOrder Asc
@id varchar(10)
as
select b.Treeid,b.strCategory,b.IntHave,b.IntTotalInfo
from CategoryProp as a,
NewCategory as b
where a.CategoryId=b.TreeId and a.IntParent= @id order by a.DisplayOrder Asc
as
select
b.*
from
CategoryProp a
inner join
NewCategory b
on
a.CategoryId = b.TreeId
where
a.a.IntParent= @id
order by
a.DisplayOrder Asc
GO
@id int
as
select b.Treeid,b.strCategory,b.IntHave,b.IntTotalInfo
from CategoryProp as a,NewCategory as b
where
a.CategoryId=b.TreeId
and a.IntParent= @id
order by a.DisplayOrder Asc