Import Text File Using XP_CMDSHELL In SQL Server

Import Text File Using XP_CMDSHELL In SQL Server In this post we will learn how to Import Text File Using XP_CMDSHELL In SQL Server.There are several options available to import data from external sources to SQL Server. Such as Import & Export Wizard, BULK INSERT command, SSIS and OPENROWSET. Apart from this options you can also

SQL Server – When Will My Backup Finish?

SQL Server – When Will My Backup Finish? In this post we will learn When Will My Backup Finish? in SQL Server.The sys.dm_exec_requests is a great way to find out how long the BACKUP will take to complete. If you are doing a backup WITH STATS or by GUI, you will not need to use the DMV. But,

Prevent Users From Posting Photos or Videos to Facebook Timeline

Prevent Users From Posting Photos or Videos to Facebook Timeline In this post we will discuss how to Prevent Users From Posting Photos or Videos to Facebook Timeline.This will lead to having inappropriate content on your timeline and on your comments. Luckily, it is possible to disable this feature. Preventing users from posting photos and videos

How To Shutdown Windows 7 Using C Language

How To Shutdown Windows 7 Using C Language In this tutorial we will learn How To Shutdown Windows 7 Using C Language.Here we will write a program in C language to shutdown your Windows 7 system.Earlier i have written How To Shutdown Windows XP Using C Language.It will ask for your input, if your input is

IF Function In Microsoft Excel

IF Function In Microsoft Excel In this post we will discuss or learn how to use IF Function In Microsoft Excel.The “IF” function is a simple and powerful one and helps automate decision making in your spreadsheet. The “IF” function checks if the specified condition is true or false. Syntax: IF(logical_test, [value_if_true], [value_if_false]) Logical_test: [Required] Any value

What Are Transactions In SQL Server

What Are Transactions In SQL Server Transactions are frequently defined as a set of actions that succeed or fail as a whole. To be more specific, transactions can provide four major functions to the data manipulation processes that access the database. 1. Atomicity: When two or more pieces of information are involved in a transaction, either all