Browsing monthly archive

April 2025

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 […]

Digitalduniya 0

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), […]

Digitalduniya 0