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

Question Posted / durga prasad

2 Answers
6451 Views
Allianz, I also Faced
E-Mail Answers

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

What is postgresql server?

0 Answers

What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.

5 Answers IBM,

What is row by row processing ?

2 Answers

Can you explain various data region available in ssrs with their use?

0 Answers

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

0 Answers HCL,

If no size is defined while creating the database, what size will the database have?

0 Answers

explain different types of joins? : Sql server database administration

0 Answers

Do you know what is sql service broker?

0 Answers

How to convert character strings into numeric values?

0 Answers

Can we rewrite subqueries into simple select statements or with joins? Example?

2 Answers ASD Lab,

What are the tables in sql?

0 Answers

How can I get data from a database on another server?

0 Answers

For more SQL Server Interview Questions Click Here