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

Question Posted / durga prasad

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

More SQL Server Interview Questions

What is the difference between clustered and a non-clustered index?

What is the SQL?????????????????????????????

can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?

What is the significance of master, tempdb and model databases?

Is truncate autocommit?

which backup strategy you are following at ur company

What are the different types of joins and what does each do?

What is self join in sql server joins?

What is a field in a table?

syntax for deleting the database in T SQL

Can store procedure call by user define function in SQL server?

How many ways to create table-valued functions?

For more SQL Server Interview Questions Click Here