stored procedure jobschedule

Posted by Dn2010 under ASP.NET on 4/9/2012 | Points: 10 | Views : 1898 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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.

Attachment

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	thanks for your response, pls give in detail. Dn2010, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts