If you want to send some data from access database to sql server database. What are different component of ssis will you use?
No Answer is Posted For this Question
Be the First to Post Answer
How to update multiple rows with one update statement in ms sql server?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What does normalization do to data?
Is truncate a dml command?
Explain relational data?
What is identity?
What is logon trigger?
How do I setup a local sql server database?
What area unit the various kinds of info compression introduced in sql server 2008?
What command do we use to rename a db, a table and a column?
Define outer join in sql server joins?
Which sql server table is used to hold the stored procedure script?
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)