.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Interview Question >> Sql Server >> Post New Question Subscribe to Interview Questions

In How many ways Data can be Export from Sql Table to Excel Sheet?

Posted By :Syed Shakeer Hussain     Posted Date :October 03, 2010    Points :10   Category :Sql Server 
Some of these options include
1) Data Transformation Services (DTS),
2) SQL Server Integration Services (SSIS)
3) Bulk Copy (BCP)
4)OPENROWSET()

You can also find related Interview Question to In How many ways Data can be Export from Sql Table to Excel Sheet?  below: 

You are working with a DataSet and want to be able to display data, sorted different ways. How do you do so?

  
Select the correct answer.

1. Use the Sort method on the DataTable object.
2. Use the DataSet object's Sort method.
3. Use a DataView object for each sort.
4. Create a DataTable for each sort, using the DataTable object's Copy method, and then Sort the result


Correct Answer is :
3. Use a DataView object for each sort. (More...)

How many ways return rows from one table not in another table?

  
There are at least 5 ways to return data from one table which is not in another table. Two of these are SQL Server 2005 and greater only

1)NOT IN

2)NOT EXISTS

3)LEFT and RIGHT JOIN

4)OUTER APPLY (2005+)

5)EXCEPT (2005+)

(More...)

Using query analyzer, name 3 ways to get an accurate count of the number of records in a table?

  
SELECT * FROM table1
SELECT COUNT(*) FROM table1
SELECT rows FROM sysindexes WHERE id = OBJECT_ID(table1) AND indid < 2 (More...)

List commands to copy data from one table to another?

  
-Insert into select
-Select into

are the two commands to copy data from one table to another. (More...)

List the ways you can get total number of records in a table?

  
select count(*) from tablename
select rows from sysindexes where id=OBJECT_ID(tablename) and indid < 2
select * from tablename (More...)

How can you clear a Data from all the table in the dataset?

  
using Dataset.Clear() method you can clear all the data from DataSet (More...)

How to insert single quote at the start and end of every column in excel sheet.

  
use the below formula in the result column like belwo-

Suppose in A2 you have 500 and in B2 you want '500' then do the following-
B2= "'"&A2&"'" (More...)

What is serialization in .NET? What are the ways to control serialization?

  
Serialization is the process of converting an object into a stream of bytes. Deserialization is the opposite process of creating an object from a stream of bytes. Serialization/Deserialization is mostly used to transport objects (e.g. during remoting), or to persist objects (e.g. to a file or database).Serialization can be defined as the process of storing the state of an object to a storage medium. During this process, the public and private fields of the object and the name of the class, including the assembly containing the class, are converted to a stream of bytes, which is then written to a data stream. When the object is subsequently deserialized, an exact clone of the original object is created.
Binary serialization preserves type fidelity, which is useful for preserving the state of an object between different invocations of an application. For example, you can share an object between different applications by serializing it to the clipboard. You can serialize an object to a stream, disk, memory, over the network, and so forth. Remoting uses serialization to pass objects "by value" from one computer or application domain to another.
XML serialization serializes only public properties and fields and does not preserve type fidelity. This is useful when you want to provide or consume data without restricting the application that uses the data. Because XML is an open standard, it is an attractive choice for sharing data across the Web. SOAP is an open standard, which makes it an attractive choice.

There are two separate mechanisms provided by the .NET class library -
XmlSerializer and SoapFormatter/BinaryFormatter. Microsoft uses XmlSerializer for Web Services, and uses

SoapFormatter/BinaryFormatter for remoting. Both are available for use in your own code. (More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

 
Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.


Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend