Explain the use of containers in ssis?
What is trigger and different types of Triggers?
i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?
What types of integrity are enforced by a foreign-key constraint
What do you understand by replication in sql server? Mention the different types of replication in sql server.
Can you please explain the difference between primary keys and foreign keys?
Determine when to use stored procedure to complete sql server tasks?
Explain different types of locks in sql server.
How do I clean up sql server transaction log?
What is a schema in ms sql server 2005?
What is Lock table in SQL?
Can we use max in where clause?
wat new abt truncate in sql server