Explain how dts is used to extract, transform and consolidate data?
No Answer is Posted For this Question
Be the First to Post Answer
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
List the data types available in mssql?
What are the types of indexes?
Differencr Between DELETE and TRUNCATE?
What is the difference between writing data to mirrored drives versus raid5 drives
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
What is check constraint in sql server?
Mention the different authentication modes in sql server.
What is deploy, process and build? : sql server analysis services, ssas
What is triggers and its types?
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?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)