写完提示错误,说语法错误???/
CREATE PROCEDURE p_my_AdvertisementLoad
(
in AdID int
)BEGIN
DECLARE @adid INT;
set @adid=adid;
select
AdID,
isnull(ServerID,0) as ServerID,
isnull(Path,'') as Path,
isnull(VideoName,'') as VideoName,
isnull(Title,'') as Title,
isnull(swfPath,'') as swfPath,
isnull(a.AdTypeID,0) as AdTypeID,
isnull(VideoSize,0) as VideoSize,
isnull(MediaTypeID,0) as MediaTypeID,
isnull(LinkUrl,'') as LinkUrl,
isnull(Createtime,'') as Createtime,
isnull(CompanyID,0) as CompanyID,
BrandID,
adt.ParentID ,
IfPay,
EngTitle,
VideoLength,
NPlus
AdID,
isnull(ServerID,0) as ServerID,
isnull(Path,'') as Path,
isnull(VideoName,'') as VideoName,
isnull(Title,'') as Title,
isnull(swfPath,'') as swfPath,
isnull(a.AdTypeID,0) as AdTypeID,
isnull(VideoSize,0) as VideoSize,
isnull(MediaTypeID,0) as MediaTypeID,
isnull(LinkUrl,'') as LinkUrl,
isnull(Createtime,'') as Createtime,
isnull(CompanyID,0) as CompanyID,
BrandID,
adt.ParentID ,
IfPay,
EngTitle,
VideoLength,
NPlus,
cp_id,
IfShare,ShareCP
FROM Advertisement a left join AdType adt
on a.Adtypeid=adt.adtypeid
where a.AdID = @AdID;
END;档案如上
CREATE PROCEDURE p_my_AdvertisementLoad
(
in AdID int
)BEGIN
DECLARE @adid INT;
set @adid=adid;
select
AdID,
isnull(ServerID,0) as ServerID,
isnull(Path,'') as Path,
isnull(VideoName,'') as VideoName,
isnull(Title,'') as Title,
isnull(swfPath,'') as swfPath,
isnull(a.AdTypeID,0) as AdTypeID,
isnull(VideoSize,0) as VideoSize,
isnull(MediaTypeID,0) as MediaTypeID,
isnull(LinkUrl,'') as LinkUrl,
isnull(Createtime,'') as Createtime,
isnull(CompanyID,0) as CompanyID,
BrandID,
adt.ParentID ,
IfPay,
EngTitle,
VideoLength,
NPlus
AdID,
isnull(ServerID,0) as ServerID,
isnull(Path,'') as Path,
isnull(VideoName,'') as VideoName,
isnull(Title,'') as Title,
isnull(swfPath,'') as swfPath,
isnull(a.AdTypeID,0) as AdTypeID,
isnull(VideoSize,0) as VideoSize,
isnull(MediaTypeID,0) as MediaTypeID,
isnull(LinkUrl,'') as LinkUrl,
isnull(Createtime,'') as Createtime,
isnull(CompanyID,0) as CompanyID,
BrandID,
adt.ParentID ,
IfPay,
EngTitle,
VideoLength,
NPlus,
cp_id,
IfShare,ShareCP
FROM Advertisement a left join AdType adt
on a.Adtypeid=adt.adtypeid
where a.AdID = @AdID;
END;档案如上
在最上面加delimiter //create proc......
end //
有oracle/sqlserver/db2的问题可以问我
elimiter //;create proc......
end //delimiter;//
各种版本语法不一样的。