How to link up the text file to a Database table?
Answer Posted / monal
using linked server or using openrowset command.
Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What is the cartesian product of table?
What is difference between view and materialized view?
What is sql server replication? : sql server replication
What is nonclustered index with included columns ?
What is the difference between varchar and varchar types?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
What the different components in replication and what is their use?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
Explain about remote stored procedure?
What are the steps to follow to configure SQL*Net?
What is the current pricing model of SQL Azure?
What is the difference between a function and a stored procedure?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
Explain system rowset functions?
what is a join? : Sql server database administration