Thursday, Septem9:45:40 AM - Greg Robidoux In server agent created job named as dlt -> in that job under step - a) generalДЄnd clicked on append output to existing fileД«ut it is not executing and taking backup for evry 5minД¬an u tell me is this procedure is right or wrong ? Script Date: 3:34:45 PM ******/ДELETE FROM Table1 WHERE DATEDIFF(DD,DateTime,GETDATE())>=10 Nice tutorial but you should add more pictuers. People just do this so then can identify what the object is based on the name, but other than that there is no real purpose.Дid I miss the part where you explain the prupose of the prefix of usp in the Proc name? What does that mean or stand for? There is not any real purpose to have a prefix for any of the objects. Wednesday, Janu11:07:13 AM - Greg Robidoux It would be great if the execution is also showed. Is there a way to have null default parameter to be used IN clause The parameter names and values don't need to be in the same order they are defined in the SP! As long as you outline parameter names when you execute your SP, the order of your parameters can be in any way you want.

Trouble is when you do that, you need to outline the parameters in the correct order they are defined in the SPДў. When you execute the stored procedure, you don't NEED to outline the names of the parameters. I really appreciate your great work.ДЇriday, Octo6:27:26 AM - SimpleSQLTutorialsДЄlso remember two interesting facts about stored procedure parameters:ДЎ. I really enjoyed going through this nice tutorial. Wednesday, Decem12:53:06 PM - Omer Salim Mohmand

With recompile stored procedure