Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 are key constraints?

0 Answers  

how to create a scrollable cursor with the scroll option? : Sql server database administration

0 Answers  

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

What are the types of containers in ssis?

0 Answers  

How to rename an existing column with sql server management studio?

0 Answers  

What do you mean by normalisation?

0 Answers  

What are the disadvantages of merge replication?

0 Answers  

How to delete an attribute from the emp table

4 Answers  

Explain how to use linked server?

0 Answers  

What is Data model and how to prepare a data model.?

1 Answers   TCS,

my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 Answers  

what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

0 Answers