Procedure or function expects parameter ' which is not supplied

This post discuss in details at DataHaunting

Hi many of us  facing this type of problem when wroking SQL Server .

let me illustrate the example if you are working with the SQL Server

in the given example if you execute the procedure it will show the error as given below because here
we need the pass the parameter  as '@name' 

now if you are passing the parameter as 'dilip0165' your query will be execute successfully .

if you have need  number of arguments to insert into table  then you have to pass the number of
parameter as here we have passed .