October 29, 2009 at 1:04 am
hi
i have write a store procedure:
ALTER PROCEDURE [dbo].[DownloadCount_SP]
@FileCodesql int
AS BEGIN
update [File]
set DownloadCount=DownloadCount+1
Where FileCode = @FileCodesql
END
this store procedure works correctly, but now i want to add another thing to it, ( i want to have this updated record , i think i have to add "select command" to it , but i dont know where and how)
could you please help me?
October 29, 2009 at 2:48 am
This is a duplicate topic, I take it, the answers in your other topic didnt help?
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 29, 2009 at 2:53 am
i wrote this :
select * from [files] where (update [File]
set DownloadCount=DownloadCount+1
Where FileCode = '1')
but there is syntax error
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply