stored procedure jobschedule

Posted by Dn2010 under ASP.NET on 4/9/2012 | Points: 10 | Views : 929 | Status : [Member] | Replies : 2
hi friends,
compare the dateandtime, to insert the new updated records, its working frontend,(aspx)
but i want to run only backend (sqlserver) stored procedure jobscheduling,
i dont know the stored procedure
compare the dateandtime, to insert the new updated records,

sqlserver mysql are both same fields and same table name,
mysql table data fetch into sql server table data
mysql is in remote db.

please go through the attachement,

please give the stored procedure,
thanks.




Responses

Posted by: Hariinakoti on: 4/9/2012 [Member] Starter | Points: 25

Up
0
Down
Create Procedure sample(procedure name)
(@action char,@Date datetime,@Sal int) as
begin
if(action=i)
insert into tablename (Date,Sal) values(@Date,@Sal)
end
aswellas u can write for update and delete also

Thanks & Regards
Hari

Dn2010, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Dn2010 on: 4/9/2012 [Member] Starter | Points: 25

Up
0
Down
thanks for your response,

pls give in detail.

Dn2010, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response