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. ...
Thursday, 21 July 2016

Windows 2012 - Install IIS on Windows Server 2012 R2

›
Installing and configuring IIS on Windows 2012 R2 is well explained in the below article with step by step screenshots. Below is the link t...