O.K

i want to insert a some fileds to a record wich is in a database (i saved it before), i want if the primary key of that record equal with...

i wrote this :

select * from [files] where (update [File]

set DownloadCount=DownloadCount+1

Where FileCode = '1')

but there is syntax error

ooooooooo no

i want to have store procedure that do this:

ALTER PROCEDURE [dbo].[DownloadCount_SP]

@FileCodesql int

AS BEGIN

update [File]

set DownloadCount=DownloadCount+1

Where FileCode = @FileCodesql

END

and this store proceduure in...

thanks a lot. you solved my problem

i used Microsoft SQL Server 2005

thanks alot

but wher i should write this command? and how?

i should say that i forgot my password, and i tried to change it when i use new pass this error is occured ,i think i did not chane...

from Management Studio , File Connetion Object Explorer...

then i type IP and Sa and pass...

Thank u very much but i have 3 questions:

why when i write:

1) EXECUTE GetLastID2 @sqlString

it doesnt work ?

2) what should i write instead of @sqlString when...

i want it asks me about the value of those 3 variables, and when i wrote them , the select can Do,

for example iwant to write "exec Garhasbi "in...

i tried to correct it:

alter PROCEDURE Garhasbi1

@Cat1_Value int,

@Cat2_Value int,

@Date_Time datetime

...

Sorry

i think you understand mu problem correcctly but your Solution isdifficult for me

i want to ask could we complete this WHERE clause and solve the problem

Create Procedure test

...

sorry dont you use from ( filter_value) ?

and i dont understand

Set @sql = @sql + @filter_column + ' + @filter_column and Date_Time = @date'

Exec sp_executesql...

i thinkk i need 4 variable for enter the parameters:

1: Category name

2: Category desc

3:date&Time1

4:date&Time2

ii want this store procedure ask me these three and then give me he records:for example:

ID ...

Thank you

i created it, but where is it saved? i mean from where i can see and modify this Store Procedure again it future?