TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
hesam jahangiri
NA
8
6.6k
multy statement
Jan 10 2013 5:40 PM
hi
i have a problem. when run blow store proc , only first statement excute and another states do not excute . please help me.
----------------------
begin try
BEGIN
IF (SELECT COUNT(PK_ID) FROM Sanad_Bargiri WHERE Shomareh_Sanad=@Shomareh_Sanad) = 0
begin
insert into Sanad_Bargiri (Fk_Agency,Ty_Mojavez,Shomareh_Nameh,Shomareh_Havaleh,Date_Reg,Shomareh_Sanad,Fk_SahebKala,Add_frestandeh,Mahal_Bargiri,MaghSad,Vazn,Fk_Girandeh,Add_girandeh,Type_Kala,Ty_Pardakht_Haml,nam_pardakh_haml,Nerkh_Kerayeh_Barnameh,Disc)
values (@Fk_Agency,@Ty_Mojavez,@Shomareh_Nameh,@Shomareh_Havaleh,@Date_Reg,@Shomareh_Sanad,@Fk_SahebKala,@add_ferestandeh,@Mahal_Bargiri,@MaghSad,@Vazn,@Fk_Girandeh,@add_girandeh,@Type_Kala,@Ty_Pardakht_Haml,@nam_pardakh_haml,@Nerkh_Kerayeh_Barnameh,@Disc)
return 1
END
updaTE SahebKala
set Address=@add_ferestandeh
where SahebKala.ID=@Fk_SahebKala
update SahebKala
set Address=@add_girandeh
where ID = @Fk_Girandeh
END
END TRY
begin catch
print 'Error'
end catch
Reply
Answers (
0
)
Can anyone give me example for sql server reporting services
Sql Query