Explain how dts is used to extract, transform and consolidate data?
No Answer is Posted For this Question
Be the First to Post Answer
What xml support does the sql server extend?
How to provide column names in insert statements in ms sql server?
What is data modification?
What is clustered primary key?
How to create a user name in a database?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
What is explicit cursors?
What are the indexes in sql server?
List the different types of joins?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What is filtered index?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?