Using CASE statement in SQL Server

This tutorial will show you how to use CASE statement to check a value of the column in SQL Server? […]

Updated on     Kisan Patel

WHILE loop in SQL Server

This tutorial will show you how to use WHILE loop in SQL Server? Similar to IF condition, WHILE loop is […]

Updated on     Kisan Patel

IF condition in SQL Server

This tutorial will show you how to use IF condition in SQL Server? If condition works in SQL server in […]

Updated on     Kisan Patel

Get more Details About Error Occurred in SQL Server

This tutorial will show you how to get more details about an error occurred in SQL Server? To get more […]

Updated on     Kisan Patel

How to catch and throw error in SQL Server?

This tutorial will show you how to catch and throw error in SQL Server? To throw error, we use RAISERROR […]

Updated on     Kisan Patel

Handle error in SQL Server Stored Procedures

This tutorial will show you how to handle errors in store procedure¬†in SQL Server? To handle error in stored procedure […]

Updated on     Kisan Patel

Convert Hostname to IP Address using C#

If you have a hostname such as google.com, and you need to obtain the IP address then use the Dns.GetHostEntry […]

Updated on     Kisan Patel

Convert IP Address to Hostname using C#

If you have an IP address and you need to resolve its hostname then use the Dns.GetHostEntry method in C#. […]

Updated on     Kisan Patel

How to Ping Programmatically to Remote Server using C#

To check a remote server availability on the network using C#, you need to use the System.Net.NetworkInformation.Ping class. class Program […]

Updated on     Kisan Patel

Upload files using the FTP in C#

To upload files using the File Transfer Protocol (FTP), you need to use the System.Net.FtpWebRequest class. string uploadFilePath = @”C:\example.html”; […]

Updated on     Kisan Patel