How To Enable and Disable XP_CMDSHELL Using SP_CONFIGURE

How To Enable and Disable XP_CMDSHELL Using SP_CONFIGURE In this article we will discuss How To Enable and Disable XP_CMDSHELL Using SP_CONFIGURE.The xp_cmdshell option is a server configuration option that enables system administrators to control whether the xp_cmdshell extended stored procedure can be executed on a system.In order to use XP_CMDSHELL you need to be a

How To Hide An Instance Of SQL Server

How To Hide An Instance Of SQL Server In this article we will learn How To Hide An Instance Of SQL Server. Sometime in your organization you has been asked for hiding an Instance of SQL Server. In earlier post we have dicussed How To Enable and Disable XP_CMDSHELL Using SP_CONFIGURE. Hiding an SQL Server Instance will help

Progress Bar Example In Asp.Net

Progress Bar Example In Asp.Net In this post we will learn how to use Progress Bar Example In Asp.Net.We are using a DropDownList with having locations of different cities, Submit button on click of Submit button the data is loaded in ASP.Net GridView. Also there’s HTML DIV which is used to display the loading progress image till

IIF() Function in SQL Server 2012

IIF() Function in SQL Server 2012 In this post we will discuss about IIF() Function.The IIF function means “Immediate IIF”.IIF is a shorthand way for writing a CASE expression.This functions take three arguments. If the first argument is true, it will return the second argument as result or it will return the third argument as

Date and Time Data Type in SQL Server 2008

Date and Time Data Type in SQL Server 2008 In this post we will discuss about Date and Time Data Type in SQL Server 2008. SmallDateTime: Defines date with the time of the day in 24-hour clock format. Requires fixed 4-bytes to store data. It can have date between January 1, 1900 through June 6, 2079 and time between

Captcha Example In Asp.Net C#

Captcha Example In Asp.Net C# In this tutorial i will explain about Captcha,and how to use Captcha Example In Asp.Net C#.We will use Generic Handler to achieve this. Design: <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Index.aspx.cs" Inherits="Index" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>Captcha Example In Asp.Net C#</title> <style type="text/css"> .bdy { margin: 0px auto; width:900px; font-family:Calibri;

Globally Unique Identifiers (GUID) In SQL Server

Globally Unique Identifiers (GUID) In SQL Server In this post we will learn about Globally Unique Identifiers (GUID) In SQL Server.Globally unique numbers(GUID) data type actually holds information that is designed to be created and viewed using the standard 32-digit hexadecimal format.To generate such a value, the NewId() function is called. Advantage: Unique across the server. Disadvantage: String values