Thursday, 6 September 2018

Windows Service - Add Dependency - After Service is Installed

›
I have a Windows service, that has a dependency on MSMQ (Message Queuing). So I want my service to start only after MSMQ service is started ...
Sunday, 15 January 2017

SQL Server - List all Triggers in a Database

›
You can use the below query to list ass Triggers in your database. It lists the Trigger name, table name and the type of trigger (update / ...
3 comments:
Sunday, 11 December 2016

C# - Update Querystring Values in a Url

›
We will look into a solution to update querystring values in a Url. using System.Web; // url has the complete url with querystring // ex...
Thursday, 8 December 2016

ASP.NET MVC C# - Redirect to External Website from Controller Action Method

›
Refer the below code snippet for redirection from ASP.NET MVC Controller to an external website. The MVC Controller method " Redirect(...
2 comments:
Monday, 24 October 2016

SQL - While Loop Syntax

›
Below is the WHILE LOOP Syntax in SQL DECLARE @cnt INT = 1; WHILE @cnt BETWEEN 1 AND 20 BEGIN PRINT @cnt; SET @cnt = @cnt+1; END SQL ...
1 comment:

SQL - For Loop Syntax

›
SQL doesn't have For Loop, instead you have to use While loop. The syntax is as below. DECLARE @cnt INT = 1; WHILE @cnt BETWEEN 1 ...
Thursday, 18 August 2016

SQL Server - Get DB Object Names, Count

›
SELECT sobjects.name FROM sysobjects sobjects WHERE sobjects.xtype = 'U' The above example lists all the tables in the database. ...