Categories
Sql Server

What Is A Cursor?

What Is A Cursor? In this post we will discuss about What Is A Cursor?.A cursor keeps track of the position in the result set, and allows you to perform multiple operations row by row against a result set.We can also fetch cursor rows and perform operations on them in a loop just like using any […]

Categories
Sql Server

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

Categories
Sql Server

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

Categories
Sql Server

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