Can a not optional parameter follow an optional one in the t-sql stored procedure?
===

Here's the declaration I'd like to have.

    CREATE PROCEDURE UpdateTimeProc  
    (  
    	@Hours int,  
    	@Minutes int,  
    	@Seconds int = 0,  
    	@ResetCounter bit  
    )

