Deepan's Tech

Good Practices to Write Stored Procedures in SQL Server Use proper indentation for the statements in SQL Server. It will improve the readability. Write the proper comments between the logics. So the others can understand quickly. Write all the SQL Server keywords in the CAPS letter. For example SELECT, FROM and CREATE. Write the stored procedure name with full qualified names. CREATE PROCEDURE [dbo].EmployeeSalaryCalculation   Always try to declare the DECLARATION and initialization at the beginning of the stored procedure. It is not recommended to use more variables in the procedure. It will occupy more space in the memory.   Do not write the stored procedure name beginning with sp_. It is reserved for the system stored procedures in SQL Server and when the request comes to the SQL Server engine, it will be considerd to be a system stored procedure and looks for it in the master database. Afte...

Try this and it should work Go to your project folder and open .vs folder (keep your check hidden item-box checked as this folder may be hidden sometimes) in .vs folder - open config see that applicationhost config file there? Delete that thing.(Do not worry it will regenerate automatically once you recompile the project.) Ref : https://stackoverflow.com/questions/37352603/localhost-refused-to-connect-error-in-visual-studio