Asp.net programming we consider all important topic for knowledge about controls,web Services, JSON, Ajax, database, and interview related Question. In this Asp.net and sql server tutorial blog we give many examples of jquery as like How Play YouTube Video in Your Asp.net Website by URL, How to Play YouTube Videos in Asp.net by using Jquery , Jquery Change div background on mouseover in asp.net , JQuery UI Datepicker (Calendar) etc.

Friday, April 1, 2016

SQL- How to write or create the data into a file or data sql to excel file

SQL- How to write or create the data into a file or data sql to excel file:



Much time we need to import over data in to file, in txt file or excel file. Today we explain it.
In this tutorial blog we also consider




There are a lots of ETL tools available to fetch the data from your database into the file. But these ETL tools are not possible for each one and sometimes, we need to create a file to store the data from our database in SQL.



create the data into a file or data sql to excel file:


In this section, we will learn that how can we write the data into a file (Text or CSV) with the help of SQL.


Note:  'Ole Automation Procedures' component should be turned on as part of the security configuration for your server and a system administrator can enable the use of 'Ole Automation Procedures' by using sp_configure.

If these components are turned off then you can use the following command in your SQL Server Management Studio:

sp_configure 'Ole Automation Procedures', 1
GO
RECONFIGURE;
GO
sp_configure 'show advanced options', 1
GO
RECONFIGURE;

After the above command you will get the following message in SQL-
Configuration option 'Ole Automation Procedures' changed from 0 to 1. Run the RECONFIGURE statement to install.



Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.



Other Related Post:


·                     Features Are in Silverlight Framwork of asp.net
·                     What is Silverlight Framework in asp.net?
·                     What is tree view how to use in asp.net
·                     ASP.net How to use Treeview Code Example
·                     Asp.Net remote Programming,.NET Remoting
·                     Introducing ASP.NET MVC 4 Mobile Features
·                     Installing ASP.NET MVC 4 Development Components
·                     Top Asp.net Question Related to MVC Framework
·                     Software Requirements for ASP.NET MVC 4
·                     ASP.NET MVC framework Benefits
·                     ASP.NET MVC Request Processing
·                     ASP.NET Web Pages
·                     Upload Files Using Ajax AsyncFileUploader In ASP.
·                     how to Save DataTable Into ViewState and Bind Grid.
·                     online currency converter by google API in asp.net.
·                     Simple Method in C# Encryption and Decryption