Why Iam unable to pass a non null value as input to a stored procedure ??
Hello... I have a stored procedure for which there is an input parameter of type **int**. like **create proc myProcedure @myInput int as begin ..........my logic end** but now .. I dont want to allow a null value to my input parameter. I tried like this. **create proc myProcedure @myInput int not null as begin ..........my logic end It is not working... I know that i can restrict null values in my logic..i want know why we cannot give **not null** at procedure creation time.