How to fire trigger at the end of the month?
I want to know how 开发者_C百科to fire trigger at the end of the month in MSSql .
Regards, Giri Bhushan
INSERTs and UPDATEs and DELETEs fire triggers. Not schedules.
You'd set up a job in SQL Server Agent to run a stored procedure or some SQL when needed. Or some external scheduler (Windows scheduler, Quartz.net etc) to run some SQL code.
精彩评论