Kreiram je sa ovim code-om ispod i kada uradim refresh, sp postoji u bazi, cim refreshujem aplikaciju (ASP.NET), prijavi mi Object reference not set to an instance of an object, gresku.
Vratim se u MS Server Management, uradim refresh i procedure nema...
Jel ja ludim ili ne radim nesto kako treba?
if exists(select * from dbo.sysobjects where id = object_id(N'[spForumGetNumberOfPosts]') and OBJECTPROPERTY(id, N'isProcedure') = 1)
drop procedure [spForumGetNumberOfPosts]
GO
CREATE PROCEDURE [spForumGetNumberOfPosts]
(
@SubForumId int
)
-- WITH ENCRYPTION
AS
begin
select Count(*) as PostsNumber
from posts left join threads on posts.threads_id = threads.threads_id
where
threads.subforums_id = @SubForumId;
end -- end spForumGetPostsNum