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

What is a result set object returned by odbc_exec()?

0 Answers  


What is named calculation? : sql server analysis services, ssas

0 Answers  


How many types of database relationship in sql server?

0 Answers  


What is difference between index seek vs. Index scan?

0 Answers  


Can sql servers link to other servers like oracle?

0 Answers  






Can we call future method from trigger?

0 Answers  


What is SQL Profiler what is the use of it?

2 Answers   247Customer, Steria,


Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

7 Answers   TCS,


How to query multiple tables jointly?

0 Answers  


What method is used by the Command classes to execute SQL statements that return single values?

0 Answers   B-Ways TecnoSoft,


What are the two types of concurrency?

4 Answers  


How to enforce security in sql server? : sql server security

0 Answers  


Categories