HighTechnologySQL Server Tutorials, SQL Server Tutorials for Beginners, SQL Server Online Course, Microsoft SQL Server Learning, Microsoft Online Learing
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 […]
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 […]
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 […]