Passing Parameter To The SP

Passing Parameter

 to pass current datetime as a parameter to an SP. is like this : declare @rrr datetime = getdate() exec

The following will
droprouteprocessing @inpdate = @rrrnot work :
exec
droprouteprocessing GetDate()exec droprouteprocessing @inpdate = getdate()exec droprouteprocessing (select getdate())exec


In
separate droprouteprocessing select getdate() particular, the last two statements will work as though they are sql statements. Hence the SP will execute with default parametersand
the then select GETDATE() statement will be executed, which will display current datetime on console.

Suppose I want


The only way it will work To The SP