z.nasiri
جمعه 18 مرداد 1387, 23:22 عصر
سلام
من این کد ها را وارد میکنم و خطا هایی که نوشتم را می گیره البته با این خطا ها من result دارم . من این خطا ها را در مورد همه ی procedure , select که به این شکل هستند دارم:گریه:
create procedure happeninge
@eventmonth smallint = 0
,@eventday smallint = 0
,@happening nchar(20) output
as
select @happening=(select happening
from dbo.evente
where eventmonth=@eventmonth
and
eventday=@eventday)
return @happening
go
declare @happening_output nchar(20)
execute happeninge
3,2
select @happening_output as eventhappening
Msg 201, Level 16, State 4, Procedure happeninge, Line 0
Procedure or Function 'happeninge' expects parameter '@happening', which was not supplied.
select ImageData from dbo.imagee
where ImageId=(
select cardid from dbo.card
where flagid =
(select flagid from dbo.flag
where flagquantity ='famous' ))
Msg 512, Level 16, State 1, Line 2
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression
.فرموده بودن که کد جا به جا شده اما جابجایی صورت نگرفته
من این کد ها را وارد میکنم و خطا هایی که نوشتم را می گیره البته با این خطا ها من result دارم . من این خطا ها را در مورد همه ی procedure , select که به این شکل هستند دارم:گریه:
create procedure happeninge
@eventmonth smallint = 0
,@eventday smallint = 0
,@happening nchar(20) output
as
select @happening=(select happening
from dbo.evente
where eventmonth=@eventmonth
and
eventday=@eventday)
return @happening
go
declare @happening_output nchar(20)
execute happeninge
3,2
select @happening_output as eventhappening
Msg 201, Level 16, State 4, Procedure happeninge, Line 0
Procedure or Function 'happeninge' expects parameter '@happening', which was not supplied.
select ImageData from dbo.imagee
where ImageId=(
select cardid from dbo.card
where flagid =
(select flagid from dbo.flag
where flagquantity ='famous' ))
Msg 512, Level 16, State 1, Line 2
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression
.فرموده بودن که کد جا به جا شده اما جابجایی صورت نگرفته