Interview Questions in ASP.NET,C#.NET,SQL Server
Why would you like to change the company? 1) I am looking for a more challenging career in a firm with a larger employee base such as yours. 2) Keeping in mind my career goals, the time has come for me to move onto the next rung of the ladder and make a mark for myself. This can be achieved in a company like this. 3) It is just a career move to enhance my knowledge in my own area of interest. After completion of this question only interview will go for further questions Difference between stored procedure and function 1) Procedure can return zero or n values whereas function can return one value which is mandatory. 2) Procedures can have input, output parameters for it whereas functions can have only input parameters. 3) Procedure allows select as well as DML statement in it whereas function allows only select statement in it. 4) Functions can be called from procedure whereas procedures cannot be called from function. 5) Exception can be handled by try-catch block