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
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
How to find out what is the default collation in a database?
What do you mean by an execution plan? How would you view it?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
How many databases Microsoft SQL server provides?
Tell about MOM Tool(Microsoft Operator Manager)?
How to create user messages with print statements in ms sql server?
what are acid properties? : Sql server database administration
How to change the ownership of a schema in ms sql server?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
What do you know about normalization and de- normalization?
Tell me what is the order in which the sql query is executed?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
What is the use of keyword with encryption. Create a store procedure with encryption?