How to enable error in IIS Server?

How to enable error in IIS Server for debugging the issue in code? 1) Enable IIS detailed errors IIS introduces a new custom errors feature, which by default hides the error responses issued by the server to remote clients, replacing them with a basic error message.  This is critical for security of your site, as […]

How to wright a Store Procedure in MS SQL Server

How to wright a Store Procedure in MS SQL Server   Basic Stored Procedure in SQL Server CREATE PROCEDURE GetUserById @UserId INT AS BEGIN SET NOCOUNT ON; SELECT * FROM Users WHERE Id = @UserId; END;   To run it: EXEC GetUserById @UserId = 1; Stored Procedure With Multiple Parameters CREATE PROCEDURE InsertUser @Name NVARCHAR(100), […]