CREATE procedure p_dddd
@pageName varchar
as
declare @pageId int
select @pageId=pageId,pageName,pageNum
from page
where pageName=@pageName
select picId,picName,picNum,pageId
from pic
where pageId=@pageId
GO
我想在执行第一个SQL语句的时候取出pageID然后做为第二个SQL语句的查询条件.我这样写总是提示"向变量赋值的 SELECT 语句不能与数据检索操作结合使用。" 请问有什么别的方法吗?
@pageName varchar
as
declare @pageId int
select @pageId=pageId,pageName,pageNum
from page
where pageName=@pageName
select picId,picName,picNum,pageId
from pic
where pageId=@pageId
GO
我想在执行第一个SQL语句的时候取出pageID然后做为第二个SQL语句的查询条件.我这样写总是提示"向变量赋值的 SELECT 语句不能与数据检索操作结合使用。" 请问有什么别的方法吗?
CREATE procedure p_dddd
@pageName varchar
as
select picId,picName,picNum,pageId
from pic where pageId in (
select pageId,pageName,pageNum
from page
where pageName=@pageName)
go
@pageName varchar
as
declare @pageId int
select @pageId=pageId --,pageName,pageNum
from page
where pageName=@pageNameselect picId,picName,picNum,pageId
from pic
where pageId=@pageId
GO
@pageName varchar
as
select picId,picName,picNum,pageId
from pic where pageId in (
select pageId from page
where pageName=@pageName)
go
@pageName varchar
as
declare @pageId int
select pageId,pageName,pageNum
from page
where pageName=@pageNameselect picId,picName,picNum,pageId
from pic a
where exists (select * from page b where a.pageId=b.pageId and b.pageName=@pageName)
GO
CREATE procedure p_dddd
@pageName varchar
as
select pageId,pageName,pageNum
from page where pageName=@pageName
union all
select picId,picName,picNum
from pic where pageId in (
select pageId from page
where pageName=@pageName)
go