How to link up the text file to a Database table?

Answers were Sorted based on User's Feedback



How to link up the text file to a Database table?..

Answer / monal

using linked server or using openrowset command.

Is This Answer Correct ?    8 Yes 2 No

How to link up the text file to a Database table?..

Answer / hemendra

using external table

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Which virtual table does a trigger use?

8 Answers   TCS,


Difference Between varchar and nvarchar datatype?

3 Answers   Satyam,


Is INSTEAD OF trigger directly applicable to Table ?

0 Answers  


How to find the last update record in SQL Server?

4 Answers  


Explain the difference between primary keys and foreign keys?

0 Answers  






How do I install only the client tools of sql server 2000?

0 Answers  


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

0 Answers  


Is foreign key unique?

0 Answers  


What is the New in SQL server 2008?

0 Answers  


Differentiate between ms sql server reporting services vs crystal reports?

0 Answers  


How to check table values in sql server?

0 Answers  


what is the Ticketing tool used in Wipro technologies at Bangalore...???

0 Answers   Liquid Hub,


Categories